List:General Discussion« Previous MessageNext Message »
From:Prabu Subroto Date:April 28 2003 12:54pm
Subject:Resetting Autoincrement.
View as plain text  
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?

Thank you very much.

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Thread
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