novice-gamer commented on issue #19884:
URL:
https://github.com/apache/shardingsphere/issues/19884#issuecomment-1219106331
When adding the rewritebatchedstatements = true parameter, an error will be
reported, resulting in failure to insert.
Code demo：
```
val ip = Until.getProperty("bidAnalyse.ip")
val port = Until.getProperty("bidAnalyse.port")
val db = Until.getProperty("bidAnalyse.db")
val user = Until.getProperty("bidAnalyse.user")
val pwd = Until.getProperty("bidAnalyse.pw")
Class.forName("com.mysql.jdbc.Driver")
val jdbcUrl = "jdbc:mysql://" + ip + ":" + port + "/" + db +
"?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true"
//&rewriteBatchedStatements=true batchHasPlainStatements=false
DriverManager.getConnection(jdbcUrl, user, pwd)
```
This is the proxy log：
```
[INFO ] 2022-08-18 14:38:12.277 [ShardingSphere-Command-737]
ShardingSphere-SQL - Logic SQL: insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','1'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','
未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='1',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','2'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','202
2-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='2',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',
site_name = '招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','3' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','
','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='3',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未�
�',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','4' ,'','','','0','�
�限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='4',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'华能(苏州工业园区)发电有限责��公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',rela
tion = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_typ
e1,phased_construction,expected_date,update_date,source_sort_id) values('','5'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='5',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '20
22-08-17',budget_fund = '',affiche_type = '招标公告',relation =
'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo =
'未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,indus
try,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','6'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='6',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',ag
ency_phone = '',collect_date = '2022-08-17',public_date =
'2022-08-17',budget_fund = '',affiche_type = '招标公告',relation =
'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo =
'未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,
open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','7'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='7',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date
,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','8'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='8',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='�
��州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone
= '',agency = '',agency_contact = '',agency_phone = '',collect_date =
'2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type =
'招标公告',relation = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,pu
rchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','9'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='9',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname = '',purchaser_o
peration_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation
_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','10'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','中国政��采购招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='10',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_
cityname = '苏州市',purchaser_county_id= '',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purch
aser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','11'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江���省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='11',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',
purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname =
'苏州市',purchaser_county_id= '',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_
prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','12'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='12',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '�
�限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,pro
ject_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','13'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='13',project_name = '',project_c
ode = '',project_type = '',project_status = '0',purchaser = '有限责任公司'
,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(
project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','14'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_d
is_id = '',project_content_id ='14',project_name = '',project_code =
'',project_type = '',project_status = '0',purchaser = '有限责任公司'
,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date = '20220817',s
ource_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','15'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','',''
,'','','','20220817','10055')ON DUPLICATE KEY UPDATE project_dis_id =
'',project_content_id ='15',project_name = '',project_code = '',project_type =
'',project_status = '0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 = '',phased_
construction = '',expected_date = '',update_date = '20220817',source_sort_id =
'10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','16'
,'','','','0','华能(苏州工业园区)发电有限责任��司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null'
,'','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='16',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry
= '',product = '',solution = '',sub_industry = '',purchasing_list =
'',project_type1 = '',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','17'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','',''
,'','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='17',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州���',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公
告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product =
'',solution = '',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','18' ,'','','','0','有限责任公司','','1
0','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='18',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date
= '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_s
ort_id) values('','19'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='19',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告
',relation = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,proje
ct_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','20'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='20',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_da
te = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation =
'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo =
'未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055'
[INFO ] 2022-08-18 14:38:12.278 [ShardingSphere-Command-737]
ShardingSphere-SQL - Actual SQL: ds_0 ::: insert into
bid_purchaser_info_dis_pro_2022(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id,
id) values('', '1', '', '', '', '0', '有限责任公司', '', '10', '江苏省', '3205', '苏州市',
'', '', '江苏省', '苏州市', '', '', '', '', '', '', '2022-08-17', '2022-08-17', '',
'招�
�公告', 'null', '', '', '2022年08月17日', '未知', '询价公告', 'http://www.xxx.com',
'招标网', '', '', '', '', '', '', '', '', '20220817', '10055',
767033731038068736)ON DUPLICATE KEY UPDATE project_dis_id =
'',project_content_id ='1',project_name = '',project_code = '',project_type =
'',project_status = '0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = '
http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','2' ,'','','','0','有限责任公司','','10','江苏省','32
05','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='2',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17�
�',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name
= '招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','
3'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='3',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',q
ualification = '',open_date = '',end_date = '2022年08月17日',is_combo =
'未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_const
ruction,expected_date,update_date,source_sort_id) values('','4'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='4',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budge
t_fund = '',affiche_type = '招标公告',relation = 'null',qualification =
'',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type =
'询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product
= '',solution = '',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,sol
ution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','5'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='5',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = ''
,collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '��国政府采购招标网',industry = '',product =
'',solution = '',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualific
ation,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','6'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='6',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_c
ontact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone
= '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collec
t_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','7'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='7',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityn
ame='苏州市',purchaser_operation_countyname='',purchaser_contact =
'',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_cont
act,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','8'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='8',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname = '',purch
aser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_ope
ration_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','9'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='9',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏�
�市',purchaser_county_id= '',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,pu
rchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','10'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公��','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='10',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname =
'苏州市',purchaser_county_id= '',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_pr
ovname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','11'
,'','','','0','华能(苏州工业��区)发电有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='11',project_name = '',project_code = '',project_type = '',project_status =
'0',
purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,p
roject_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','12'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id ='12',project_name
= '',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into bid_purchase
r_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','13'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UP
DATE project_dis_id = '',project_content_id ='13',project_name =
'',project_code = '',project_type = '',project_status = '0',purchaser =
'有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date
= '20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','14'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网'
,'','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE
project_dis_id = '',project_content_id ='14',project_name = '',project_code =
'',project_type = '',project_status = '0',purchaser = '有限责任公司'
,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
'江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id=
'',purchaser_countyname =
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_typ
e1 = '',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','15'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月
17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='15',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '��价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '
',solution = '',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','16'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','202
2-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='16',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http:/
/www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','17' ,'','','','0','有限责任公司','','10','江苏省','3205','
苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='17',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type = '招标公告',relation = 'null',qualification = '',open_date =
'',end_date = '2022年08月17日',i
s_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name =
'招标网',industry = '',product = '',solution = '',sub_industry =
'',purchasing_list = '',project_type1 = '',phased_construction =
'',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert
into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','18'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='18',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '华能(苏州工业���区)发电有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund =
'',affiche_type
= '招标公告',relation = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purcha
sing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','19'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='19',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone =
'',collect_date = '2022-0
8-17',public_date = '2022-08-17',budget_fund = '',affiche_type =
'招标公告',relation = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055';insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,f
rom_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id)
values('','20'
,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON
DUPLICATE KEY UPDATE project_dis_id = '',project_content_id
='20',project_name = '',project_code = '',project_type = '',project_status =
'0',purchaser = '有限责任公司' ,purchaser_address =
'',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id=
'3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname
=
'',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
= '',purchaser_phone = '',agency =
'',agency_contact = '',agency_phone = '',collect_date =
'2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type =
'招标公告',relation = 'null',qualification = '',open_date = '',end_date =
'2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url =
'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
'',sub_industry = '',purchasing_list = '',project_type1 =
'',phased_construction = '',expected_date = '',update_date =
'20220817',source_sort_id = '10055'
[ERROR] 2022-08-18 14:38:12.282 [ShardingSphere-Command-737]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'insert into
bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project' at line 1
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
