How To Reset MySQL Auto_Increment Column?

 Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 323 | Points: 40
Answer:

Alter table syntax provides a way to reset Auto_Increment column.
For Example:-
Alter Table table_name AUTO_INCREMENT = 1;

So,it will again start with 1.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response