Change auto increment id MySQL

Change auto increment id MySQL


 


 How to Change auto increment id 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 Change auto increment value to 1


 


ALTER TABLE users AUTO_INCREMENT=1;

 


solved