Setting auto_increment counter

Here’s a sql query to set the auto_increment counter:

ALTER TABLE theTableInQuestion AUTO_INCREMENT=1234

Posted on August 7, 2004 by admin in MySQL