mysql循环处理脚本

drop procedure if exists lr_time;

delimiter $$

create procedure lr_time()
begin
declare n int default 1;
declare MAX int default 5;
declare begin_date date default “2020-05-04”;
declare end_date date default “2020-05-10”;
while begin_date < “2020-09-01” do
insert into tb_drpcenter_shop_weekly_kol_report
values (null, begin_date, end_date, null, null, null, null, null, now(), null, null);
set n = n + 1,begin_date = DATE_ADD(begin_date,INTERVAL 7 DAY),end_date = DATE_ADD(end_date,INTERVAL 7 DAY);
– 可以不加 select sleep(1);
end while;
end
$$

delimiter ;

call lr_time();