It is slow to use JDBC connection shardingsphere proxy to write

[novice-gamer]

Shardingsphere proxy version 5.1.3 It is slow to use JDBC connection shardingsphere proxy to write.

Links used by stand-alone databases:

jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true

Links used by shardingsphere proxy:

jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true

Is it necessary to modify parameters after changing to proxy to realize batch fast writing?

[TeslaCN]

Try adding rewriteBatchedStatements=true to client's JDBC URL.

[novice-gamer]

This parameter is added when the spark program calls JDBC to use the database, but it is still slow. Is there any other recommended optimization method?

[TeslaCN]

Could you provide a demo about this issue? There are too many reasons could impact performance.

[novice-gamer]

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','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',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 = '招标公告',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('','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,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('','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 = '',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('','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,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,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,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,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,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 UPDATE  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_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('','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','有限责任公司','','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,purchasing_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-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('','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'
[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','江苏省','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 ='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 = '招标公告',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('','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,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('','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 = '',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('','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,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,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,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,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,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 UPDATE  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_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('','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','有限责任公司','','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,purchasing_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-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('','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

[TeslaCN]

Try setting allowMultiQueries=false. Then the MySQL Connector will send COM_SET_OPTIONS implicitly.

[agoodcoolman]

I hava the same question .

use Proxy 5.1.2 . this is command java -server -Xmx8g -Xms8g -Xmn4g -Xss1024k -XX:+DisableExplicitGC -XX:+UseConcMarkSweepGC -XX:+CMSParallelRemarkEnabled -XX:LargePageSizeInBytes=4g -XX:+UseFastAccessorMethods -XX:+UseCMSInitiatingOccupancyOnly -XX:CMSInitiatingOccupancyFraction=70 -Dfile.encoding=UTF-8 -classpath %CLASS_PATH% %MAIN_CLASS%

server.yaml

rules:
  - !AUTHORITY
    users:
      - root@:XXXX
      - sharding@:XXXX
    provider:
      type: ALL_PRIVILEGES_PERMITTED

props:
  max-connections-size-per-query: 1
  kernel-executor-size: 16  # Infinite by default.
  proxy-frontend-flush-threshold: 128  # The default value is 128.
  proxy-opentracing-enabled: false
  proxy-hint-enabled: false
  sql-show: true
  check-table-metadata-enabled: false

config-sharding.yaml

schemaName: sharding_db
dataSources:
  ds0:
    url: jdbc:postgresql://XXX.XXX.XXX.XXXX:port/data
    username: [username]
    password: [password]
    connectionTimeoutMilliseconds: 30000
    idleTimeoutMilliseconds: 60000
    maxLifetimeMilliseconds: 1800000
    maxPoolSize: 50
    minPoolSize: 1

rules:
  - !SHARDING
    tables:
      memberinfo:
        actualDataNodes: ds0.memberinfo_$->{[0,1,2,3,4,5,6,7,8,9]}
        tableStrategy:
          standard:
            shardingColumn: idcard
            shardingAlgorithmName: hash_mode10
      mzmember:
        actualDataNodes: ds0.mzmember_$->{[0,1,2,3]}
        tableStrategy:
          standard:
            shardingColumn: id_card
            shardingAlgorithmName: hash_mode4
      csvgonanhj:
        actualDataNodes: ds0.csvgonanhj_$->{[0,1,2,3,4,5,6,7,8,9]}
        tableStrategy:
          standard:
            shardingColumn: pid
            shardingAlgorithmName: hash_mode10
      memberresult:
        actualDataNodes: ds0.memberresult_$->{[0,1,2,3,4,5,6,7,8,9]}
        tableStrategy:
          standard:
            shardingColumn: idcard
            shardingAlgorithmName: hash_mode10
      applyinfo:
        actualDataNodes: ds0.applyinfo_$->{[0,1,2,3,4]}
        tableStrategy:
          standard:
            shardingColumn: idcard
            shardingAlgorithmName: hash_mode5
    defaultTableStrategy:
      none:
    shardingAlgorithms:
      hash_mode:
        type: HASH_MOD
        props:
          sharding-count: 1
      hash_mode10:
        type: HASH_MOD
        props:
          sharding-count: 10
      hash_mode4:
        type: HASH_MOD
        props:
          sharding-count: 4
      hash_mode5:
        type: HASH_MOD
        props:
          sharding-count: 5
    keyGenerators:
      snowflake:
        type: SNOWFLAKE
        props:
          worker-id: 123
    bindingTables:
      - memberinfo,csvgonanhj,memberresult

sql select member_id, idcard, cast(substring(idcard, 7, 4) as int) as age1, cast(substring(idcard, 11, 2) as int) as age2 from memberresult limit 10 offset ?;

[github-actions[bot]]

Hello , this issue has not received a reply for several days. This issue is supposed to be closed.