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

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