How do I change the type of a Foreign Key column? (2 replies)
(MySQL.com) Here is what I am trying to do:
Table1 has primary key col1 of type INT
Table2 has a foreign col2 to parent Table1.col1
Now I changed the type of Table1.col1 to a user defined type: my_unique_id
What I want is a script that will change the type
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:12:25
