mysql触发器语法错误_mysql触发器语法错误问题

159 阅读 0 评论 105 点赞

我是靠谱客的博主爱笑马里奥，这篇文章主要介绍mysql触发器语法错误_mysql触发器语法错误问题，现在分享给大家，希望可以做个参考。

CREATE TRIGGER tradecost

AFTER UPDATE ON fentrust

FOR EACH ROW

BEGIN

DECLARE old_account DECIMAL(16,6)

DECLARE old_fid INT(10)

DECLARE trade_account DECIMAL(16,6)

SET old_fid = SELECT old_fid FROM fentrust WHERE old.fEntrustType = 1 AND old.fstatus = 1 AND new.fstatus IN(2,3)

SET trade_account = (SELECT fsuccessamount FROM fentrust WHERE old.fEntrustType = 1 AND old.fstatus = 1 AND new.fstatus IN(2,3))

SET old_account = (SELECT ftotalrmb FROM fwallet WHERE fid = old_fid)

UPDATE fwallet SET ftotalRMB = (old_account-trade_account*0.005)

END

上面的语法有问题总报错求助应该怎么写谢谢

本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。