MySQL on localhost - Auto Increment 1

[uniopp]

Hi,
Can anyone tell me how/where MySQL running on my localhost (Win XP - Apache2) stores auto increment numbers.
How does it remember what the last number assigned was? I tried deleting all the records in the table but it still remembers what the last auto increment number was and continues on from there.
It must store it somewhere but I don't know where.
I would like to reset the number back to 1 but I'm not sure what to do.
Any ideas?
Thank you.

 

[sleipnir214]

What version of MySQL are you running?

On older versions, performing the query "DELETE from tablename", which deletes all records, is optimized to actually drop and recreate the table. This will reset the counter.

On newer versions, you'll have to issue the query: ALTER TABLE foo auto_increment=1

Want the best answers? Ask the best questions!

TANSTAAFL!!