MYSQL查询近30天日期

SELECT date_sub(CURDATE(),interval @i:=@i+1 day) as datefrom (select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all selec

飞奔的yah

2705人浏览 · 2021-12-01 13:50:16

飞奔的yah · 2021-12-01 13:50:16 发布

SELECT date_sub(CURDATE(),interval @i:=@i+1 day) as date
from (select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all   select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all  select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all select 1 union all  select 1 union all select 1) as a,
(select @i:= -1) b