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
