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
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
On Mon, Jul 13, 2009 at 17:35,
c...@hosting4days.comc...@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
-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
4 matches
Mail list logo