mysql 根据时间统计访问次数

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

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的时间

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