MySQL Forums
Forum List  »  Newbie

Re: How can I generate errors from a TRIGGER?
Posted by: Bill Karwin
Date: September 14, 2006 10:38AM

The only solution I have found is to set a not-null column to NULL in a BEFORE trigger. This causes a violation of the not-null constraint and aborts the operation that spawned the trigger.

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
Re: How can I generate errors from a TRIGGER?
September 14, 2006 10:38AM


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.