mysql - 如何用一个触发器执行多个操作

Question

我想将它们合并为一个触发器。我创建第一个查询，然后创建第二个查询。但它说有多个触发器具有相同的 Action 。我的问题是如何将它们结合起来。

 CREATE trigger deletePostsAfterDeleteUser before delete on  
tblusers for each row delete from tblposts where tblposts.userId = old.userId


CREATE trigger deleteReportsAfterDeleteUser before delete on 
tblusers for each row delete from tblreports where tblreports.userId = old.userId

Answer 1

使用开始和结束:

create trigger deletePostsAfterDeleteUser before delete on  
tblusers
for each row
begin
    delete from tblposts where tblposts.userId = old.userId;
    delete from tblreports where tblreports.userId = old.userId;
end;

但是，这种类型的操作表明您确实想要 cascading constraints ，而不是触发器。