Mysql 获取每小时及每天的数据量

统计每小时

SELECT HOUR(trigger_time) as Hour,count(*) as Count 
    FROM xxl_job_qrtz_trigger_log 
   WHERE
	trigger_time BETWEEN '2018-02-05 01:18:36'
AND '2018-02-05 17:18:36'
    GROUP BY HOUR(trigger_time) ORDER BY Hour(trigger_time);

统计每天

SELECT
	DATE_FORMAT(trigger_time, '%Y-%m-%d') triggerDay,
	COUNT(id) triggerCount
FROM
	`job_qrtz_trigger_log`
WHERE
	trigger_time BETWEEN '2018-02-02 09:18:36'
AND '2018-03-05 23:18:36'
GROUP BY triggerDay
ORDER BY trigger_time;