本文共 304 字，大约阅读时间需要 1 分钟。

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 ;

转载地址：http://wtduk.baihongyu.com/