« Return to Blog

MySQL: Set Auto Increment Start Value for Mysql Table

Author: Zeeshan Arshad     2354     07/22/2013

Estimated reading time: 0 minutes, 6 seconds

If you want your auto increment field to start from a custom value then use following statement.

ALTER table table_name AUTO_INCREMENT = 123456;