CREATE DEFINER=`root`@`localhost` PROCEDURE `APro`()
begin
declare num int;
set num=1;
la:loop
if(num<=1000000) then
begin
insert into tableB (id,name) values (num,'xiaoyi');
set num=num+1;
end;
else
leave la;
end if;
end loop;
end
begin
declare num int;
set num=1;
la:loop
if(num<=1000000) then
begin
insert into tableB (id,name) values (num,'xiaoyi');
set num=num+1;
end;
else
leave la;
end if;
end loop;
end