MYSQL统计每天、每周、每月、每年数据

查询当天

 SELECT COUNT(1) AS total, DATE_FORMAT(time,'%Y-%m-%d') AS days FROM task_execution GROUP BY DATE_FORMAT(time,'%Y-%m-%d') desc;

查询每周的数据

SELECT COUNT(1) AS total, WEEK(created_time) AS weeks FROM task_execution GROUP BY WEEK(created_time) desc;

查询每月的数据

SELECT COUNT(1) AS total, MONTH(created_time) AS months FROM task_execution GROUP BY MONTH(created_time) desc;

查询每年的数据

SELECT COUNT(1) AS total, YEAR(created_time) AS years FROM task_execution GROUP BY YEAR(created_time) desc;