[SOLVED] Altering a foreign key
Posted: Mon Jan 08, 2007 4:34 am
When I created the structure of my MySQL database I chose to ignore the clause ON DELETE ... BIG mistake
Now I have to modify a number of foreign key to include this. I tried the ALTER COLUMN, MODIFY, but they didn' t work. I' m thinking of saving the data in the tables, droping the tables and create them again the right way. I' m not going to do this unless there won' t be other options.
Do you have any other ideas.
Now I have to modify a number of foreign key to include this. I tried the ALTER COLUMN, MODIFY, but they didn' t work. I' m thinking of saving the data in the tables, droping the tables and create them again the right way. I' m not going to do this unless there won' t be other options.
Do you have any other ideas.