Skip to content

Reset AUTO_INCREMENT in MySQL

After you, for example truncated it, you can reset the AUTO_INCREMENT value with this SQL statement:

[sc name=”src” url=”https://stackoverflow.com/questions/8923114/how-to-reset-auto-increment-in-mysql” ]

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.