本文共 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/