MySQL reset auto increment

MySQL reset auto increment


 


 How to reset auto increment value in MySQL?


 


Answer


 



Auto-increment allows a unique number to be generated automatically when a new record is inserted into a table


 


Use this Statement to reset auto increment value to 1


 


ALTER TABLE users AUTO_INCREMENT=1;

 


solved