1,重置值
ALTER TABLE table_name AUTO_INCREMENT = 1;
2,重置表结构
TRUNCATE TABLE table_name;
3,删除重建表
DROP TABLE table_name;
CREATE TABLE table_name { ... };
参考:
http://viralpatel.net/blogs/reseting-mysql-autoincrement-column/
1,重置值
ALTER TABLE table_name AUTO_INCREMENT = 1;
2,重置表结构
TRUNCATE TABLE table_name;
3,删除重建表
DROP TABLE table_name;
CREATE TABLE table_name { ... };
参考:
http://viralpatel.net/blogs/reseting-mysql-autoincrement-column/