时间戳

首页 > 解决方案 > 如何使用一个触发器执行多个操作

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

问题描述

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

 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

标签： mysql

解决方案

使用begin和end：

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;

但是，这种类型的操作表明您确实需要级联约束，而不是触发器。

推荐阅读