常用的sql

m0_66905297

已于 2024-03-21 16:15:02 修改

阅读量469

点赞数 4

文章标签： mysql

于 2024-03-06 00:26:18 首次发布

本文链接：https://blog.csdn.net/m0_66905297/article/details/136493587

版权

create database if not exists load_clare character set = utf8;
create table if not exists t0101_out(id bigint not null,hotelname varchar(25) COMMENT '交易套内\r\n序......\r\n号\r\n',year int not null,month int not null,day int not null,rent int not null,primary key(hotelname,year,month,day),global unique index iddex(id)) distributed by hash(id) (g1,g2,g3,g4);
create table if not exists t0101_out(id int not null,hotelname varchar(25),year int not null,month int not null,day int not null,rent int not null,primary key(hotelname,year,month,day),unique index iddex(id))distributed by hash(id) (g1,g2,g3,g4);
distributed by duplicate(g1,g2);
--虚拟列
create table if not exists t0101_out1(id int not null,hotelname varchar(25),year int not null,month int not null,id2 int generated always as((year +1)) stored,day int not null,rent int not null,primary key(hotelname,year,month,day),unique index iddex(id))distributed by hash(id) (g1,g2,g3)

drop database if exists load_clare;
create database if not exists load_clare character set = utf8;
create table if not exists t0101_out(id bigint not null,hotelname varchar(25) COMMENT '交易套内\r\n序......\r\n号\r\n',year int not null,month int not null,day int not null,rent int not null,primary key(hotelname,year,month,day),global unique index iddex(id)) distributed by hash(id) (g1,g2,g3,g4);
create table if not exists t0101_out3(id int not null,hotelname varchar(25),year int not null,month int not null,day int not null,rent int not null,primary key(hotelname,year,month,day),unique index iddex(id))distributed by hash(id) (g1,g2,g3,g4);
distributed by duplicate(g1,g2);
--虚拟列
create table if not exists t0101_out1(id int not null,hotelname varchar(25),year int not null,month int not null,id2 int generated always as((year +1)) stored,day int not null,rent int not null,primary key(hotelname,year,month,day),unique index iddex(id))distributed by hash(id) (g1,g2,g3)

insert into t0101_out1(id,hotelname,year,month,day,rent) values(2,'rujia',1988,1,2,199);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(3,'rujia',1989,1,3,198);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(4,'7tian',1998,2,1,218);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(5,'jinjiang',1998,2,2,219);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(6,'jinjiang1',1998,2,3,219);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(7,'rujia',2013,5,1,216);
insert into t0101_out1(id,hotelname,year,month,day,rent) values(8,'yaduo',2013,5,2,216);

