Reset auto increment on a table - SQL Snipplr Social Repository

Revision: 4068

at October 19, 2007 16:35 by jachin

Initial Code

ALTER TABLE tbl AUTO_INCREMENT = 1;

Initial URL

http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

Initial Description

If you are deleting all the rows in a table and you also want to reset the values that will get used by auto increment, this is how to do it.

Initial Title

Reset auto increment on a table

Initial Tags

sql

Initial Language

SQL