56,678
社区成员
发帖
与我相关
我的任务
分享
DELIMITER $$
DROP TRIGGER /*!50114 IF EXISTS */ `test`.`tr_delete`$$
CREATE TRIGGER `test`.`tr_delete` AFTER DELETE on `test`.`t11_replicas`
FOR EACH ROW BEGIN
delete from t11 where id = old.id;
END$$
DELIMITER ;
select * from t11_replicas where id =2;
query result(1 records)
id str
2 This is a test 2
select * from t11 where id =2;
query result(1 records)
id str
2 23434343
delete from t11_replicas where id =2;
(1 row(s)affected)
(0 ms taken)
select * from t11 where id =2;
Empty set (0.00 sec)