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
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