mysql - 创建更新触发器以复制 MySQL 语法错误中更改的数据

Question

CREATE TRIGGER backupFIDE AFTER UPDATE ON player
FOR EACH ROW
BEGIN
IF (OLD.FIDERating <> NEW.FIDERating) THEN
INSERT INTO playerbackup(PlayerName, OldFIDERating, NewFIDERating)
VALUES(OLD.PlayerName, OLD.FIDERating, NEW.NewFIDERating)
END;

大家好，由于某种原因在第 6 行收到语法错误，一直在网上寻找可能原因的解决方案。基本上看一个简单的触发器，它将在更改之前将 Player 表中 FIDERating 的更改复制到包含 OldFIDERating 的备份表，并进行 NewFIDERating 以及日期更改。

Answer 1

DELIMITER //
CREATE TRIGGER backupFIDE AFTER UPDATE ON player
FOR EACH ROW
BEGIN
IF NEW.FIDERating <> OLD.FIDERating
THEN
INSERT INTO playerbackup(PlayerName, OldFIDERating, NewFIDERating)
VALUES(OLD.PlayerName, OLD.FIDERating, NEW.NewFIDERating);
END IF;
END;
//
DELIMITER ;