Piotr is right. SQL shouldn't let you do that, if only for possible consistency errors. Imagine if you had id 3 referenced in some other table and then you put new data in the primary table with id of 3. Then all the other stuff referring to 3 would then refer to the new data. Not a good thing.
I've been digging through an SQL book lately... some mind bending (but extremely logical) information. -Dash Don't look back, the lemmings are gaining on you. On Fri, 17 Jan 2003, Piotr Pluciennik wrote: > Hi, > > I don't use MYSQL, but the problem is common for > databases. One of the idea of auto increment field is > to have unique identifiers, so you can't insert a > record with auto increment fields set by yourself. > It's always done by DB. So you can't fill a "hole" in > numbering after deleting record. Of course in a normal > way of using DB... :-) > > HTH > > Piotr > > --- Bobo Wieland <[EMAIL PROTECTED]> wrote: > > I hope this isn't to much OT... Sorry if it is... > > > > In my MySQL-db that I use for a php-driven site I > > have many tables with the > > Primary Key set as an auto increment value. > > > > If I have 4 records with id 1, 2, 3 and 4 and then > > delete number 3 and add > > one more record I get the id's 1,2,4 and 5. It isn't > > much of a problem, but > > it would be nice to check for the first "hole" in > > the id's and insert the > > record there instead. How would you do this? is > > there some simple way from > > either MySQl or PHP that doesn't take to much time > > to execute? > > > > thanks in advance > > > > > > . bobo . www.elstudion.com . [EMAIL PROTECTED] . > > > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
