mysql循环查询

begin
declare i int;
set i = 1;
lp1 : LOOP
SELECT insert(t.bb,4,6,'XXXX') FROM t_aa t;
set i = i+1;
if i > 30000 then
leave lp1;
end if;
end LOOP;
end

原文地址:https://www.cnblogs.com/nizuimeiabc1/p/8134673.html