mysql ID自动增量不从0开始 [英] mysql ID auto increment doesn't starts from 0
问题描述
我有一个表ID,这个ID是自动递增和主键,第一次插入到该表,ID从0开始,但是我从该表中删除所有的值,并再次插入到它, ID不从0开始,而是从ID的最后一个值开始,出现了什么错误?
可以将值重置为0?
i have a table with ID , this ID is auto increment and primary key ,the first time i inserted to that table , the ID starts from 0 , but after i removing all the values from that table and inserted again to it , the ID doesn't start from 0 , but starts from the last value that ID had , what is going wrong please ? can i reset the value to 0 ?
推荐答案
您可以使用
TRUNCATE `table`
Truncate将删除表中的所有数据。请注意,使用 TRUNCATE
也不会触发任何DELETE触发器,例如 DELETE
。
Truncate will delete all of the data in the table. Note that using TRUNCATE
will also not fire any DELETE triggers like DELETE
.
或者您可以使用
ALTER TABLE `table` AUTO_INCREMENT = 1
但是这是预期的行为。不要做后者,除非表格真的为空。
It is however the expected behavior. Don't do the latter unless the table is truly empty.
这篇关于mysql ID自动增量不从0开始的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!