Re: AUTO_INCREMENT problemos

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