Re: [PHP-DB] AUTO INCREMENT - MySQL + PHP From: Paul DuBois (paul <email protected>)
Date: 12/19/00

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 <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>