mysql 根据时间统计访问次数

查询指定时间范围内：每时每分中请求的次数

?

1 2 3 4 5 6 7 8 9 10 11 12

SELECT     DATE_FORMAT( CREATE_DATETIME, '%H:%i' ) tim,     count(*) coun FROM     TABLE_NAME WHERE     CREATE_DATETIME >= '2022-04-25 00:00:00'     AND CREATE_DATETIME <= '2022-04-25 12:59:59' GROUP BY     DATE_FORMAT( CREATE_DATETIME, '%H:%i' ) ORDER BY     tim DESC

 

查询指定时间范围内：每时每分钟请求的次数小于2的时间

?

1 2 3 4 5 6 7 8 9 10 11 12

select a.tim from (SELECT     DATE_FORMAT( CREATE_DATETIME, '%H:%i' ) tim,     count(*) coun FROM     TABLE_NAME WHERE     CREATE_DATETIME >= '2022-04-25 00:00:00'     AND CREATE_DATETIME <= '2022-04-25 12:59:59' GROUP BY     DATE_FORMAT( CREATE_DATETIME, '%H:%i' ) ORDER BY     tim DESC) a where a.coun < 2

　　

相关博文 https://www.cnblogs.com/hpzyang/p/14470614.html