mysql触发器删除相同id

zpf6vheq 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(300)

使用触发器，我想删除表2中与表1中删除的行id相同的行

CREATE TRIGGER trgDeleteInTable2 AFTER DELETE ON table1
FOR EACH ROW
BEGIN
DELETE  FROM table2 a  WHERE a.id =  the same id than the one deleted in table1 
END;

我该怎么做？如何在表1中删除当前id？
谢谢你的帮助

mysql triggers

来源：https://stackoverflow.com/questions/50943826/mysql-trigger-delete-on-same-id

1条答案

按热度按时间

kadbb4591#

试试这个：

CREATE TRIGGER trgDeleteInTable2 AFTER DELETE ON table1
FOR EACH ROW
BEGIN
DELETE * FROM table2 a  WHERE a.id =  OLD.id 
END;
``` `OLD.id` 是 `id` 从 `table1` 已删除。

赞(0）回复(0）举报 2021-06-20

我来回答

mysql触发器删除相同id

1条答案

相关问题

热门标签

最新问答