Reset auto increment for a table in MySQL
ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234
That was easy. Someone posted the command in the comments for the Using Auto Increment page in the MySQL manual. I often find that the comments are more helpful than the manual.
Labels: mysql
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home