可用于创建测试数据集的随机数据生成方法
1.while循环
delimiter //
create table random_num (num int);
drop procedure if exists ran1;
create procedure ran1(num int)
begin
declare i int;
set i = 0;
while i<num do
insert into random_num values(rand()*89+10);
set i = i+1;
end while;
select * from random_num;
end//
2.repeat循环:
delimiter //
create table random_num (num int);
drop procedure if exists ran2;
create procedure ran2(num int)
begin
declare i int;
set i = 0;
repeat
insert into random_num values(rand()*89+10);
set i = i+1;
until i>num end repeat;
select * from random_num;
end//
3. loop循环:
delimiter //
create table random_num (num int);
drop procedure if exists ran3;
create procedure ran3(num int)
begin
declare i int;
set i = 0;
L:loop
insert into random_num values(rand()*89+10);
set i = i+1;
if i>10 then
leave L;
end if;
end loop;
select * from random_num;
end//