Question

因此,我有以下疑问:

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....

我有什么错?

Answer 1

您需要利用<条码>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 ;

友情链接