Tuesday, May 22, 2012

How to reset auto increment column in mysql table

Here item_category_id is auto increment value in the mysql table. Now i need to delete all the values & next insertion should start from 1. Now 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




No comments:

Post a Comment