That got me thinking...say you have a list of 500 people, and you delete
the
person with id 500 (The Person with the very last ID). Now, your ID's go
up
to 499. Now say someone else is added. Would they have an id of 500 or
501? For me it would be 500, which would create a security problem, but I
very well could be doing something wrong. Is this a typical behavior?
> > Dear William,
> >
> > > The problem is...if I delete the third entry (Edicao = 3), the next
> > > entry inserted should be 3, right?! Well it is not! It is 4. So I get
> > a
> > > table like this...
> > > +--------+
> > > | Edicao |
> > > +--------+
> > > | 1 |
> > > | 2 |
> > > | 4 |
> >
> > This is not a bug, it's a feature. Assume something like "staff number"
> > being an auto_increment column. Staff # 1234 gets layed off, all the
> > payments are cancelled, no holidays for # 1234 any more etc. Now, a new
> > employee gets the "empty" staff number 1234. He will never get his
> > salary, and no vacations at all, because he was layed off before he was
> > employed. This kind of confusion will not happen with auto_increment.
> >
> > So, if you need things to be like "1 2 3 4 ..." you will have to use
> > this statement:
> >
> > INSERT INTO my_table (Edicao) VALUES (last_insert_id + 1)
> > resp.
> > ... VALUES (MAX(Edicao) +1)
> >
> > Regards,
> >
> > --
> > Stefan Hinz
> > Geschäftsführer / CEO iConnect e-commerce solutions GmbH
> > # www.js-webShop.com www.iConnect.de
> > # Gustav-Meyer-Allee 25, 13355 Berlin
> > # Tel: +49-30-46307-382 Fax: +49-30-46307-388
> >
> > ----- Original Message -----
> > From: "William N. Zanatta" <[EMAIL PROTECTED]>
> > To: "mysql" <[EMAIL PROTECTED]>
> > Sent: Friday, July 20, 2001 9:53 PM
> > Subject: auto_increment, is this a bug?? Where to report it?
> >
> >
> > > Hello guys...
> > >
> > > I'm having problem with the auto_increment feature.
> > > I have a table like this...
> > >
> > >
> > +--------+-----------------+------+-----+------------+----------------+
> > > | Field | Type | Null | Key | Default | Extra
> > > |
> > >
> > >
> > +--------+-----------------+------+-----+------------+----------------+
> > > | Data | date | | | 0000-00-00 |
> > > |
> > > | Edicao | int(3) unsigned | | PRI | NULL |
> > auto_increment
> > > |
> > > | Status | varchar(6) | | | |
> > > |
> > >
> > >
> > +--------+-----------------+------+-----+------------+----------------+
> > >
> > > When I make entries to this table, the column Edition goes...
> > > +--------+
> > > | Edicao |
> > > +--------+
> > > | 1 |
> > > | 2 |
> > > | 3 |
> > > +--------+
> > > as expected.
> > > The problem is...if I delete the third entry (Edicao = 3), the next
> > > entry inserted should be 3, right?! Well it is not! It is 4. So I get
> > a
> > > table like this...
> > > +--------+
> > > | Edicao |
> > > +--------+
> > > | 1 |
> > > | 2 |
> > > | 4 |
> > > +--------+
> > >
> > > Well, I tested it on 2.33.37, 2.33.38 and 2.33.39. In 2.33.37 it was
> > > right...the entry was 3. But in the newer versions the number was 4.
> > > It's like the auto_increment pointer didn't do the decrement when I
> > > deleted the last entry.
> > > Is this a bug?! Where should it be reported to?
> > > Thank you all...
> > >
> > > William N. Zanatta
> > >
> > > ---------------------------------------------------------------------
> > > 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
> >
> >
>
---------------------------------------------------------------------
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
