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:

ALTER TABLE 'table name' AUTO_INCREMENT = 1;

(source)

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.