Reset auto increment column
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.