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

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

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