mysql-proc

delimiter // 
drop procedure autoinsert if exist autoinsert //
create procedure autoinsert()   
begin
    declare i int default 1;   
    while (i <= 100000) do   
        insert into test.t_count (a) values(i);   
        set i = i+1;   
    end while;   
end
//
delimiter ;

 

 

CREATE ` PROCEDURE `insert_isam`(p int,t char(10))
begin
set @i = 0;
set @str = “iamauperman!iwillbeahero!!”;
repeat
#select name into @str from mysql.help_topic order by rand() limit 1;
set @str=substr(@str,1,25);
set @ins_str = repeat(@str,floor(rand()*10));
set @cmd=concat(‘insert into ‘,t,’ (content) values(“‘,@ins_str,’”)’);
prepare stmt from @cmd;
execute stmt;
set @i = @i+1;
until @i > p end repeat;
end