MySQL生成连续时间
day可替换 month year等
SELECT @cdate := date_add(@cdate,interval -1 day) days from
(SELECT @cdate := DATE_ADD( 结束时间, INTERVAL + 1 day) from 表名 ) t1
SELECT @cdate := date_add(@cdate,interval -1 day) days from
(SELECT @cdate := DATE_ADD( '2020-03-02', INTERVAL + 1 day) from sys_user ) t1