mysql 查询近24小时的各个时间段的时间

SELECT   DATE_FORMAT( DATE_SUB( NOW(),INTERVAL ( -(@i:=@i-1) ) HOUR ) ,'%Y-%m-%d %H') AS 'time'
         FROM (
              SELECT a  FROM
               (SELECT '1' AS a UNION SELECT '2' UNION SELECT '3' UNION SELECT '4'   ) AS a
                JOIN ( SELECT  '1' UNION SELECT '2' UNION SELECT '3' UNION SELECT '4' UNION SELECT '5' UNION SELECT '6' ) AS b
                 ON 1
               ) AS b  ,(SELECT @i:=+1)  AS i;

查询当天24小时的时间

https://blog.csdn.net/zuochunping/article/details/102499637

 

有其他方法请指点。