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.
At 05:21 PM 8/27/2002 +0200, simon wrote:
>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.
>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