ALTER TABLE tablename
DROP COLUMN id;
ALTER TABLE tablename ADD id mediumint(8) NOT NULL PRIMARY KEY auto_increment FIRST;
还是会删掉这一列,然后重新添加主键~~~
下面是自用的代码
DELETE
FROM yonghu
WHERE endtime <CURDATE();
ALTER TABLE yonghu
DROP COLUMN id;
ALTER TABLE yonghu ADD id mediumint(8) NOT NULL PRIMARY KEY auto_increment FIRST;