insert into t0101_out(id,hotelname,year,month,day,rent) values(9,'xierdun',2013,5,3,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(10,'zhongxin',2014,6,1,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(111,'rujia',2014,6,2,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(112,'longhua',2014,6,3,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(113,'jinjiang',2014,5,1,318);
insert into t0101_out(id,hotelname,year,month,day,rent) values(14,'jinjiang',2014,6,1,319);
insert into t0101_out(id,hotelname,year,month,day,rent) values(15,'haokai',2013,5,3,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(16,'rujia',2015,6,1,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(1117,'fanchuan',2016,6,2,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(18,'rujia',2017,6,3,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(19,'haokai',2018,5,1,318);
insert into t0101_out(id,hotelname,year,month,day,rent) values(20,'shiji',2020,6,1,319);

create table if not exists t0101_out(id1 INT NOT NULL auto_increment primary key,id int not null ,hotelname varchar(25),year int not null,month int not null,day int not null,rent int not null,global unique index iddex(id)) distributed by hash(id) (g1,g2);
--Sequence
CREATE SEQUENCE load_clare.se_t1
START WITH 1 -- 从1开始
INCREMENT BY 1 -- 递增1
MAXVALUE 9999 -- 最大值
CYCLE;

--mysqlslap
create table if not exists poc_test.t1(int_1 INT NOT NULL auto_increment primary key,int_2 int(11) DEFAULT NULL,varchar_1 varchar(20))

mysqlslap -h192.168.100.250 -P5501 --iterations=1 --create-schema='poc_test' -udbproxy -p'db1x@NJ+1' --concurrency=4000 --query="INSERT INTO t1(int_2,varchar_1) VALUES (1 ,'poc_test01')"

CREATE TABLE sbtest1(
id int,
k INTEGER DEFAULT '0' NOT NULL,id2 int generated always as((k +1)) stored,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL
) distributed by hash(id)(g1,g2,g3);

drop table if exists poc_test.t1;
create table if not exists poc_test.t1(int_1 INT NOT NULL auto_increment primary key,int(11) DEFAULT NULL,varchar_1 varchar(20))distributed by hash(int_2)(g1,g2);
--hash表
create table if not exists load_clare.t(
int_1 INT NOT NULL primary key,
integer_1 INTEGER NULL ,
smallint_1 SMALLINT DEFAULT 10 ,
tinyint_1 TINYINT ,
mediumint_1 MEDIUMINT,
bigint_1 BIGINT ,
decimal_1 DECIMAL(65,30) UNSIGNED,
numeric_1 NUMERIC(65,30) ,
float_1 FLOAT not null,
double_1 DOUBLE UNSIGNED not null,
date_1 DATE,
timestamp_1 TIMESTAMP,
datetime_1 DATETIME,
time_1 TIME,
varchar_1 VARCHAR(150) ,
varchar_2 VARCHAR(150) ,
varchar_3 VARCHAR(150) ,
varchar_4 VARCHAR(150) ,
varchar_5 VARCHAR(150) ,
varchar_6 VARCHAR(150) ,
varchar_7 VARCHAR(150) ,
varchar_8 VARCHAR(150) ,
varchar_9 VARCHAR(150) ,
varchar_10 VARCHAR(150) ,
varchar_11 VARCHAR(150) ,
varchar_12 VARCHAR(150) ,
varchar_13 VARCHAR(150) ,
varchar_14 VARCHAR(150) ,
varchar_15 VARCHAR(150) ,
char_1 CHAR(250),
char_2 CHAR(14) DEFAULT 'a',
varchar_clare varchar(10) null,
text_1 TEXT,
binary_1 BINARY(255),
binary_2 BINARY(4),
varbinary_1 VARBINARY(20),
varbinary_2 VARBINARY(8),
blob_1 BLOB ,
year_1 year,
tinyint_2 tinyint,
enum_1 ENUM('S','M','L','XL','XXL','XXXL') not null,
set_1 SET('ONE','TWO', 'THREE','FOUR') not null,
index ind_varchar_1 (varchar_1,varchar_2(5) ASC),
unique index uk_dex (int_1))
distributed by hash (int_1) (g1,g2);
--duplicate
distributed by duplicate(g1,g2);
--list表
distributed by list(hotelname)(
g1 VALUES IN ('rujia','jinjiang'),
g2 VALUES IN ('7tian','haokai','huatai'));
--range
distributed by range(int_1)(
g1 VALUES LESS THAN (1991),
g2 VALUES LESS THAN MAXVALUE);

--重分布
---工行自定义GDB-336371
CREATE TABLE autohash ( card_number int(11) NOT NULL, account_id int(11) DEFAULT NULL, card_balance decimal(10,2) DEFAULT NULL, updatebalance_time timestamp NULL DEFAULT NULL, makecard_bank_id int(11) DEFAULT NULL, makecard_time datetime NOT NULL, PRIMARY KEY (card_number) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin DISTRIBUTED BY HASH(account_id)(g1,g2),ALGORITHM='hermes/murmur_hash',PARAM='oper=lpad,length=16,data="0"';
CREATE TABLE `autohash` ( `card_number` int(11) NOT NULL, `account_id` int(11) DEFAULT NULL, `card_balance` decimal(10,2) DEFAULT NULL, `updatebalance_time` timestamp NULL DEFAULT NULL, `makecard_bank_id` int(11) DEFAULT NULL, `makecard_time` datetime NOT NULL, PRIMARY KEY (`card_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin DISTRIBUTED BY HASH(`account_id`)(g1,g2),ALGORITHM='hermes/murmur_hash',PARAM='oper=lpad,length=16,data="0"';

CREATE TABLE tb1
(
id INT NOT NULL PRIMARY KEY,
cno VARCHAR(20)
)
DISTRIBUTED BY HASH(cno)(g1,g2)
ALGORIT HM=‘plugin_name/algorithm_name’,PARAM=‘oper=lpad,length=15,data=“0”’;

insert into autohash (card_number,account_id,card_balance,updatebalance_time,makecard_bank_id,makecard_time) values(112,'11',7,'1987-07-04 05:20:00',2,'1987-07-04');
重分布语句
distributed by HASH(`account_id`)(g1-g3),ALGORITHM='hermes/murmur_hash', PARAM='oper=lpad, length=16, data="0"';
ALGORITHM='hermes/murmur_hash', PARAM='oper=lpad,length=15,data="0"';
--字段有空格，一般字段没有空格吗
CREATE TABLE 'tarfilesep_tb' (
'id1' int(11) NOT NULL,
'id2' bigint(20) DEFAULT NULL,
'id3' smallint(6) DEFAULT NULL,
'id4' varchar(64) DEFAULT NULL,
'id5' char(64) DEFAULT NULL,
PRIMARY KEY ('id1')
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
DISTRIBUTED BY HASH('id1')(g1,g2,g3)
insert into PR855479_DB.tarfilesep_tb values (46,49340630,683,'ox
sdfds','sfd
dff')" % (id1, id2, id3, id4, id5)

--企业版才能使用重分布创建多级分片表
create table load_clare.t1(id int key, city varchar(128) not null)distributed by case city when 'nj' then subdistributed by range(id)(g1 values less than (100), g2 values less than (300));end case

insert into load_clare.t1 values(20,'nj'),(280,'nj'),(120,'nj')
分发规则为distributed by case city when 'nj' then subdistributed by range(id)(g1 values less than (200), g2 values less than (400));end case

delimiter //
create table t1_101(id1 int,id2 int key,name1 varchar(10),primary key(id1,id2,month,day))distributed by
case id1
when 1 then g1;
when 2 then g2;
else g3;
end case;//
delimiter ;
insert into t1_101(id1,id2,name1)values(1,10,'xyz');
insert into t1_101(id1,id2,name1)values(1,20,'xtz');
insert into t1_101(id1,id2,name1)values(1,30,'abc'),(2,10,'xyz'),(2,20,'abc'),(2,30,'www');
insert into t1_101(id1,id2,name1)values(3,10,'afc'),(3,20,'xyz'),(3,30,'abc');
insert into t1_101(id1,id2,name1)values(10,100,'afc'),(11,200,'xyz'),(4,300,'abc');

重分布命令：distributed by case id1
when 2 then g4;
when 1 then g2;
else g4;
end case;

delimiter //
create table load_clare.t1(id1 int,id2 int,id3 bigint,id4 int key,name1 varchar(10),time1 timestamp)partition by hash(id4)(partition p0,partition p1) distributed by
case
when (id1*4+id2)/2-10>=1 and (id1*4+id2)/2-10<10 then
case
when id2+id3>=1 and id2+id3<10 then subdistributed by list(day(time1)*2+hour(time1))(g1 values in(34,61,15,36));
when id2+id3>=10 and id2+id3<100 then subdistributed by range(id2*2+id3)(g2 values less than maxvalue);
end case;
else subdistributed by duplicate(g3);
end case;//
delimiter ;

delimiter //
create table if not exists t0101_out(
id int,hotelname varchar(25),year int not null,month int not null,day int not null,rent int,primary key(id),unique index iddex(id))
distributed by
case
when year>=2021 then
case
when month<100 then subdistributed by hash(id)(g1);
else subdistributed by hash(id)(g2);
end case;
else subdistributed by hash(id)(g3);
end case; //
delimiter ;

--多级分片+分区
-delimiter //
create table if not exists tt1(
id1 int,
name char(15),
city varchar(15),
country char(7),
primary key (id1,name,city))
partition by range (substr(city,8,2))
(PARTITION part_0 VALUES less than (' '),
PARTITION part_1 VALUES less than ('11'),
PARTITION part_2 VALUES less than ('1X'),
PARTITION part_3 VALUES less than ('55'),
PARTITION part_4 VALUES less than ('5X'),
PARTITION part_5 VALUES less than ('99'),
PARTITION part_6 VALUES less than ('9X'),
PARTITION part_7 VALUES less than ('zz'))
distributed by
case
when country= 'china' then
case
when id1<100 then subdistributed by hash(name)(g1);
else subdistributed by hash(name)(g2);
end case;

else subdistributed by hash(name)(g3);
end case; //
delimiter ;

--range重分布，分区分片键相同
create table if not exists t4(
id INT NOT NULL primary key,
name VARCHAR(15))
PARTITION BY RANGE (`id`)(
PARTITION p10 VALUES LESS THAN (1000),PARTITION p20 VALUES LESS THAN (2000),PARTITION p30 VALUES LESS THAN (3000),PARTITION p40 VALUES LESS THAN (4000))
distributed by range(`id`)(
g1 VALUES LESS THAN (1000),
g2 VALUES LESS THAN MAXVALUE);
插数据
insert into t4(id,name) values (999,'xiaomao'),(1999,'xiaogou'),(2999,'xiaozhu'),(3999,'xiaoniao');

观察mds进程
--分区
CREATE TABLE a (
'id' INT NOT NULL AUTO_INCREMENT,
'partition_key' INT NOT NULL,
'amt' DECIMAL(5) NULL,
PRIMARY KEY ('id' , 'partition_key'),index iddex(id)
) PARTITION BY RANGE (partition_key) (
PARTITION p0 VALUES LESS THAN (201901) ,
PARTITION p1 VALUES LESS THAN (201902) ,
PARTITION p2 VALUES LESS THAN (201903))distributed by hash(id) (g1,g2);

INSERT INTO 'a' ('id', 'partition_key', 'amt') VALUES ('1', '201901', '1000');
INSERT INTO 'a' ('id', 'partition_key', 'amt') VALUES ('2', '201902', '800');
alter table a reorganize partition s3 into (partition s4 values less than (100),partition s5 values less than (200));
--
create table t1(id1 int,id2 int,id3 bigint,id4 int key,name1 varchar(10),time1 timestamp)partition by hash(id4)(partition p0,partition p1) distributed by hash(id1)(g1,g2);

#!/bin/bash
for ((i=1; i<=$1; i++))
do
select_sql="select * from test_sj.user_card_info_hash;"
mysql -h10.229.42.60 -P8880 -udbproxy -p'db1x@NJ+1' -e "${select_sql}"
done
start transaction;
insert into load_clare.t1 values(11,50),(50,50),(120,100),(-2,0);
insert into load_clare.t01 values(11,11,51),(2,50,50),(13,120,100),(14,-2,0);

insert t0101_out1(id,hotelname,year,month,day,rent) values(2,'rujia',1988,1,22,199);
start transaction;
insert into t0101_out(id,hotelname,year,month,day,rent) values(2,'rujia',1988,1,2,199);
insert into t0101_out(id,hotelname,year,month,day,rent) values(3,'rujia',1989,1,3,198);
insert into t0101_out(id,hotelname,year,month,day,rent) values(4,'7tian',1998,2,1,218);
insert into t0101_out(id,hotelname,year,month,day,rent) values(5,'jinjiang',1998,2,2,219);
insert into t0101_out(id,hotelname,year,month,day,rent) values(6,'jinjiang1',1998,2,3,219);
insert into t0101_out(id,hotelname,year,month,day,rent) values(7,'rujia',2013,5,1,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(8,'yaduo',2013,5,2,216);

insert into t0101_out(id,hotelname,year,month,day,rent) values(21117,'ylonghua',2015,5,2,217);
commit;
--冷热备份

--jmeter
begin;

insert into t0101_out2(id,hotelname,year,month,day,rent) values(${__Random(5,999999,)},'${__Random(11,29998,)}',${__Random(1900,2120,)},${__Random(01,2224,)},${__Random(0,10000,)},${__Random(24,12112020,)});

insert into t0101_out(id,hotelname,year,month,day,rent) values(${__Random(5,999999,)},'${__Random(11,29998,)}',${__Random(1900,2120,)},${__Random(01,2224,)},${__Random(0,10000,)},${__Random(24,12112020,)});
insert into t0101_out4(id,hotelname,year,month,day,rent) values(${__Random(5,999999,)},'${__Random(11,29998,)}',${__Random(1900,2120,)},${__Random(01,2224,)},${__Random(0,10000,)},${__Random(24,12112020,)});
commit;

--普通没有分布式表

create table t0102_out(id int not null,hotelname varchar(25),year int not null,month int not null,day int not null,rent int not null,update_time timestamp DEFAULT now(),primary key(hotelname,year,month,day));
create table t0101_out(id int not null,hotelname varchar(25),year int not null,month int not null,day int not null,rent int not null,update_time timestamp DEFAULT now(),primary key(hotelname,year,month,day));
--
create table autohash ('card_number' int(11) NOT NULL, 'account_id' int(11) DEFAULT NULL, 'card_balance' decimal(10,2) DEFAULT NULL, 'updatebalance_time' timestamp NULL DEFAULT NULL, 'makecard_bank_id' int(11) DEFAULT NULL, 'makecard_time' datetime NOT NULL, PRIMARY KEY ('card_number'));

insert into autohash (card_number,account_id,card_balance,updatebalance_time,makecard_bank_id,makecard_time) values(112,'11',7,'1987-07-04 05:20:00',2,'1987-07-04');

CREATE TABLE t01 (id int(11) primary key，a int(10) not null,c int(13) default null);
CREATE TABLE test_image_information_empty (
id bigint NOT NULL,
province_no char(3),
id_card_no char(32),
id_card_type char(2),
id_value char(32),
name char(32),
gender char(2),
nationality char(32),
birth_date char(8),
address char(32),
sign_organization varchar(100),
period_of_vaild integer default -2147483648,
image_id char(32),
image_type char(1),
image_time varchar(20),
business_type char(2),
is_agent char(1),
update_time timestamp DEFAULT now()
);
--t2
insert into poc_test.t2(int_1,integer_1,smallint_1,tinyint_1,mediumint_1,bigint_1,decimal_1,numeric_1,float_1,double_1,date_1,timestamp_1,datetime_1,time_1,varchar_1,char_1,char_2,varchar_2,text_1,binary_1,binary_2,varbinary_1,varbinary_2,blob_1,year_1,tinyint_2,enum_1,set_1)values
(-2147483648,-2147483648,-32768,-128,-8388608,-9223372036854775808,12345678901234567890123456789012345.123456789012345678901234567809,12345678901234567890123456789054321.123456789012345678909876543201,1,1,'1987-07-04','1987-02-25 05:20:00','1987-07-04 05:20:00',
'05:20:00','aaaaaaaaaabbbbb','abcdefg','bbbb','abcdeftg','丧/丨/丩/个/丫/丬/中/丮/丯/丰/丱/串/丳/临/丵/丶/丷/丸/丹/为','aaaaaaaaaabbbbbbbbbb','abcd','aaaaabbbbb','abc12345'
,'123456',2016,1,1,3),(20150310,1073741824,16384,68,4194304,4611686018427387903,12345678901234567890123456789012345.123456789012345678901234567809,12345678901234567890123456789054321.123456789012345678909876543201,1.123456789,1.123456789,'2014-10-13','2014-10-13 23:05:10','2014-10-13 23:05:10','23:05:10','aaaaaaaaaabbbbb','bbb','aaa','xewer','一/丁/丂/七/丄/丅/丆/万/丈/三/上/下/丌/不/与/丏/丐/丑/丒/专/且/丕/世/丗/丘/丙/业/丛/东/丝/丞/丟/丠/両/丢/丣/两/严/並','hellohellohellohellohellohellohello',
'bbbb','aaaaa2','xxxxx','yyyyyyyy1111',2016,0,2,4);

insert into t1 values(11,50),(50,50),(120,100),(-2,0),(11,11,51),(2,50,50),(13,120,100),(14,-2,0);
insert into t01 values(11,11,51),(2,50,50),(13,120,100),(14,-2,0);
insert into t0101_out(id,hotelname,year,month,day,rent) values(1,'rujia',1988,1,1,198);
insert into t0101_out(id,hotelname,year,month,day,rent) values(1,'rujia',1988,1,1,198);
insert into t0101_out(id,hotelname,year,month,day,rent) values(2,'rujia',1988,1,2,199);
insert into t0101_out(id,hotelname,year,month,day,rent) values(3,'rujia',1988,1,3,199);
insert into t0101_out(id,hotelname,year,month,day,rent) values(4,'jinjiang',1998,2,1,218);
insert into t0101_out(id,hotelname,year,month,day,rent) values(5,'jinjiang',1998,2,2,219);
insert into t0101_out(id,hotelname,year,month,day,rent) values(6,'jinjiang',1998,2,3,219);
insert into t0101_out(id,hotelname,year,month,day,rent) values(7,'rujia',2013,5,1,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(8,'rujia',2013,5,2,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(9,'rujia',2013,5,3,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(10,'rujia',2014,6,1,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(11,'rujia',2014,6,2,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(12,'rujia',2014,6,3,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(13,'jinjiang',2014,5,1,318);
insert into t0101_out(id,hotelname,year,month,day,rent) values(14,'jinjiang',2014,6,1,319);
insert into t0101_out(id,hotelname,year,month,day,rent) values(15,'haokai',2013,5,3,216);
insert into t0101_out(id,hotelname,year,month,day,rent) values(16,'rujia',2015,6,1,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(17,'fanchuan',2016,6,2,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(18,'rujia',2017,6,3,217);
insert into t0101_out(id,hotelname,year,month,day,rent) values(19,'haokai',2018,5,1,318);
insert into t0101_out(id,hotelname,year,month,day,rent) values(20,'shiji',2020,6,1,319);

create table load_clare.idcard_info_01(id int not null, idcard_id varchar(10), idcard_type varchar(10), idcard_name varchar(25), create_time datetime);
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'b', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'c', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'ru', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'injian', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'injian', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'Ainjian', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'Ainjian ', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'Ainjian ', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
INSERT INTO idcard_info_01 (id, idcard_id, idcard_type, idcard_name, create_time) VALUES (1, 2, 'injianB', 'aaaaaaaaaaaaaaaaaaaa', '2021-04-01 15:32:17');
--特殊字符用例
#特殊字符
insert into test_image_information_empty (id,id_card_no,image_id,business_type,period_of_vaild,id_value,update_time) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企', 2147483647,'!','2021-04-01 15:32:17');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,period_of_vaild,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',2147483647,'@');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','#');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','$');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','%');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','^');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','&');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','*');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','(');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',')');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','_');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','-');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','+');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','=');---
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','{');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','}');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','[');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',']');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','\');--------------转义字符不显示
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','、');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',';');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',':');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','"');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','''');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','/');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','?');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','>');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','<');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企',',');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','.');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','《》');
#换行符----------------
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','前半段\n后半段');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','前半段\r后半段');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','前半段\r\n后半段');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','前半段\n\r后半段');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','前半段
后半段');
#包裹符
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','\"');-------------转义
update test_image_information_empty set id =39
#列分隔符
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','|');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','^A');
#空字符和null
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NULL');---null
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','');---
#转义字符----
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','沃尔沃V90 CC还能\"车当船开\"');-- CC还能"车当船开"
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','沃尔沃V90 CC还能\￥车当船开\￥');---CC还能￥车当船开￥
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','沃尔沃V90 CC还能\a车当船开\a');--CC还能￥车当船开￥

#mysql
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ADD');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ALL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ALTER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ANALYZE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','AND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','AS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ASC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ASENSITIVE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BEFORE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BETWEEN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BIGINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BINARY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BLOB');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BOTH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','BY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CALL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CASCADE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CASE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CHANGE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CHAR');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CHARACTER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CHECK');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','COLLATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','COLUMN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CONDITION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CONNECTION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CONSTRAINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CONTINUE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CONVERT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CREATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CROSS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CURRENT_DATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CURRENT_TIME');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CURRENT_TIMESTAMP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CURRENT_USER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','CURSOR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DATABASE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DATABASES');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DAY_HOUR');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DAY_MICROSECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DAY_MINUTE');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DAY_SECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DEC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DECIMAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DECLARE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DEFAULT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DELAYED');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DELETE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DESC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DESCRIBE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DETERMINISTIC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DISTINCT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DISTINCTROW');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DIV');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DOUBLE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DROP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','DUAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','EACH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ELSE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ELSEIF');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ENCLOSED');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ESCAPED');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','EXISTS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','EXIT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','EXPLAIN');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FALSE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FETCH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FLOAT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FLOAT4');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FLOAT8');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FOR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FOREIGN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FROM');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FULLTEXT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','GOTO');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','GRANT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','GROUP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','HAVING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','HIGH_PRIORITY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','HOUR_MICROSECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','HOUR_MINUTE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','HOUR_SECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','IF');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','IGNORE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','IN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INDEX');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INFILE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INNER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INOUT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INSENSITIVE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INSERT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT1');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT2');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT3');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT4');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INT8');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INTEGER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INTERVAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','INTO');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','IS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ITERATE');--
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','JOIN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','KEY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','KEYS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','KILL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LABEL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LEADING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LEAVE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LEFT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LIKE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LIMIT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LINEAR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LINES');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOAD');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOCALTIME');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOCALTIMESTAMP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOCK');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LONG');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LONGBLOB');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LONGTEXT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOOP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','LOW_PRIORITY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MATCH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MEDIUMBLOB');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MEDIUMINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MEDIUMTEXT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MIDDLEINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MINUTE_MICROSECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MINUTE_SECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MOD');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','MODIFIES');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NATURAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NO_WRITE_TO_BINLOG');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NULL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NUMERIC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ON');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OPTIMIZE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OPTION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OPTIONALLY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ORDER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OUT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OUTER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','OUTFILE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','PRECISION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','PRIMARY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','PROCEDURE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','PURGE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RAID0');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RANGE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','READ');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','READS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REFERENCES');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REGEXP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RELEASE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RENAME');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REPEAT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REPLACE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REQUIRE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RESTRICT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RETURN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','REVOKE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RIGHT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','RLIKE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SCHEMA');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SCHEMAS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SECOND_MICROSECOND');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SELECT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SENSITIVE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SEPARATOR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SET');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SHOW');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SMALLINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SPATIAL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SPECIFIC');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQLEXCEPTION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQLSTATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQLWARNING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQL_BIG_RESULT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQL_CALC_FOUND_ROWS');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SQL_SMALL_RESULT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','SSL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','STRAIGHT_JOIN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TABLE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TERMINATED');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','THEN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TINYBLOB');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TINYINT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TINYTEXT');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TO');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TRAILING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TRIGGER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','TRUE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UNDO');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UNION');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UNIQUE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UNLOCK');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UNSIGNED');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UPDATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','USAGE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','USE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','USING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UTC_DATE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UTC_TIME');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','UTC_TIMESTAMP');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','VALUES');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','VARBINARY');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','VARCHAR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','VARCHARACTER');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','VARYING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','WHEN');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','WHERE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','WHILE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','WITH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','WRITE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','X509');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','XOR');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','YEAR_MONTH');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','ZEROFILL');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','FORCE');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','STARTING');
insert into test_image_information_empty (id,id_card_no,image_id,business_type,id_value) values (rand(10000),'83187961299518796129951879612995','83187961299518796129951879612995','私企','NOT');

m0_66905297

关注

4
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
常用的sql

create database if not exists load_clare character set = utf8;create table if not exists t0101_out(id bigint not null,hotelname varchar(25) COMMENT '交易套内\r\n序......\r\n号\r\n',year int not null,month int not null,day int not null,rent int not null,primary
复制链接

扫一扫