At 7:08 PM -0800 12/3/01, chip wrote:
>I have an existing database, created a while back, which I need to add a id
>field to, there isn't one currently. Will simply adding a new auto-increment
>field be okay? Will the existing rows receive id numbers and will they be
>numbered properly? Or will it start with the new data and continue from
>there? I hope you know what I mean.
>
>--
>Chip

If you're using MySQL, adding an AUTO_INCREMENT column will cause the
column values to be numbered sequentially in the existing rows.

Whether they will be "numbered properly", I have no idea, because yo
  don't define "properly". :-)

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to