MySQL Forums
Forum List  »  Triggers

Re: Enforce business rule with before insert trigger?
Posted by: Hasani Blackwell
Date: January 04, 2006 12:50PM

Apparently Andrew found a good solution months later -->,55023,55023#msg-55023


Re: DO NOTHING in a trigger
Posted by: Andrew Gilfrin (IP Logged)
Date: November 17, 2005 08:06AM

Hi Raul,

Seems like I'm on a shamless promotion tour of my latest page update but it seems as if raising an error in the trigger might do the trick.

Depending on how complex the requirements are you can use this method...

Or this one.

Andrew Gilfrin
My MySQL related Blog
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote

Written By
Re: Enforce business rule with before insert trigger?
January 04, 2006 12:50PM

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.