The behavior differs between ISAM tables and MyISAM ones. Its all in the
manual.
> -----Original Message-----
> From: Bard dZen [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, February 28, 2001 1:23 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: auto_increment
>
> Well it isn't. I created a table with auto_increment, added 25 records,
> deleted 5, did an insert, and the next auto number was 21.
>
>
> >From: Steve Ruby <[EMAIL PROTECTED]>
> >To: John Tsangaris <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED]
> >Subject: Re: auto_increment
> >Date: Mon, 26 Feb 2001 15:02:38 -0700
> >
> >John Tsangaris wrote:
> > >
> > > If I turn on auto increment and let it do it's thing and then later on
> > > delete a few of the entries (let's say 1, 2, 3) and the current high
> >entry
> > > has an id of 45.. why does mysql continue with 46 instead of using up
> 1,
> >2,
> > > and 3 first? Is there a way to bypass this?
> > >
> > > John
> >
> >
> >To avoid duplication of those keys in many cases. For example if you
> >archived 1,2,3 and removed them from the table you may want to add them
> >back
> >in and you don't want their ID's to be taken. Or you may have references
> >to 1,2,3 in other tables, if you delete them it would be wrong
> >for the references to point to the new 1,2,3. Of course you should
> probably
> >delete the references but if you didn't it would be confusing that
> >you had pointers to the wrong lines.
> >
> >The point is that auto_increment generates UNIQUE values, and those
> >values should be unique for the life of the table, not pending deletes.
> >
> >---------------------------------------------------------------------
> >Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail
> ><[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
