查询某天某个人消费总和
select DATE_FORMAT( FROM_UNIXTIME( date, '%Y%m%d%H%i%S' ), '%Y-%m-%d %H:%i:%S') as date from test where id = 1
####查询每个人某个时间范围消费总和
select uid, sum(price)
from test
where DATE_FORMAT( FROM_UNIXTIME...
原创
2019-09-16 13:14:15 ·
163 阅读 ·
0 评论