mysql 查询每天时间段

SELECT DATE(timestamp) AS log_date, COUNT(*) AS log_count
FROM logs
WHERE DATE(timestamp) = '2023-10-01'
GROUP BY log_date;

SELECT DATE(timestamp) AS log_date, COUNT(*) AS log_count
FROM logs
WHERE timestamp BETWEEN '2023-10-01 00:00:00' AND '2023-10-31 23:59:59'
GROUP BY log_date;

SELECT DATE(timestamp) AS log_date, HOUR(timestamp) AS log_hour, COUNT(*) AS log_count
FROM logs
WHERE DATE(timestamp) = '2023-10-01'
GROUP BY log_date, log_hour;

SET time_zone = '+8:00';

CREATE TABLE logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    timestamp DATETIME NOT NULL,
    log_data TEXT
) PARTITION BY RANGE (TO_DAYS(timestamp)) (
    PARTITION p0 VALUES LESS THAN (TO_DAYS('2023-01-01')),
    PARTITION p1 VALUES LESS THAN (TO_DAYS('2024-01-01')),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);