select date_add('2021-01-01',interval @i:=@i+1 day) as date
from ( select 1 union all select 1 union all select 1 union all select 1) as tmp,
(select @i:= -1) t
mysql生成一个连续的时间序列
最新推荐文章于 2024-05-20 18:36:43 发布
select date_add('2021-01-01',interval @i:=@i+1 day) as date
from ( select 1 union all select 1 union all select 1 union all select 1) as tmp,
(select @i:= -1) t