批量注入MySQL测试脚本：高效创建50,000条数据

CREATE TABLE `test` (                                       
          `id` int(11) NOT NULL AUTO_INCREMENT,                     
          `ordernum` varchar(255) NOT NULL,                         
          PRIMARY KEY (`id`)                                        
        ) ENGINE=InnoDB AUTO_INCREMENT=500001 DEFAULT CHARSET=utf8  


DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`inject_huge_data`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `inject_huge_data`()
BEGIN  
set @beginnum=1;  
set @endnum=500001;  
  
start transaction;  
while @beginnum < @endnum do  
  
set @v_beginnum=LPAD(@beginnum,7,0);  
set @order=concat(20121105,@v_beginnum);  
  
INSERT INTO test ( ordernum )  
VALUES  
(  
@order  
);  
  
set @beginnum=@beginnum+1;  
end while;