is it possible to reset Auto INCREMENT?

[godonholiday]

i was wondering if it was possible to reset the increment back to 0, once all the data in the table is deleted??

thanks in advance
g

[psyon]

I believe it is:

ALTER TABLE stuff AUTO_INCREMENT=1;

[vgarcia]

If all the data is deleted:

TRUNCATE TABLE whatever;

http://dev.mysql.com/doc/mysql/en/TRUNCATE.html

[godonholiday]

thanks, is it possible to this without deleting the data do you kow?

[psyon]

ALTER TABLE stuff AUTO_INCREMENT=1;

That will reset the AUTO_INCREMENT value to 1 or what ever the highest current value in the table is +1;