mysql 触发器问题
- SQL code
create trigger amountlog_update_recalculated before update on dm_amountlog for each row BEGIN SET @cur=curdate(); set NEW.actualyear=year(@cur); set NEW.actualmonth=month(@cur); set NEW.actualday=day(@cur); SET @suma=dm_amount.paid+NEW.actualpayment; update dm_amount set dm_amount.paid=@suma where dm_amount.docid=NEW.docid; END;
这个触发器更新的时候为什么提示找不到表“dm_amount”，但这张表确实是存在的，而且也没有错误
还有下面一个触发器，为什么总提示出错，上面的触发器是是因为下面这个触发器问题解决不了所以拆出来的
- SQL code
create trigger amountlog_update_recalculated before update on dm_amountlog for each row BEGIN SET @cur=curdate(); set NEW.actualyear=year(@cur); set NEW.actualmonth=month(@cur); set NEW.actualday=day(@cur); SET @suma=select sum(dm_amountlog.actualpayment) from dm_amountlog where dm_amountlog.docid=NEW.docid; update dm_amount set dm_amount.paid=@suma where dm_amount.docid=NEW.docid; IF dm_amount.paid=dm_amount.payment where dm_amount.docid=NEW.docid THEN update dm_amount SET dm_amount.isdone=1 where dm_amount.docid=NEW.docid; END IF; END; $$
望大侠指教
——解决方案——————–
——解决方案——————–
DELIMITER $$
CREATE TRIGGER amountlog_update_recalculated BEFORE UPDATE ON dm_amountlog
FOR EACH ROW
BEGIN
SET @cur=CURDATE();
SET NEW.actualyear=YEAR(@cur);
SET NEW.actualmonth=MONTH(@cur);
SET NEW.actualday=DAY(@cur);
SET @suma=(SELECT SUM(dm_amountlog.actualpayment) FROM dm_amountlog WHERE dm_amountlog.docid=NEW.docid);
UPDATE dm_amount SET dm_amount.paid=@suma WHERE dm_amount.docid=NEW.docid;
IF dm_amount.paid=dm_amount.payment AND dm_amount.docid=NEW.docid THEN
UPDATE dm_amount SET dm_amount.isdone=1 WHERE dm_amount.docid=NEW.docid;
END IF;
END;$$
DELIMITER ;
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MYSQL 触发器有关问题
转载请注明原文链接：MYSQL 触发器有关问题
