mysql中的auto_如何重置MySQL中的AUTO_INCREMENT？

如何重置字段的AUTO_INCREMENT？我希望它再次从1开始计数.

解决方法:

您可以使用以下命令重置计数器

ALTER TABLE tablename AUTO_INCREMENT = 1

对于InnoDB,您不能将auto_increment值设置为低于或等于当前最高索引. (引自ViralPatel)：

Note that you cannot reset the counter to a value less than or equal

to any that have already been used. For MyISAM, if the value is less

than or equal to the maximum value currently in the AUTO_INCREMENT

column, the value is reset to the current maximum plus one. For

InnoDB, if the value is less than the current maximum value in the

column, no error occurs and the current sequence value is not changed.

标签：sql,mysql,auto-increment

来源： https://codeday.me/bug/20190911/1802863.html