MySQL Trigger to prevent INSERT under certain conditions

Posted by Richard Mar. on Stack Overflow See other posts from Stack Overflow or by Richard Mar.
Published on 2010-06-05T20:18:27Z Indexed on 2010/06/05 20:22 UTC
Read the original article Hit count: 97

CREATE TRIGGER foo
BEFORE INSERT ON table
FOR EACH ROW
BEGIN
  IF NEW.birthdate > CURRENT_DATE()
  THEN
    ???mystery???
  END IF;
END;

© Stack Overflow or respective owner