Reset autoincrement field

[Anon]

Hi. How can i reset an autoincrement field in MySQL back to "0"? If i delete all the data in the table it stills continues from the last value it was set.

Thanks.
John

[denvervender]

Since you've delete the data on the table. I suggest that you should drop and re-create the table. In this case the autoincrement field will reset to "0".

[Anon]

Try this ...

alter table_name auto_increment=0