MySQL AUTO INCREMENT feature
| From: | Scott Mebberson | Date: | Thu, 14 Dec 2000 05:24:53 +0000 |
| Subject: | MySQL AUTO INCREMENT feature | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30246@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.