AUTO INCREMENT - MySQL + PHP
| From: | Scott Mebberson | Date: | Thu, 14 Dec 2000 03:44:21 +0000 |
| Subject: | AUTO INCREMENT - MySQL + PHP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5225@lists.php.net to get a copy of this message | ||
Hi Guys,
I am using the AUTO INCREMENT attribute on one of my cols. I need to know
how I can clean this up. For example, just say I have rows with the
elementID's of 1, 2, 3, 4, 5, 6, 7, 8 and then I delete 3, 6 and 7.
Is there some command I can call using PHP that will re-eval the elementID
col to reorder them so it became 1, 2, 3, 4, 5
Thanks
Scott.