How to reset the auto increment number/column in a MySql table
mysql, sql
Solution
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
Problem
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 ```