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