Reset auto increment column

AUTO INCREMENT

We are here to help you in resetting the autoincrement column in a table

Run the following querry after changing the name of the table.

SET  @num := 0;
UPDATE table_name SET id = @num := (@num+1);
ALTER TABLE table_name AUTO_INCREMENT =1;

id is the name of the auto increment column. 

Please do comment if you face any problem in executing the querry. 

Share the post


Leave Comment