CoderZone.org

Category: >> mySQL >> Reset auto increment value Bookmark and Share

<< lastnext >>

Snippet Name: Reset auto increment value

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

Comment: (none)

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

ALTER TABLE table_name AUTO_INCREMENT=1;
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 7