mySQL: Reset auto increment value - This resets the AUTO-INCREMENT value for a given table.

Quick Search:

mySQL: Reset auto increment value

Jump to:

Snippet Name: Reset auto increment value

Description: This resets the AUTO-INCREMENT value for a given table.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

ALTER TABLE table_name AUTO_INCREMENT=1;