List:General Discussion« Previous MessageNext Message »
From:Chris Date:September 21 2006 3:45am
Subject:Re: How to delete all rows....
View as plain text  
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.
Thread
How to delete all rows....ravi.karatagi20 Sep
  • Re: How to delete all rows....Dan Trainor20 Sep
  • Re: How to delete all rows....Praj20 Sep
  • RE: How to delete all rows....Peter Lauri20 Sep
Re: How to delete all rows....Chris20 Sep
RE: How to delete all rows....Peter Lauri20 Sep
RE: How to delete all rows....cknipe20 Sep
RE: How to delete all rows....Pradeep Chandru20 Sep
Re: How to delete all rows....Douglas Sims20 Sep
Re: How to delete all rows....CBTS) GEAE20 Sep
  • Re: How to delete all rows....Chris21 Sep
Re: How to delete all rows....Dilipkumar22 Sep
  • Re: How to delete all rows....Chris26 Sep
    • Re: How to delete all rows....mos26 Sep
      • Re: How to delete all rows....Chris26 Sep