MySql：利用循环生成10个分布在10到99之间的整数

可用于创建测试数据集的随机数据生成方法

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//