我在建立触发器,输入sql语句想要进行运行,系统报错,说语句有问题,希望帮我改正一下
CREATE TRIGGER js_TG学分统计01 ON jins_学习01
FOR INSERT
AS
UPDATE jins_学生01
SET js_已修学分总数01=
(SELECT SUM(js_学分01)
FROM jins_课程01
WHERE js_课程编号01 IN
(SELECT js_课程编号01
FROM jins_学习01
WHERE jins_学习01.js_成绩01>=60 AND jins_学习01.js_学号01 IN (SELECT js_学号01 FROM inserted)))
WHERE jins_学生01.js_学号01 IN (SELECT js_学号01 FROM inserted)
系统发出以下报错:
ERROR: syntax error at or near "ON"
LINE 1: CREATE TRIGGER js_TG学分统计01 ON jins_学习01
^
mysql创建触发器语法格式如下:
CREATE <触发器名> < BEFORE | AFTER >
<INSERT | UPDATE | DELETE >
ON <表名> FOR EACH Row<触发器主体>
你的写法是MS SqlServer,确认你的数据库是什么