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

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 < @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;

commit;

end