mysql 重置自动编号,如何重置MySql表中的自动递增编号/列

The item_category_id column is auto increment value in the mysql table.

I need to delete all the values & next insertion should start from 1. If i delete all values & try to insert a new row then it starts with some 30's & 40's.

item_category_id item_category_name

1 qqq

25 ccc

32 vvv

29 bb

4 bbb

31 hhh

34 mmm

33 rrr

解决方案ALTER TABLE TABLENAME AUTO_INCREMENT = 1

Instead of using Delete if you use Truncate that will remove data and will also reset autoincrement.

TRUNCATE TABLE TABLENAME