MySQL重新排列自增id ALTER TABLE `your_tablename` DROP COLUMN `your_column`; ALTER TABLE `your_tablename` ADD `your_column` INT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;