CREATE PROCEDURE insert_cf ()
DYNAMIC RESULT SETS 1
P1: BEGIN
-- Declare cursor
declare a int;
set a=1;
loop1:
LOOP
if(a<=100000) then
insert into administrator.cfsource2(NAME) values('f');
set a=a+1;
else
leave loop1;
end if;
end loop loop1;
END P1
DYNAMIC RESULT SETS 1
P1: BEGIN
-- Declare cursor
declare a int;
set a=1;
loop1:
LOOP
if(a<=100000) then
insert into administrator.cfsource2(NAME) values('f');
set a=a+1;
else
leave loop1;
end if;
end loop loop1;
END P1