create table test_load(a int,b char(80)) engine=innodb;
delimiter //
create procedure p_load(count int unsigned)
begin
declare s int unsigned default 1;
declare c char(80) default repeat('a',80);
while s <= count do
insert into test_load select null,c;
set s = s+1;
end while;
commit;
end;
//
delimiter ;