SET @i=0;
SELECT DATE_FORMAT(t.time,'%m-%d %H') as dateValue FROM
(SELECT DATE_SUB('2023-08-20 00:00:00',INTERVAL ( (@i:=@i+1) ) HOUR ) AS 'time'
FROM mysql.help_category where @i<24)
AS t
当设置了查询24小时 数据查出来0-23 数据是正常的
但是当设置了大于43 之后 不管设置多少返回只有43条数据 这个是为啥,求解
SET @i=0;
SELECT DATE_FORMAT(t.time,'%m-%d %H') as dateValue FROM
(SELECT DATE_SUB('2023-08-20 00:00:00',INTERVAL ( (@i:=@i+1) ) HOUR ) AS 'time'
FROM mysql.help_category where @i<48)
AS t