Re: Database design, how to update foreign keys?
Posted by: Bob Field
Date: July 21, 2006 08:40AM

when you add a row on the primary side of the relationship, no changes occur on the foreign side. If you update or delete information on the primary side, it depends on if you have ON UPDATE or ON DELETE actions specified. These actions have to be declared as part of the foreign key.

http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Database design, how to update foreign keys?
July 21, 2006 08:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.