How do I reset auto_increment to start at zero 2

[jimoblak]

I have just cleared the contents of a table and the table is retaining the last auto_increment value. How can I get this reset to zero?

The last time I did this I dropped the table and then recreated it. Is there an easier way to get back to zero?

 

[sleipnir214]

How did you clear the table?

If you perform &quot;DELETE FROM <tablename>&quot;, MySQL will drop and recreate the table automatically. The auto_increment field will reset. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[jimoblak]

I threw in a conditional...

DELETE FROM <tablename> WHERE fieldname>1

Being ambiguous as you suggested did the trick. Thanks

 

[taywq]

ALTER TABLE <tablename> AUTO_INCREMENT=1

 

[ingernet]

i tried sleipnir's way, but it kept the last value. taywq's solution did the trick for me!

that is to say, try just deleting, but if that doesn't work, you can beat it into submission.

inger