这是我创建的一个触发器,我想将new.utype与给定的employee进行比较,但不知道在MySQL中实际比较的方法..我该怎么做?并且请告诉我条件语法是否正确
delimiter $$
CREATE TRIGGER insdetail_tomaster
AFTER INSERT ON tempdetail
FOR EACH ROW BEGIN
IF(new.utype =='employee') THEN
INSERT INTO master_employee values(new.field1,new.filed2);
ELSE
INSERT INTO master_manager values(new.field1,new.fiel2);
END $$
DELIMITER ;