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

posted @ 2017-12-28 11:15  ppjj  阅读(13239)  评论(0编辑  收藏  举报