Published in: SQL
URL: http://ariejan.net/2007/11/30/mysql-reset-the-auto-increment-value-of-a-table/
ALTER TABLE some_table AUTO_INCREMENT=10000
You need to login to post a comment.
SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
willbolton on 07/01/08
4 people have marked this snippet as a favorite
JimiJay
romanos
heinz1959
wizard04
Published in: SQL
URL: http://ariejan.net/2007/11/30/mysql-reset-the-auto-increment-value-of-a-table/
ALTER TABLE some_table AUTO_INCREMENT=10000
You need to login to post a comment.