MySQL 更新后触发增加计数

Question

你知道这个查询有什么问题吗？我在 stackoverflow 上搜索了一下，似乎每个人都在使用这个并且它有效。

mysql> CREATE TRIGGER upd_entry 
    -> AFTER UPDATE ON entry FOR EACH ROW
    -> BEGIN
    ->     UPDATE entry 
    ->     SET count = count +1 
    ->     WHERE id = NEW.id
    -> END;
ERROR 1064 (42000): 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 'END' at line 7

Answer 1

首先运行此命令以更改分隔符

DELIMITER //

创建触发器

CREATE TRIGGER upd_entry 
AFTER UPDATE ON entry FOR EACH ROW
BEGIN
   UPDATE entry 
   SET count = count +1 
   WHERE id = NEW.id;
END//

改回来后

DELIMITER ;