MySQL Forums
Forum List  »  Triggers

Re: Pre-DML trigger vs Foreign keys
Posted by: Peter Brawley
Date: June 24, 2012 08:04AM

> Her point is instead of using 2 foreign keys we can get it done from single select statement.

Nonsense on stilts. A foreign key is faster, requires less code than the three triggers that would be required to replicate its functionality, is less error-prone, and works in all environments (many shared hosting providers screw up trigger implementations).

Options: ReplyQuote

Written By
Re: Pre-DML trigger vs Foreign keys
June 24, 2012 08:04AM

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.