MySQL快速插入大批量数据存储过程_MySQL

bitsCN.com

MySQL快速插入大批量数据存储过程

 

[html]    

-- ----------------------------  

-- Table structure for `test`  

-- ----------------------------  

DROP TABLE IF EXISTS `test`;  

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;  

  

begin  

set @beginnum=1;  

set @endnum=500001;  

  

start transaction;  

while @beginnum

  

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;  

 commit;  

 end  
 

bitsCN.com