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
Thats how its supposed to work. It won't reuse old numbers even after you
delete the entire row.
Adam
On Tue, 27 Aug 2002, 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
Hi simon
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
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
