Change auto increments starting number

Posted At : January 21, 2010 10:46 PM | Posted By : Andy Jarrett
Related Categories: MySQL

If you ever have the need to change the starting number on a auto increment column (on a MySQL table) its pretty simple

ALTER TABLE tablename AUTO_INCREMENT = 12345

1 ALTER TABLE tablename AUTO_INCREMENT = 12345

Linking Blogs | 908 Views

TweetBacks

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

Andyjarrett.com. ColdFusion developer and general beta whore. If it moves on the web i'll try and consume it