MySQL快速插入大批量数据存储过程
1:创建表,表名为test
prompt 201610311448_TEST_CREATE.SQL Start!
CREATE TABLE IF NOT EXISTS TEST(
ID BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
NAME VARCHAR(50) DEFAULT NULL COMMENT '姓名',
CARDNO VARCHAR(50) DEFAULT NULL COMMENT '证件号码',
REMARK VARCHAR(20) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (ID)
) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='实例表(test)';
2:编辑存储过程
begin
set @startFrom=1;
set @endTo=100000000;
set @v_temp=详细点;
set @v_remark="这是备注";
start transaction;
while @startFrom<@endTo
set @final=concat(@v_remark,@v_temp);
INSERT INTO test(REMARK ) VALUES (@final);
set @startFrom=@startFrom+1;
end while;
commit;
end;