作者：雨天是最美 | 来源：互联网 | 2014-06-09 00:50
MySQL快速插入大批量数据存储过程[html]www.2cto.com--------------------------------Tablestructurefor`test`------------------------------DROPTABLEIFEXISTS`test`;CREATE...
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
京公网安备 11010802041100号