根据某天 按每小时统计数量
SELECT LEFT( event_time, 13 ) name , COUNT( * ) count FROM sys_event WHERE DATE_FORMAT(event_time,'%Y-%m-%d')='2020-08-07' GROUP BY LEFT( event_time, 13 )
根据某天 按每小时统计数量
SELECT LEFT( event_time, 13 ) name , COUNT( * ) count FROM sys_event WHERE DATE_FORMAT(event_time,'%Y-%m-%d')='2020-08-07' GROUP BY LEFT( event_time, 13 )