SELECT DATE_FORMAT(start_stamp,"%Y-%m-%d")as day,sum(fee) as total_fee
FROM bill
GROUP BY DATE_FORMAT(start_stamp,"%Y-%m-%d")
Mysql按天分组（按日分组）
未经允许不得转载：搜云库技术团队 » Mysql按天分组（按日分组）
SELECT DATE_FORMAT(start_stamp,"%Y-%m-%d")as day,sum(fee) as total_fee
FROM bill
GROUP BY DATE_FORMAT(start_stamp,"%Y-%m-%d")
