MySQL Auto Increment Seed

How do I change the auto increment seed number in MySQL? The higher ups have voted against me on database design standards and now I have the need to start a AI field at 222000000, and I can't figure out how to do this.

Any and all help is appreciated. BTW it's MySQL running on windows.
gnixon14Asked:
Who is Participating?
 
Dave BaldwinFixer of ProblemsCommented:
If it is a MyISAM table, you can use MySQL Administrator and it's Table Editor and change it in the Advanced Options tab.
0
 
Dave BaldwinFixer of ProblemsCommented:
If you have phpMyAdmin, you can change it on the 'Operations' page for the table.  In either case, you need to make sure your column is at least int(9) to display all the numbers.
0
 
IngCharlieCommented:
OR USE THE SQL:

ALTER TABLE `your_table` AUTO_INCREMENT =222000000
0
 
gnixon14Author Commented:
Excellent, thank you so much. I tried the sames setting in the MySQL workbench and it didn't work, but MySQL admin came thru. Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.