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 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
