List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 26 2001 10:40pm
Subject:Re: Reset Auto Increment
View as plain text  
At 6:03 PM -0500 9/25/01, mickalo@stripped wrote:
>Hi All,
>I seen a post a few days ago on how to set the auto increment value 
>back to one
>after deleting all the data from a table. I suppose I could just re-create the
>table, but thought it be simpler to just alter the table to reset the auto
>increment value back to 1. what exactly is the "alter" syntax to reset it??

If you saw a post, then the link at the bottom of each message indicates
how to get to the list archive.  You'll find the answer there.  Often
a useful strategy.  In any case, the answer is:


>mysql database
>Thunder Rain Internet Publishing
>Providing Internet Solutions that work!
>Tel: 1(225)686-2002
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread86380@stripped>
>To unsubscribe, e-mail <>
>Trouble unsubscribing? Try:

Paul DuBois, paul@stripped
Reset Auto Incrementmickalo26 Sep
  • RE: Reset Auto Incrementjohnlucas-Arluna26 Sep
  • Re: Reset Auto IncrementPaul DuBois27 Sep