ghy19980814
2019-06-02 21:37触发器SQL语句报错求解决
5CREATE TRIGGER Insert_TV_PRICE
BEFORE INSERT ON SALE FOR EACH ROW
BEGIN
IF (new.GNAME = '电视机') AND (new.PRICE < 2000) THEN
new.PRICE : = 2000;
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 '.PRICE : = 2000;
END IF;
END' at line 5
求解哪里出现了问题
- 点赞
- 回答
- 收藏
- 复制链接分享
3条回答
为你推荐
- mysql以触发器方式设置主键为uuid,一直报错
- sql
- mysql
- 1个回答
- 触发器SQL语句报错求解决
- sql
- 3个回答
- 如何用Hibernate查询备份表(表名与实体定义的表名不相同了)
- 数据库
- hibernate
- 0个回答
- Oracle新手: 触发器的问题
- dao
- 0个回答
- pl/sql sql Oracle DRA-01008并非所有变量都已绑定
- sql
- oracle
- 4个回答
换一换