Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

Re: [PHP-DB] AUTO INCREMENT - MySQL + PHP From: Matthew Ballard (Matthew <email protected>)
Date: 12/13/00

I'm not sure if there's a way to automatically do it without changing the
structure of the table, but you could delete the column and recreate it,
which when the auto_increment is used in creating a column, it'll
automatically number it.
Matthew

At 02:14 PM 12/14/2000 +1030, you 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. 

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