[摘要]+----------------+1 row in set (0.04 sec)修改表auto_increment例子：修改 test_user 库 user 表 auto_increment为 ...
+----------------+1 row in set (0.04 sec)修改表auto_increment例子：修改 test_user 库 user 表 auto_increment为 10000 mysql> alter table test_user.user auto_increment=10000;
Query OK, 0 rows affected (0.12 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> select auto_increment from information_schema.tables where table_schema='test_user' and table_name='user';
+----------------+ |
关键词： 如何通过MySql查看与更改auto_increment的办法