mysql计算
select @csum := 0;
select create_time,merchant_id,award as 奖励,total_count as 数量,(@csum := @csum + award*total_count) as 累计 FROM aty_award_task where merchant_id =55 and status = 1;
select @csum := 0;
select award_task_id, create_time,merchant_id,award as 奖励,total_count as 数量,task_money 任务金,(@csum := @csum + task_money*total_count) as 累计 FROM aty_award_task where merchant_id =55;
select @csum := 0;
select create_time,merchant_id,award as 奖励,(@csum := @csum + award/0.7) as 累计支付 FROM aty_award_task_receive where merchant_id =55 and status =2 and pay_status = 1;
select @csum := 0;
select create_time,merchant_id,award as 奖励,(@csum := @csum + award) as 累计支付 FROM aty_award_task_receive where merchant_id =55 and status =2 and pay_status = 1
select sum(money) as todayMoney from odr_order_base where pay_status = 1 and status in(1,2,3)
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步