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]