mysql触发器中怎么从把一个表中的字段值赋给一个变量delimiter //
CREATE TRIGGER jian_reportnum_num after delete ON report
FOR EACH ROW
BEGIN
set @new_prjid= OLD.prjid; set @new_num=num from reportnum where prjid=@new_prjid; 这段是错的 我不知道怎么写呢
if (@new_num = 0) then
update reportnum set num=0 where prjid=@new_prjid;
else
update reportnum set num=num-1 where prjid=@new_prjid;
end if;
END;
CREATE TRIGGER jian_reportnum_num after delete ON report
FOR EACH ROW
BEGIN
set @new_prjid= OLD.prjid; set @new_num=num from reportnum where prjid=@new_prjid; 这段是错的 我不知道怎么写呢
if (@new_num = 0) then
update reportnum set num=0 where prjid=@new_prjid;
else
update reportnum set num=num-1 where prjid=@new_prjid;
end if;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货