mysql> show databases;
34 rows in set
mysql> use cxg;
Database changed
mysql> ALTER TABLE cxg AUTO_INCREMENT = 1;
Query OK, 0 rows affected
Records: 0 Duplicates: 0 Warnings: 0
SQL 查询:
ALTER TABLE tablename AUTO_INCREMENT =1
tablename就是需要重置auto_increment的表