mysql日期按小时递增

SELECT event_time, event_name
FROM events
WHERE event_time >= '2023-04-01 00:00:00'
ORDER BY event_time ASC;

SELECT DATE_FORMAT(event_time, '%Y-%m-%d %H:00:00') AS hour, COUNT(*) AS event_count
FROM events
WHERE event_time >= '2023-04-01 00:00:00'
GROUP BY hour
ORDER BY hour ASC;

SELECT DATE_FORMAT(event_time, '%Y-%m-%d %H:00:00') AS hour, COUNT(*) AS event_count
FROM events
WHERE event_time >= '2023-04-01 00:00:00'
GROUP BY hour
ORDER BY hour ASC;

SELECT DATE_ADD('2023-04-01 00:00:00', INTERVAL n HOUR) AS hour
FROM (
    SELECT 0 AS n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3
    UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7
    UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL SELECT 11
    UNION ALL SELECT 12 UNION ALL SELECT 13 UNION ALL SELECT 14 UNION ALL SELECT 15
    UNION ALL SELECT 16 UNION ALL SELECT 17 UNION ALL SELECT 18 UNION ALL SELECT 19
    UNION ALL SELECT 20 UNION ALL SELECT 21 UNION ALL SELECT 22 UNION ALL SELECT 23
) AS numbers
WHERE DATE_ADD('2023-04-01 00:00:00', INTERVAL n HOUR) <= '2023-04-02 00:00:00';