Skip to content

Instantly share code, notes, and snippets.

@danielestevez

danielestevez/ConstraintTrigger

Created October 15, 2014 09:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danielestevez/20fd96ec01a18f2fe675 to your computer and use it in GitHub Desktop.
Save danielestevez/20fd96ec01a18f2fe675 to your computer and use it in GitHub Desktop.
Download ZIP
Complex SQL Constraints as a Trigger
Raw
ConstraintTrigger
CREATE TRIGGER complex_constraint BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
IF /*complex constraint*/(NEW.field1 IS NOT NULL AND NEW.field2 IS NOT NULL) OR (NEW.field1 IS NULL AND NEW.field2 IS NULL) THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'complex constraint exception message';
END IF;
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment