ok Posted September 26, 2008 Share Posted September 26, 2008 Hi MySQL gurus I read my book 5 times. and it suggested that updating a one to many table using direct or conventional UPDATE is not recommended. Even though this approach is ok but, It says that the most recommended is using the CASCADE in defining a foreign key for one to many relationship. The problem is my book unfortunately did not provide a good example for this scenario, on how to update tables using CASCADE. Can you show me good example on how this is done properly? Thank you very much. Quote Link to comment Share on other sites More sharing options...
elflacodepr Posted September 26, 2008 Share Posted September 26, 2008 Hello I hope this help: http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.