Change MySQL auto increment value

May 15, 2016 | 339 views | Comments

There may be times when you would like to update the auto increment value of a MySQL TABLE, for example, when you made updates to your data. Below is how you can update an auto increment value.

ALTER TABLE TABLE_NAME AUTO_INCREMENT=1;

Related Tutorials


Must Read