CREATE TABLE temp_tdim_com_prov_city_orgs DATA_DATE date DEFAULT NULL COMMENT 数据日期 DATA_DATE_STR varchar12 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 数据日期字符 COM_ORG_CODE varchar128 COLLATE ut

INSERT INTO temp_tdim_com_prov_city_orgs (DATA_DATE, DATA_DATE_STR, COM_ORG_CODE, COM_ORG_NAME, ORG_LEVEL, ORG_TYPE_CODE, PROVINCE_NAME, REGION_NAME) VALUES ('2021-01-01', '2021-01-01', '123456', 'Company A', 'Level 1', 'Type 1', 'Province A', 'City A'); INSERT INTO temp_tdim_com_prov_city_orgs (DATA_DATE, DATA_DATE_STR, COM_ORG_CODE, COM_ORG_NAME, ORG_LEVEL, ORG_TYPE_CODE, PROVINCE_NAME, REGION_NAME) VALUES ('2021-01-01', '2021-01-01', '789012', 'Company B', 'Level 2', 'Type 2', 'Province B', 'City B'); INSERT INTO temp_tdim_com_prov_city_orgs (DATA_DATE, DATA_DATE_STR, COM_ORG_CODE, COM_ORG_NAME, ORG_LEVEL, ORG_TYPE_CODE, PROVINCE_NAME, REGION_NAME) VALUES ('2021-01-01', '2021-01-01', '345678', 'Company C', 'Level 3', 'Type 3', 'Province C', 'City C');