MySQL 常用的按日 周 月 统计
按日统计
1 |
SELECT date(add_time,'%x %v') as reportDate, sum(price) as total FROM log_login group by reportDate |
按周统计
1 |
SELECT DATE_FORMAT(add_time,'%x %v') as reportDate, sum(price) as total FROM log_login group by reportDate |
按月统计
1 |
SELECT DATE_FORMAT(add_time,'%Y%m') as reportDate, sum(price) as total FROM log_login group by reportDate |
近期评论