mysql如何快速生成测试大数据库

快速生成1000W测试数据库；

创建测试表：

create table user (  id int(10) not null auto_increment,   uname  varchar(20) ,  regtime  char(30)  ,  age  int(11)   ,primary key (id)
)  
engine=myisam default charset=utf8 collate=utf8_general_ci  ,
auto_increment=1 ;

编写存储过程：

delimiter $$
SET AUTOCOMMIT = 0$$create  procedure test()
begin
declare v_cnt decimal (10)  default 0 ;
dd:loopinsert  into user values(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50),(null,rand()*10,now(),rand()*50);commit;set v_cnt = v_cnt+10 ;if  v_cnt = 10000000 then leave dd;end if;end loop dd ;
end;$$delimiter ;

调用存储过程：

call test();