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;beginset @beginnum=1;set @endnum=500001;start transaction;while @beginnum < @endnum doset @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
