CREATE PROCEDURE p_test(pa int(11))

BEGIN

declare max_num int(11) default 100000;

declare i int default 0;

declare rand_num int;

select count(id) into max_num from test_test; #查询id总数，查询结果存入变量max_num

while i<pa DO

if max_num < 100000 THEN

select cast(rand()*100 as unsigned) into rand_num;

insert into test_test(num)values(rand_num);

end if;

set i = i+1;

end while;

end

调用：

call p_test(100000);

转载请注明：谷谷点程序 » mysql存储过程（1）随机增加10万数据