mysql批量存储_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 < @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;

endbitsCN.com

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网

TAG标签：test存储