MySQL触发器可以模拟CHECK约束吗？[重复]

尝试以下语法

CREATE TRIGGER mytabletriggerexampleBEFORE INSERTFOR EACH ROW BEGINIF(NEW.important_value) < (fancy * dancy * calculation) THEN    DECLARE dummy INT;    SELECt Your meaningful error message goes here INTO dummy         FROM mytable      WHERe mytable.id=new.idEND IF; END;