存储过程插入批量数据

CREATE TABLE bo_paylog_tmp (
id varchar(30) NOT NULL,
ext1 varchar(255) DEFAULT NULL,
ext2 varchar(255) DEFAULT NULL,
ext3 varchar(255) DEFAULT NULL,
ext4 varchar(255) DEFAULT NULL,
ext5 varchar(255) DEFAULT NULL,
ext6 varchar(255) DEFAULT NULL,
opttime datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
userid bigint(20) DEFAULT NULL,
appid int(11) DEFAULT NULL,
description varchar(4000) DEFAULT NULL,
paychannel varchar(255) DEFAULT NULL,
payid int(11) DEFAULT NULL,
price decimal(10,2) DEFAULT NULL,
times time DEFAULT NULL,
status int(11) DEFAULT NULL,
createtime datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
usertype int(11) DEFAULT NULL,
invoicestate varchar(255) DEFAULT NULL,
business_type int(11) DEFAULT NULL,
usbkey_order_id varchar(34) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE PROCEDURE insertTable(in putcount int)
begin
DECLARE id VARCHAR(34);
DECLARE idlength int;
DECLARE usbkey_order_id VARCHAR(34);
DECLARE newid VARCHAR(34);
DECLARE param int default 0;
set id=‘1234567890abcdpmeghgwk1234567890’;
set newid=’’;
set usbkey_order_id=’’;
while param<putcount do

set idlength = 0;

while idlength <24 do	 

set idlength=idlength+1;
set newid = CONCAT( newid, SUBSTR(id, FLOOR(RAND() * LENGTH(id)), 1) ) ;
set usbkey_order_id = CONCAT( usbkey_order_id, SUBSTR(id, FLOOR(RAND() * LENGTH(id)), 1) ) ;
end while;
INSERT INTO wkecp.bo_paylog_tmp (id, ext1, ext2, ext3, ext4, ext5, ext6, opttime, userid, appid, description,
paychannel, payid, price, times, status, createtime, usertype, invoicestate, business_type, usbkey_order_id)
VALUES (newid, NULL, NULL, NULL, NULL, NULL, NULL, now(), param+ 1000008000+’’, NULL, ‘购买签章服务包’,FLOOR(RAND() * 2)+’’,
NULL, NULL, ‘300’, NULL, now(), FLOOR(RAND() * 2)+’’,FLOOR(RAND() * 2)+’’, FLOOR(RAND() * 2)+’’, usbkey_order_id);
set param=param+1;
set newid=’’;
set usbkey_order_id=’’;
end while;
end;