How To Reset MySQL Auto_Increment Column?

Posted by vishalneeraj-24503 on 10/7/2014 | Category: Sql Server Interview questions | Views: 1816 | 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

Bookmark It

< Previous : Which Database is a system Database which is used ...

Next > : How to Create a New Table From Another Table in Sq ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions