mysql 触发器查询语法错误

发布于 2024-12-10 12:47:57 字数 297 浏览 1 评论 0原文

所以我有以下查询：

CREATE TRIGGER `before_delete`
    BEFORE DELETE ON `abc` FOR EACH ROW
    BEGIN
        DELETE FROM def WHERE OLD.id = objID1 OR OLD.id = objID2;
        DELETE FROM ghi WHERE OLD.id = objID;
    END;

但是mysql抱怨第1行'END'附近有语法错误....

我做错了什么？

原文

so I have the following query:

CREATE TRIGGER `before_delete`
    BEFORE DELETE ON `abc` FOR EACH ROW
    BEGIN
        DELETE FROM def WHERE OLD.id = objID1 OR OLD.id = objID2;
        DELETE FROM ghi WHERE OLD.id = objID;
    END;

but then mysql complains that there's syntax error near 'END' at line 1....

what did I do wrong?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟花肆意 2024-12-17 12:47:57

您需要使用 DELIMTIER 技巧在过程块中包含多个语句。否则它无法区分过程的结束和其中语句的结束。在文档页面上，有一个使用分隔符关键字。

为了省去您转到该页面并四处查看的麻烦，我认为这可以解决它：

DELIMITER $
CREATE TRIGGER `before_delete`
BEFORE DELETE ON `abc` FOR EACH ROW
BEGIN
    DELETE FROM def WHERE OLD.id = objID1 OR OLD.id = objID2;
    DELETE FROM ghi WHERE OLD.id = objID;
END $
DELIMITER ;

You need to make use of the DELIMTIER trick to include multiple statements in a procedure block. Otherwise it can't tell the difference between the end of your procedure and the end of statements inside it. On the documentation page, there is an example using the delimiter keyword.

To save you the trouble of going to that page and looking around, I think this will fix it:

DELIMITER $
CREATE TRIGGER `before_delete`
BEFORE DELETE ON `abc` FOR EACH ROW
BEGIN
    DELETE FROM def WHERE OLD.id = objID1 OR OLD.id = objID2;
    DELETE FROM ghi WHERE OLD.id = objID;
END $
DELIMITER ;

回复收藏 0 原文

~没有更多了~