create trigger 名 on t1
for update
as
update t2 set c1 = (select sum(charge1) from t1) * 10% where charge = 'charge1'
update t2 set c2 = (select sum(charge1) from t1) * 20% where charge = 'charge2'
update t2 set c3 = (select sum(charge1) from t1) * 30% where charge = 'charge3'
for update
as
update t2 set c1 = (select sum(charge1) from t1) * 10% where charge = 'charge1'
update t2 set c2 = (select sum(charge1) from t1) * 20% where charge = 'charge2'
update t2 set c3 = (select sum(charge1) from t1) * 30% where charge = 'charge3'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货