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. Link to comment https://forums.phpfreaks.com/topic/125880-inserting-or-updating-a-record-using/ 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 Link to comment https://forums.phpfreaks.com/topic/125880-inserting-or-updating-a-record-using/#findComment-650951 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.