mysql 触发器错误

Question

我想创建一个触发器，如果​​满足我的条件(最新版本= 1)，将在即将插入新行时执行该触发器，所有先前的行将更新为最新版本= 0

CREATE TRIGGER remiseazero
BEFORE INSERT 
ON wp_stattype2_3_activite
FOR EACH ROW
BEGIN
IF NEW.latestversion = 1
THEN
update wp_stattype2_3_activite
set latestversion = 0 where typecas = new.typecas;
END IF;
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 9

Answer 1

放置分隔符。并删除 END 之后的 ;。

DELIMITER $$
CREATE TRIGGER remiseazero
BEFORE INSERT 
ON wp_stattype2_3_activite
FOR EACH ROW
BEGIN
IF (NEW.latestversion = 1) THEN
    update wp_stattype2_3_activite set latestversion = 0 where typecas = NEW.typecas;
END IF;
END$$
DELIMITER ;