1、 获取连续日期
#自减
SELECT
@cdate := DATE_ADD(@cdate, INTERVAL - 1 DAY) DAY from (
select @cdate := DATE_ADD('20171219', INTERVAL + 1 DAY) from table_name
) t0 LIMIT 7
1、 获取连续日期
#自减
SELECT
@cdate := DATE_ADD(@cdate, INTERVAL - 1 DAY) DAY from (
select @cdate := DATE_ADD('20171219', INTERVAL + 1 DAY) from table_name
) t0 LIMIT 7