mysql - 无法创建触发器 - 语法错误

Question

我想制作在每次插入交易表后更新total_money的触发器。由于错误，我无法创建它:#

1064 - Something is wrong in your syntax near '' in line 3

这是我的触发器创建代码:

CREATE TRIGGER transactions_insert AFTER INSERT ON transactions 
    FOR EACH ROW BEGIN
      UPDATE users SET users.total_money = users.total_money + NEW.Price WHERE users.User_ID = NEW.User_id;
    END;

Answer 1

如果您添加分隔符，它将起作用，如下所示

分隔符//
创建触发器 transactions_insert AFTER INSERT ON transactions 对于每一行开始 UPDATE users SET users.total_money = users.total_money + NEW.Price WHERE users.User_ID = NEW.User_id; 结束；
//