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:
>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?
>PHP Database Mailing List (
>To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to