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

2009-07-13 Thread Marc Christopher Hall
-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

2009-07-13 Thread Daniel Brown
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

2009-07-13 Thread Floyd Resler
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