Re: AUTO INCREMENT - MySQL + PHP
| From: | Paul DuBois | Date: | Tue, 19 Dec 2000 22:19:00 +0000 |
| Subject: | Re: AUTO INCREMENT - MySQL + PHP | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5344@lists.php.net to get a copy of this message | ||
At 2:14 PM +1030 12/14/00, Scott Mebberson wrote:
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.Why do you want to? MySQL doesn't care if the values are sequential. You can drop the column and add it again if you really want to do this. -- Paul DuBois, paul@snake.net