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;