MySQL——修改一个表的自增值

语句

alter table <table name> auto_increment=<value>;

示例

mysql> alter table tb_user auto_increment=100000;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 2