AUTO_INCREMENT problemos
| From: | simon | Date: | Tue, 27 Aug 2002 15:21:07 +0000 |
| Subject: | AUTO_INCREMENT problemos | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21395@lists.php.net to get a copy of this message | ||
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