MySQL Resetting the index count to 0

Question

I need to reset my table counter back to 0 - is there a MySQL command for this?

Answer 1

That's easy:

ALTER TABLE tablename AUTO_INCREMENT=0;

Answer 2

You can also use the TRUNCATE statement. It will remove all the data and reset the auto increment.

TRUNCATE TABLE [TableName];

Is the same as

DELETE * FROM [TableName];
ALTER TABLE [TableName] AUTO_INCREMENT = 0;