MySQL按周，天，月分组查询

--按周 select DATE_FORMAT(f.upload_time,'%Y%u') weeks, count(*),sum(p.download_times), sum(p.collection_times), sum(p.click_times) from file_base f left join file_property p on f.property_id = p.id group by weeks; --按天 select DATE_FORMAT(f.upload_time,'%Y-%m-%d') days, count(*),sum(p.download_times), sum(p.collection_times), sum(p.click_times) from file_base f left join file_property p on f.property_id = p.id group by days; --按月 select DATE_FORMAT(f.upload_time,'%Y%m') months, count(*),sum(p.download_times), sum(p.collection_times), sum(p.click_times) from file_base f left join file_property p on f.property_id = p.id group by months;