mysql update sql

最新推荐文章于 2025-08-19 20:52:10 发布

原创最新推荐文章于 2025-08-19 20:52:10 发布 · 118 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

mysql 专栏收录该内容

22 篇文章

订阅专栏


select userno,sum(small_posttaxprize) t1  from lottery_order  where order_result_status in  (3,4) group by userno ;

select userno, sum(commisionPrizeAmt+prizeAmt) t2 from lottery_caselot_buy group by userno;



select userno,sum(small_posttaxprize) total  from lottery_order  where order_result_status in  (3,4) group by userno;

update user_account a  inner join (select userno,sum(small_posttaxprize) total  from lottery_order  where order_result_status in  (3,4) group by userno) c set total_prize_amt=c.total wherhere a.userno=c.userno;
update user_account a inner join(select * from(select userno, sum(commisionPrizeAmt+prizeAmt) total   from lottery_caselot_buy group by userno having total>0) t)tt  set total_prize_amt=total_prize_amt+tt.total where a.userno=tt.userno;