MySQL Forums
Forum List  »  Triggers

Check Values Trigger
Posted by: Tamar Pair
Date: November 11, 2011 11:08AM

I am use to working in Oracle, but need to write a trigger in MySql. I want a trigger to check 3 fields before going to the database.
for example, I will have a list of valid pid's letcode and sites that when together gives it validity: if pid=1 and letcode="DCR" and site=1 then ok else RAISE APPLICATION ERROR (invalid)

something like that.
Thanks in advance

Options: ReplyQuote

Written By
Check Values Trigger
November 11, 2011 11:08AM

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.