Question

mysql根据某列求和的语句怎么写

如要在充值记录表recharge按照用户id来算出时间time（datetime类型）在某三天的充值金额money是多少。
就是算出某三天里某个用户充值的总和，将用户名，金额存到另一张表里

Answer 1

select sum(money) as money, id
from recharge
where time between xxx and xxx
group by id