请问为什么总报1064错误

请问为什么总报1064错误
CREATE TRIGGER sc_x
AFTER UPDATE ON sc
REFERENCING
OLDROW AS OldTuple,NEWROW AS NewTuple
FOR EACH ROW
WHEN ( NewTuple.Grade > 60 AND OldTuple.Grade<60）INSERT INTO x＿sc(Sno, Cno, OldGrade, NewGrade )
VALUES
(0ldTuple.Sno, OldTuple.Cno, 0ldTuple.Grade, NewTuple.Grade)；

把你要执行的代码和报错代码复制发我

这个错误是因为MySQL不支持REFERENCING关键字。它只在DB2中可用。调整代码如下：

CREATE TRIGGER sc_x
AFTER UPDATE ON sc
FOR EACH ROW
WHEN (NewTuple.Grade > 60 AND OldTuple.Grade < 60)
INSERT INTO x_sc(Sno, Cno, OldGrade, NewGrade)
VALUES (OldTuple.Sno, OldTuple.Cno, OldTuple.Grade, NewTuple.Grade);