SQL Demo

Demo-1 Fuzzy query and Replace

SELECT * from "RDB_BusinessTypeDefine" where "Name" like '%马坑铁矿主管副矿长%';
UPDATE "RDB_BusinessTypeDefine" SET "Name" = REPLACE("Name",'马坑铁矿主管副矿长','马坑铁矿技术负责人') WHERE "Name" like '%马坑铁矿主管副矿长%';

SELECT * from "RDB_BusinessToolList" where "Note" like '%生技科测量负责人%';
UPDATE "RDB_BusinessToolList" SET "Note" = REPLACE("Note",'生技科测量负责人','马坑铁矿测量负责人') WHERE "Note" like '%生技科测量负责人%';

SELECT * from "RDB_BusinessIODefine" where "Note" like '%生技科采矿负责人%';
UPDATE "RDB_BusinessIODefine" SET "Note" = REPLACE("Note",'生技科采矿负责人','马坑铁矿采矿负责人') WHERE "Note" like '%生技科采矿负责人%';

SELECT * from "RDB_BusinessIOQueryDefine" where "Note" like '%生技科地质负责人%';
UPDATE "RDB_BusinessIOQueryDefine" SET "Note" = REPLACE("Note",'生技科地质负责人','马坑铁矿地质负责人') WHERE "Note" like '%生技科地质负责人%';

SELECT * from "RDB_ActivitiTaskBusinessType" where "Note" like '%生技科测量负责人%';
UPDATE "RDB_ActivitiTaskBusinessType" SET "Note" = REPLACE("Note",'生技科测量负责人','马坑铁矿测量负责人') WHERE "Note" like '%生技科测量负责人%';

SELECT * from "RDB_BusinessBeforeCommandExecEvent" where "Note" like '%生技科测量负责人%';
UPDATE "RDB_BusinessBeforeCommandExecEvent" SET "Note" = REPLACE("Note",'生技科测量负责人','马坑铁矿测量负责人') WHERE "Note" like '%生技科测量负责人%';

Demo-2 Bulk insert data

INSERT INTO "RDB_FeatureRequiredFieldDefine" 
("FeatureName","FeatureValue","FieldName","FieldDisplayName","Note")
VALUES
(	'勘探线'	,	101	,	'Number'	,	'勘探线号'	,	'勘探线'	)	,
(	'采矿权边界线'	,	151	,	'MiningLicenseNumber'	,	'采矿权许可证号'	,	'矿权'	)	,
(	'圈定解译线'	,	502	,	'GeologicalInterpretationLineType'	,	'地质解译线类型'	,	'地质解译线'	)	;

Reference

W3school SQL