mysql生成一段时间的日期并插入表格，作为维护日期表

set @i = -1;  
  
set @sql = repeat(" select 1 union all",-datediff('2017-09-01','2020-09-01')+1);  
  
set @sql = left(@sql,length(@sql)-length(" union all"));  
  
set @sql = concat(" INSERT into  fj_bszs_date(rq) (select date_add('2017-09-01',interval @i:=@i+1 day) as date from (",@sql,") as tmp)");  
  
prepare stmt from @sql;  
  
execute stmt