Mysql存储过程批量插入数据

批量存储过程插入数据

drop procedure if exists batchInsert; # 如果存在存储过程，先删除

delimiter $

create procedure batchInsert(IN rows INT)
	begin
		declare id int;
		set id=1;
		while id < rows do
			insert into t(id,name, score) values(id,concat('jack',id), ROUND(100*RAND()));
			set id=id+1;
		end while;
	end;
$
delimiter ;

call batchInsert(202);