Re: How to delete all rows....

[Chris]

Wagner, Chris (GEAE, CBTS) wrote:
> But how will that interact with the auto increment counter?  Will
> truncate reset the counter.

According to the docs it will:

http://dev.mysql.com/doc/refman/5.1/en/truncate.html

The table handler does not remember the last used AUTO_INCREMENT value, 
but starts counting from the beginning. This is true even for MyISAM and 
InnoDB, which normally do not reuse sequence values.