tab1表在插入数据时看 tab2表是否有数据,如果插入数据status=0时把数据写入到tab2表,否则将tab2 code相等的数据删除,有时tab1表写入数据时触发器没有执行??触发器写的有问题么??触发器代码如下:
DELIMITER $$
USE `test`$$
DROP TRIGGER /*!50032 IF EXISTS */ `t_afterinsert_no_test`$$
CREATE
/*!50017 DEFINER = 'root'@'%' */
TRIGGER `t_afterinsert_no_test` AFTER INSERT ON `tab1`
FOR EACH ROW BEGIN
IF new.status='0' THEN
INSERT INTO test.tab2 (code,title,date,userid,new.status)
SELECT new.code,new.title,new.d,new.userid,new.status FROM DUAL
WHERE NOT EXISTS (SELECT * FROM test.tab2 WHERE code=new.code);
ELSE
DELETE FROM test.tab2 WHERE code=new.code;
END IF;
END;
$$
DELIMITER ;