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 forgotten it seems > and the DB is using them still to evaluate the next number.
Assuming we're talking about MySQL, ALTER TABLE will do the biz: http://www.mysql.com/doc/en/ALTER_TABLE.html Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
