mysql 根据一个具体日期连续的生成该日期的前多少天或后多少天

传入具体的时间后七天：

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

传入具体的时间的前七天：

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

说明：

连续多少天根据select 1  union all拼接的个数有关