``` -- 先删除字段id alter table `表名` drop column id; -- 再添加字段id ALTER TABLE `表名` ADD `id` INT ( 10 ) UNSIGNED NOT NULL PRIMARY KEY auto_increment COMMENT '主键' first; alter table `table` AUTO_INCREMENT = 1; ```