Reset auto_increment ?

[MichaelHe]

I have made i site with a MySQL database.
After a lot of test my auto_increment field with an ID number in it, is up to 56.

Now I have delete all the tests, og the database is now empty. But now the first thing to be registret get's the ID 57.
Isn't there a way to reset it, without having to delete the field and making it again ?

[Drakla]

alter table test.catoss auto_increment = 0;

If you truncate the table it goes back to zero, but remember when you're in a real world situation you don't want to reset it if you have other tables using the value as a foreign key.

[barand]

DELETE FROM tablename

Should do it.

MySQL manual, Create Table, auto_incement wrote:

If you delete all rows in the table with DELETE FROM table_name (without a
WHERE) in AUTOCOMMIT mode, the sequence starts over for all table types.

[discostudio]

ALTER TABLE tablename AUTO_INCREMENT =1

// where you want to restart the count at 1.