mysql cte

【1】递归构造连续日期

with recursive  t1 as ( select 1 as id  union all select id+1 from t1 where id<100 ) 
SELECT date_format(date_add('20210101',interval t1.id day),'%Y%m%d') from t1;