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