List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 28 2003 5:09pm
Subject:Re: Resetting Autoincrement.
View as plain text  
At 5:54 -0700 4/28/03, Prabu Subroto wrote:
>Dear my friends....
>I have a column with auto_increment, namely "SalesID".
>I want to know how to reset the auto_increment.
>For example:
>I have 20 persons who work as our sales. So it means
>the last SalesID is 20.
>If I delete the last row of SalesID (20) and insert a
>new one than it will start not from 20 but from 21.
>Where as I want it starts back from 20.
>The second question is: "Is it possible to make the
>MySQL (3.23.55) reset the auto_increment

Automatically?  No.  Why do you want to, anyway?  (Why bother?)

Paul DuBois
sql, query
Resetting Autoincrement.Prabu Subroto28 Apr
  • Re: Resetting Autoincrement.Paul DuBois28 Apr
  • Re: Resetting Autoincrement.Gabriel-Dumitrel MOSCALU29 Apr
    • RE: Resetting Autoincrement.Daevid Vincent29 Apr
      • Re: Resetting Autoincrement.Joel Rees30 Apr
    • Re: Resetting Autoincrement.Prabu Subroto29 Apr
Re: Resetting Autoincrement.Prabu Subroto28 Apr
  • re: Re: Resetting Autoincrement.Victoria Reznichenko29 Apr
    • re: Re: Resetting Autoincrement.Prabu Subroto5 May