MySql触发器错误

Question

我在MySql dealers和dealers_info中有2个表。我试图创建触发器，它从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 ;