alter table `表名` drop column id;
alter table `表名` add id int (11) auto_increment primary key;
来源:https://blog.csdn.net/Connie1451/article/details/80020484
alter table `表名` drop column id;
alter table `表名` add id int (11) auto_increment primary key;
来源:https://blog.csdn.net/Connie1451/article/details/80020484