```sql
select
date_add('2020-04-27',interval @i:=@i+1 day) as op_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
) as tmp,(select @i:= -1) t
```sql
select
date_add('2020-04-27',interval @i:=@i+1 day) as op_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
) as tmp,(select @i:= -1) t