先进入到phpmyadmin当中,或是命令行登入mysql
1.查看表当前auto_increment
select auto_increment from information_schema.tables where table_schema='db name' and table_name='table name';
例子:查看 self_fw_game 库的 fw_game 表 auto_increment
select auto_increment from information_schema.tables where table_schema='self_fw_game' and table_name='fw_game';
2.修改表auto_increment
alter table tablename auto_increment=NUMBER;
例子:修改 self_fw_game 库 fw_game 表 auto_increment为 867
alter table self_fw_game.fw_game auto_increment=867;