Need modifications to an existing table

~~asdfghjkl~~ · January 19 '10, 12:18 PM (#1)

Hi everyone. I'm very new to mysql and php, learning as I go. Working on a database which has a problematic design oversight. The primary key is a combination of two fields, on the assumption that these fields would never be the same, but that is not the case as I find the need to create multiple records with identical values in these fields

So I want to alter this table, to add a new AUTO INCREMENT column, and change the primary key to that. The table currently has just under 10,000 records in it which are valuable, so I can't afford to mess this up. Can anyone advise as to what I should do? I'd assume the ALTER query will be needed.

Thank you in advance for replies

**mlseim** · January 19 '10, 04:17 PM (#2)

Do you have access to the MySQL admin control panel?

With that, you can make a safe backup to begin with ...
then add the new column with the variable parameters you want.
It will automatically number them all in order ... unique numbers.

~~asdfghjkl~~ · January 19 '10, 11:24 PM (#3)

Thanks Mr. Mlseim. Very good your advise, may be its useful for me.

PHP

Need modifications to an existing table