RE: [PHP] mod primary key field - newbie question

-Original Message- From: Floyd Resler [mailto:fres...@adex-intl.com] Sent: Monday, July 13, 2009 5:41 PM To: c...@hosting4days.com Cc: php-general@lists.php.net Subject: Re: [PHP] mod primary key field - newbie question Sounds like you want to set the auto increment. To do that, use

Re: [PHP] mod primary key field - newbie question

On Mon, Jul 13, 2009 at 17:35, c...@hosting4days.com wrote: > newbie question ... I have a MySQL table where I want to update (renumber) > the primary numeric key field. The response you received from Floyd was accurate, but next time, please keep these kinds of questions on the appropriate li

Re: [PHP] mod primary key field - newbie question

Sounds like you want to set the auto increment. To do that, use this query: alter table `table_name` auto_increment 1; That will reset it to one. Although I've never tried it, I assume you can give it another value. Take care, Floyd On Jul 13, 2009, at 5:35 PM, c...@hosting4days.com wrot

[PHP] mod primary key field - newbie question

newbie question ... I have a MySQL table where I want to update (renumber) the primary numeric key field. - I successfully turned field off as a primary key index and UN auto incremented it - then created new sequential numbers for it - then turned back on primary key index and re added auto