CREATE TRIGGER t_phome_ecms_zhang_au after insert ON phome_ecms_zhang
FOR EACH ROW
BEGIN
update phome_enewsmember
set money = money + new.sz,
userfen = userfen + new.fanli
where userid= new.userid
END;我写了一个触发器,显示运行的时候显示:
ERROR 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 'update phome_enewsmember
set money = money + new.sz,
userfen' at line 4请教一下,这是错误在哪里?谢谢~
FOR EACH ROW
BEGIN
update phome_enewsmember
set money = money + new.sz,
userfen = userfen + new.fanli
where userid= new.userid
END;我写了一个触发器,显示运行的时候显示:
ERROR 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 'update phome_enewsmember
set money = money + new.sz,
userfen' at line 4请教一下,这是错误在哪里?谢谢~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货