Mysql 查询

<!-- 按日查询-->
SELECT  DATE_FORMAT(created_at,‘%Y-%m-%d‘) as day, SUM(COUNT) FROM collect GROUP BY day;

<!-- 按周查询-->
SELECT  DATE_FORMAT(created_at,‘%Y-%u‘) as day, SUM(COUNT) FROM collect GROUP BY day;

<!-- 按月查询-->
SELECT  DATE_FORMAT(created_at,‘%Y-%m‘) as day, SUM(COUNT) FROM collect GROUP BY day;

<!-- 按年查询-->
SELECT  DATE_FORMAT(created_at,‘%Y‘) as day, SUM(COUNT) FROM collect GROUP BY day;