mysql造数据

1.存储过程
 

DELIMITER $$

 CREATE  PROCEDURE `fact_user_msg_PROC`()
BEGIN
  DECLARE iloop SMALLINT DEFAULT 0;
  DECLARE iNum MEDIUMINT DEFAULT 0;  
  DECLARE tel bigint DEFAULT 13000000000;  
  DECLARE uid int DEFAULT 0; 
  DECLARE unicknme varchar(100) DEFAULT 'test';  
  WHILE iNum<=5000 DO
    START TRANSACTION;
      WHILE iloop<=1000 DO
          set tel=tel+1;
          set uid=uid+1;
	  set tel=tel+uid;
          set unicknme=CONCAT('test',uid);
           INSERT INTO fact_user_msg(i_uid,s_u_unicknme,s_u_class,d_u_regtime,
           i_u_sex,i_u_schoolid,
           i_u_birthday, s_usr_level,
           d_o_lastordertime,f_o_total_spend_3m,i_o_ordesnum_3m,f_o_kdj_3m,
           s_u_usermob,s_u_usermob_type,i_u_verified,i_u_sendNumber,i_u_sendNumber_3m,i_r_sendNumber_7d,
           s_o_usermob,s_o_usermob_type,i_o_verified,i_o_sendNumber,i_o_sendNumber_3m,i_o_sendNumber_7d)  
             VALUES(uid,unicknme,50,DATE_ADD('2005-01-01 00:00:00',  INTERVAL  FLOOR(1 + (RAND() * 8*364*24*3600))   SECOND ),
             rand(),rand(),
             DATE_ADD('1980-01-01 00:00:00',  INTERVAL  FLOOR(1 + (RAND() * 20*365*24*3600))   SECOND ),1,
             DATE_ADD('2012-01-01 00:00:00',  INTERVAL  FLOOR(1 + (RAND() * 1*365*24*3600))   SECOND ),rand()*900+100,rand()*5+1,rand()*400+50,
              tel,rand()*2+1,rand(), rand()*100+100,rand()*20+10,rand()*10,
              tel,rand()*2+1,rand(), rand()*100+100,rand()*20+10,rand()*10);
        
        SET iloop=iloop+1;
      END WHILE;
    
    COMMIT;
    SET iloop=0;
    SET iNum=iNum+1;
  END WHILE;
END $$
DELIMITER ;

2.调用执行，可以修改起始值
  

   call `fact_user_msg_PROC`();
   $$;