Checl your MySQL docs and redefine the table if necessary: table type of ISAM - autoincrement numbers get reused table type of MyISAM - autoincrement numbers are not reused.
Many people prefer the latter and use the values as primary and foreign keys. Miles Thompson At 05:21 PM 8/27/2002 +0200, simon wrote: >Hi > >Wondering if anybody can help with this: > >My table has an INT column named 'member_id' which is set to AUTO_INCREMENT. >It works very well but I have inserted and deleted some test rows during the >development stage and now my incremented numbers have jumped ahead. >The deleted rows (their member_id values) have not been forgotten it seems >and the DB is using them still to evaluate the next number. > >Any ideas? > >Simon > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php