Re: AUTO INCREMENT - MySQL + PHP

This only can be done if there is no relationship involving this table on this field to any other. Jayme. http://www.conex.com.br/jjeffman -----Mensagem Original----- De: Paul DuBois <paul@snake.net> Para: Scott Mebberson <scott@redbluedesign.com>; <php-db@lists.php.net> Enviada em: terça-feira, 19 de dezembro de 2000 20:19 Assunto: Re: [PHP-DB] AUTO INCREMENT - MySQL + PHP > 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 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >