Re: AUTO_INCREMENT problemos
| From: | DL Neil | Date: | Tue, 27 Aug 2002 16:45:31 +0000 |
| Subject: | Re: AUTO_INCREMENT problemos | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21397@lists.php.net to get a copy of this message | ||
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