Is there a way to reset a table?
I mean not only deleting all rows, but starting the auto_incrementing ID back to 0?
+8
A:
To remove all data:
TRUNCATE TABLE tablename
To reset the auto-increment:
ALTER TABLE tablename AUTO_INCREMENT = 1
RedFilter
2010-06-30 15:40:26
As long as you're at v. 5.0.13 or later, the auto increment value is reset automatically by TRUNCATE TABLE. Prior to that it might be reset as long as there are no FKs into the truncated table (a "fast" truncate is used).
Tom H.
2010-06-30 15:43:18
@Tom H. I am on 5.0.77 I just checked. So I just need to call the truncate line then. What are FKs?
John Isaacks
2010-06-30 15:55:09
FK = foreign keys - which are references to the primary keys of other tables
CaseySoftware
2010-06-30 15:55:09