How to reset AUTO_INCREMENT in MySQL?

Posted by Editorial Staff | Updated on

If you want to reset AUTO_INCREMENT in MySQL? Use the below MYSQl query. For InnoDB you cannot set the auto_increment value lower or equal to the highest current index.

Note that you cannot reset the counter to a value less than or equal to any that have already been used. For MyISAM, if the value is less than or equal to the maximum value currently in the AUTO_INCREMENT column, the value is reset to the current maximum plus one. For InnoDB, if the value is less than the current maximum value in the column, no error occurs and the current sequence value is not changed.


If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.

Related Questions & Answers