That's also what I mean. But lookslike that I have to
reset the auto_increment manually.
--- Gabriel-Dumitrel MOSCALU
> Hi there,
> Based on this subject, i would have another
> What if I delete all records, would it be possible
> to reset the
> auto_increment? (as a reson of why, I just like
> having the things done
> ----- Original Message -----
> From: "Paul DuBois" <paul@stripped>
> To: "Prabu Subroto" <prabusubroto@stripped>;
> Sent: Monday, April 28, 2003 7:09 PM
> Subject: Re: Resetting Autoincrement.
> > At 5:54 -0700 4/28/03, Prabu Subroto wrote:
> > >Dear my friends....
> > >
> > >I have a column with auto_increment, namely
> > >I want to know how to reset the auto_increment.
> > >For example:
> > >I have 20 persons who work as our sales. So it
> > >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
> > >Where as I want it starts back from 20.
> > >
> > >The second question is: "Is it possible to make
> > >MySQL (3.23.55) reset the auto_increment
> > >automatically?
> > Automatically? No. Why do you want to, anyway?
> (Why bother?)
> > --
> > Paul DuBois
> > http://www.kitebird.com/
> > sql, query
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.