MySql触发器错误

Question

我有两张MySql dealers和dealers_info表格。我尝试创建触发器，在从dealers中删除信息后，它将从dealers info中删除相应的行

CREATE TRIGGER del_info AFTER DELETE ON  dealers
FOR EACH ROW 
BEGIN
DELETE FROM dealers_info WHERE dealer_id = OLD.dealer_id;
END;

但我有一个错误：

#1064 - You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near '' at line 4 

Answer 1

更改分隔符以正确执行查询，

DELIMITER $$
CREATE TRIGGER del_info 
AFTER DELETE ON  dealers
FOR EACH ROW 
BEGIN
    DELETE FROM dealers_info WHERE dealer_id = OLD.dealer_id;
END $$
DELIMITER ;