MySQL快速插入大批量数据存储过程
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
评论暂时关闭