MySQL: Set Auto Increment Start Value for Mysql Table

Author: Zeeshan Arshad     2028     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;


Was this topic helpful?

Yes
No
Subscribe YouTube Channel

Zeeshan Arshad is a self-taught and multi-dimensional person with extraordinary track record of success with international clients and students.

Feel free to contact him for your project, training purpose or guidance.