省市区SQL

首页
栏目
CRM
省市区SQL

2022-01-12
Admin

SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS XXX;
CREATE TABLE XXX (
code_id int(11) DEFAULT NULL,
parent_id int(11) DEFAULT NULL,
city_name varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT=‘地名表’;

INSERT INTO 72crm_crm_area_two VALUES (‘110000’, ‘0’, ‘北京市’);
INSERT INTO 72crm_crm_area_two VALUES (‘110100’, ‘110000’, ‘直辖市’);
INSERT INTO 72crm_crm_area_two VALUES (‘110101’, ‘110100’, ‘东城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110102’, ‘110100’, ‘西城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110105’, ‘110100’, ‘朝阳区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110106’, ‘110100’, ‘丰台区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110107’, ‘110100’, ‘石景山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110108’, ‘110100’, ‘海淀区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110109’, ‘110100’, ‘门头沟区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110111’, ‘110100’, ‘房山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110112’, ‘110100’, ‘通州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110113’, ‘110100’, ‘顺义区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110114’, ‘110100’, ‘昌平区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110115’, ‘110100’, ‘大兴区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110116’, ‘110100’, ‘怀柔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110117’, ‘110100’, ‘平谷区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110118’, ‘110100’, ‘密云区’);
INSERT INTO 72crm_crm_area_two VALUES (‘110119’, ‘110100’, ‘延庆区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120000’, ‘0’, ‘天津市’);
INSERT INTO 72crm_crm_area_two VALUES (‘120100’, ‘120000’, ‘直辖市’);
INSERT INTO 72crm_crm_area_two VALUES (‘120101’, ‘120100’, ‘和平区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120102’, ‘120100’, ‘河东区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120103’, ‘120100’, ‘河西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120104’, ‘120100’, ‘南开区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120105’, ‘120100’, ‘河北区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120106’, ‘120100’, ‘红桥区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120110’, ‘120100’, ‘东丽区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120111’, ‘120100’, ‘西青区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120112’, ‘120100’, ‘津南区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120113’, ‘120100’, ‘北辰区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120114’, ‘120100’, ‘武清区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120115’, ‘120100’, ‘宝坻区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120116’, ‘120100’, ‘滨海新区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120117’, ‘120100’, ‘宁河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120118’, ‘120100’, ‘静海区’);
INSERT INTO 72crm_crm_area_two VALUES (‘120119’, ‘120100’, ‘蓟州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130000’, ‘0’, ‘河北省’);
INSERT INTO 72crm_crm_area_two VALUES (‘130100’, ‘130000’, ‘石家庄市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130102’, ‘130100’, ‘长安区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130104’, ‘130100’, ‘桥西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130105’, ‘130100’, ‘新华区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130107’, ‘130100’, ‘井陉矿区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130108’, ‘130100’, ‘裕华区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130109’, ‘130100’, ‘藁城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130110’, ‘130100’, ‘鹿泉区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130111’, ‘130100’, ‘栾城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130121’, ‘130100’, ‘井陉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130123’, ‘130100’, ‘正定县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130125’, ‘130100’, ‘行唐县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130126’, ‘130100’, ‘灵寿县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130127’, ‘130100’, ‘高邑县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130128’, ‘130100’, ‘深泽县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130129’, ‘130100’, ‘赞皇县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130130’, ‘130100’, ‘无极县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130131’, ‘130100’, ‘平山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130132’, ‘130100’, ‘元氏县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130133’, ‘130100’, ‘赵县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130181’, ‘130100’, ‘辛集市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130183’, ‘130100’, ‘晋州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130184’, ‘130100’, ‘新乐市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130200’, ‘130000’, ‘唐山市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130202’, ‘130200’, ‘路南区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130203’, ‘130200’, ‘路北区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130204’, ‘130200’, ‘古冶区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130205’, ‘130200’, ‘开平区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130207’, ‘130200’, ‘丰南区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130208’, ‘130200’, ‘丰润区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130209’, ‘130200’, ‘曹妃甸区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130224’, ‘130200’, ‘滦南县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130225’, ‘130200’, ‘乐亭县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130227’, ‘130200’, ‘迁西县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130229’, ‘130200’, ‘玉田县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130230’, ‘130200’, ‘芦台区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130281’, ‘130200’, ‘遵化市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130283’, ‘130200’, ‘迁安市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130284’, ‘130200’, ‘滦州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130300’, ‘130000’, ‘秦皇岛市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130302’, ‘130300’, ‘海港区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130303’, ‘130300’, ‘山海关区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130304’, ‘130300’, ‘北戴河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130306’, ‘130300’, ‘抚宁区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130321’, ‘130300’, ‘青龙满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130322’, ‘130300’, ‘昌黎县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130324’, ‘130300’, ‘卢龙县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130400’, ‘130000’, ‘邯郸市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130402’, ‘130400’, ‘邯山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130403’, ‘130400’, ‘丛台区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130404’, ‘130400’, ‘复兴区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130406’, ‘130400’, ‘峰峰矿区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130407’, ‘130400’, ‘肥乡区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130408’, ‘130400’, ‘永年区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130423’, ‘130400’, ‘临漳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130424’, ‘130400’, ‘成安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130425’, ‘130400’, ‘大名县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130426’, ‘130400’, ‘涉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130427’, ‘130400’, ‘磁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130430’, ‘130400’, ‘邱县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130431’, ‘130400’, ‘鸡泽县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130432’, ‘130400’, ‘广平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130433’, ‘130400’, ‘馆陶县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130434’, ‘130400’, ‘魏县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130435’, ‘130400’, ‘曲周县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130481’, ‘130400’, ‘武安市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130500’, ‘130000’, ‘邢台市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130502’, ‘130500’, ‘襄都区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130503’, ‘130500’, ‘信都区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130505’, ‘130500’, ‘任泽区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130506’, ‘130500’, ‘南和区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130522’, ‘130500’, ‘临城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130523’, ‘130500’, ‘内丘县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130524’, ‘130500’, ‘柏乡县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130525’, ‘130500’, ‘隆尧县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130528’, ‘130500’, ‘宁晋县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130529’, ‘130500’, ‘巨鹿县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130530’, ‘130500’, ‘新河县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130531’, ‘130500’, ‘广宗县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130532’, ‘130500’, ‘平乡县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130533’, ‘130500’, ‘威县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130534’, ‘130500’, ‘清河县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130535’, ‘130500’, ‘临西县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130581’, ‘130500’, ‘南宫市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130582’, ‘130500’, ‘沙河市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130600’, ‘130000’, ‘保定市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130602’, ‘130600’, ‘竞秀区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130606’, ‘130600’, ‘莲池区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130607’, ‘130600’, ‘满城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130608’, ‘130600’, ‘清苑区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130609’, ‘130600’, ‘徐水区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130623’, ‘130600’, ‘涞水县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130624’, ‘130600’, ‘阜平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130626’, ‘130600’, ‘定兴县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130627’, ‘130600’, ‘唐县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130628’, ‘130600’, ‘高阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130629’, ‘130600’, ‘容城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130630’, ‘130600’, ‘涞源县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130631’, ‘130600’, ‘望都县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130632’, ‘130600’, ‘安新县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130633’, ‘130600’, ‘易县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130634’, ‘130600’, ‘曲阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130635’, ‘130600’, ‘蠡县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130636’, ‘130600’, ‘顺平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130637’, ‘130600’, ‘博野县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130638’, ‘130600’, ‘雄县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130681’, ‘130600’, ‘涿州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130682’, ‘130600’, ‘定州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130683’, ‘130600’, ‘安国市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130684’, ‘130600’, ‘高碑店市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130700’, ‘130000’, ‘张家口市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130702’, ‘130700’, ‘桥东区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130703’, ‘130700’, ‘桥西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130705’, ‘130700’, ‘宣化区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130706’, ‘130700’, ‘下花园区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130708’, ‘130700’, ‘万全区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130709’, ‘130700’, ‘崇礼区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130722’, ‘130700’, ‘张北县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130723’, ‘130700’, ‘康保县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130724’, ‘130700’, ‘沽源县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130725’, ‘130700’, ‘尚义县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130726’, ‘130700’, ‘蔚县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130727’, ‘130700’, ‘阳原县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130728’, ‘130700’, ‘怀安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130730’, ‘130700’, ‘怀来县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130731’, ‘130700’, ‘涿鹿县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130732’, ‘130700’, ‘赤城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130800’, ‘130000’, ‘承德市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130802’, ‘130800’, ‘双桥区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130803’, ‘130800’, ‘双滦区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130804’, ‘130800’, ‘鹰手营子矿区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130821’, ‘130800’, ‘承德县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130822’, ‘130800’, ‘兴隆县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130824’, ‘130800’, ‘滦平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130825’, ‘130800’, ‘隆化县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130826’, ‘130800’, ‘丰宁满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130827’, ‘130800’, ‘宽城满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130828’, ‘130800’, ‘围场满族蒙古族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130881’, ‘130800’, ‘平泉市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130900’, ‘130000’, ‘沧州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130902’, ‘130900’, ‘新华区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130903’, ‘130900’, ‘运河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘130921’, ‘130900’, ‘沧县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130922’, ‘130900’, ‘青县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130923’, ‘130900’, ‘东光县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130924’, ‘130900’, ‘海兴县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130925’, ‘130900’, ‘盐山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130926’, ‘130900’, ‘肃宁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130927’, ‘130900’, ‘南皮县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130928’, ‘130900’, ‘吴桥县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130929’, ‘130900’, ‘献县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130930’, ‘130900’, ‘孟村回族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘130981’, ‘130900’, ‘泊头市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130982’, ‘130900’, ‘任丘市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130983’, ‘130900’, ‘黄骅市’);
INSERT INTO 72crm_crm_area_two VALUES (‘130984’, ‘130900’, ‘河间市’);
INSERT INTO 72crm_crm_area_two VALUES (‘131000’, ‘130000’, ‘廊坊市’);
INSERT INTO 72crm_crm_area_two VALUES (‘131002’, ‘131000’, ‘安次区’);
INSERT INTO 72crm_crm_area_two VALUES (‘131003’, ‘131000’, ‘广阳区’);
INSERT INTO 72crm_crm_area_two VALUES (‘131022’, ‘131000’, ‘固安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131023’, ‘131000’, ‘永清县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131024’, ‘131000’, ‘香河县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131025’, ‘131000’, ‘大城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131026’, ‘131000’, ‘文安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131028’, ‘131000’, ‘大厂回族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131081’, ‘131000’, ‘霸州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘131082’, ‘131000’, ‘三河市’);
INSERT INTO 72crm_crm_area_two VALUES (‘131100’, ‘130000’, ‘衡水市’);
INSERT INTO 72crm_crm_area_two VALUES (‘131102’, ‘131100’, ‘桃城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘131103’, ‘131100’, ‘冀州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘131121’, ‘131100’, ‘枣强县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131122’, ‘131100’, ‘武邑县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131123’, ‘131100’, ‘武强县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131124’, ‘131100’, ‘饶阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131125’, ‘131100’, ‘安平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131126’, ‘131100’, ‘故城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131127’, ‘131100’, ‘景县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131128’, ‘131100’, ‘阜城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘131182’, ‘131100’, ‘深州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140000’, ‘0’, ‘山西省’);
INSERT INTO 72crm_crm_area_two VALUES (‘140100’, ‘140000’, ‘太原市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140105’, ‘140100’, ‘小店区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140106’, ‘140100’, ‘迎泽区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140107’, ‘140100’, ‘杏花岭区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140108’, ‘140100’, ‘尖草坪区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140109’, ‘140100’, ‘万柏林区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140110’, ‘140100’, ‘晋源区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140121’, ‘140100’, ‘清徐县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140122’, ‘140100’, ‘阳曲县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140123’, ‘140100’, ‘娄烦县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140181’, ‘140100’, ‘古交市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140200’, ‘140000’, ‘大同市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140212’, ‘140200’, ‘新荣区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140213’, ‘140200’, ‘平城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140214’, ‘140200’, ‘云冈区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140215’, ‘140200’, ‘云州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140221’, ‘140200’, ‘阳高县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140222’, ‘140200’, ‘天镇县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140223’, ‘140200’, ‘广灵县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140224’, ‘140200’, ‘灵丘县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140225’, ‘140200’, ‘浑源县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140226’, ‘140200’, ‘左云县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140300’, ‘140000’, ‘阳泉市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140302’, ‘140300’, ‘城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140303’, ‘140300’, ‘矿区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140311’, ‘140300’, ‘郊区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140321’, ‘140300’, ‘平定县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140322’, ‘140300’, ‘盂县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140400’, ‘140000’, ‘长治市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140403’, ‘140400’, ‘潞州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140404’, ‘140400’, ‘上党区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140405’, ‘140400’, ‘屯留区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140406’, ‘140400’, ‘潞城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140423’, ‘140400’, ‘襄垣县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140425’, ‘140400’, ‘平顺县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140426’, ‘140400’, ‘黎城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140427’, ‘140400’, ‘壶关县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140428’, ‘140400’, ‘长子县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140429’, ‘140400’, ‘武乡县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140430’, ‘140400’, ‘沁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140431’, ‘140400’, ‘沁源县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140500’, ‘140000’, ‘晋城市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140502’, ‘140500’, ‘城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140521’, ‘140500’, ‘沁水县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140522’, ‘140500’, ‘阳城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140524’, ‘140500’, ‘陵川县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140525’, ‘140500’, ‘泽州县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140581’, ‘140500’, ‘高平市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140600’, ‘140000’, ‘朔州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140602’, ‘140600’, ‘朔城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140603’, ‘140600’, ‘平鲁区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140621’, ‘140600’, ‘山阴县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140622’, ‘140600’, ‘应县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140623’, ‘140600’, ‘右玉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140681’, ‘140600’, ‘怀仁市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140700’, ‘140000’, ‘晋中市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140702’, ‘140700’, ‘榆次区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140703’, ‘140700’, ‘太谷区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140721’, ‘140700’, ‘榆社县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140722’, ‘140700’, ‘左权县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140723’, ‘140700’, ‘和顺县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140724’, ‘140700’, ‘昔阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140725’, ‘140700’, ‘寿阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140727’, ‘140700’, ‘祁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140728’, ‘140700’, ‘平遥县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140729’, ‘140700’, ‘灵石县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140781’, ‘140700’, ‘介休市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140800’, ‘140000’, ‘运城市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140802’, ‘140800’, ‘盐湖区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140821’, ‘140800’, ‘临猗县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140822’, ‘140800’, ‘万荣县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140823’, ‘140800’, ‘闻喜县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140824’, ‘140800’, ‘稷山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140825’, ‘140800’, ‘新绛县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140826’, ‘140800’, ‘绛县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140827’, ‘140800’, ‘垣曲县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140828’, ‘140800’, ‘夏县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140829’, ‘140800’, ‘平陆县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140830’, ‘140800’, ‘芮城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140881’, ‘140800’, ‘永济市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140882’, ‘140800’, ‘河津市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140900’, ‘140000’, ‘忻州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘140902’, ‘140900’, ‘忻府区’);
INSERT INTO 72crm_crm_area_two VALUES (‘140921’, ‘140900’, ‘定襄县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140922’, ‘140900’, ‘五台县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140923’, ‘140900’, ‘代县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140924’, ‘140900’, ‘繁峙县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140925’, ‘140900’, ‘宁武县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140926’, ‘140900’, ‘静乐县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140927’, ‘140900’, ‘神池县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140928’, ‘140900’, ‘五寨县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140929’, ‘140900’, ‘岢岚县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140930’, ‘140900’, ‘河曲县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140931’, ‘140900’, ‘保德县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140932’, ‘140900’, ‘偏关县’);
INSERT INTO 72crm_crm_area_two VALUES (‘140981’, ‘140900’, ‘原平市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141000’, ‘140000’, ‘临汾市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141002’, ‘141000’, ‘尧都区’);
INSERT INTO 72crm_crm_area_two VALUES (‘141021’, ‘141000’, ‘曲沃县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141022’, ‘141000’, ‘翼城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141023’, ‘141000’, ‘襄汾县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141024’, ‘141000’, ‘洪洞县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141025’, ‘141000’, ‘古县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141026’, ‘141000’, ‘安泽县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141027’, ‘141000’, ‘浮山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141028’, ‘141000’, ‘吉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141029’, ‘141000’, ‘乡宁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141030’, ‘141000’, ‘大宁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141031’, ‘141000’, ‘隰县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141032’, ‘141000’, ‘永和县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141033’, ‘141000’, ‘蒲县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141034’, ‘141000’, ‘汾西县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141081’, ‘141000’, ‘侯马市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141082’, ‘141000’, ‘霍州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141100’, ‘140000’, ‘吕梁市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141102’, ‘141100’, ‘离石区’);
INSERT INTO 72crm_crm_area_two VALUES (‘141121’, ‘141100’, ‘文水县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141122’, ‘141100’, ‘交城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141123’, ‘141100’, ‘兴县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141124’, ‘141100’, ‘临县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141125’, ‘141100’, ‘柳林县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141126’, ‘141100’, ‘石楼县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141127’, ‘141100’, ‘岚县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141128’, ‘141100’, ‘方山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141129’, ‘141100’, ‘中阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141130’, ‘141100’, ‘交口县’);
INSERT INTO 72crm_crm_area_two VALUES (‘141181’, ‘141100’, ‘孝义市’);
INSERT INTO 72crm_crm_area_two VALUES (‘141182’, ‘141100’, ‘汾阳市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150000’, ‘0’, ‘内蒙古自治区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150100’, ‘150000’, ‘呼和浩特市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150102’, ‘150100’, ‘新城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150103’, ‘150100’, ‘回民区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150104’, ‘150100’, ‘玉泉区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150105’, ‘150100’, ‘赛罕区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150121’, ‘150100’, ‘土默特左旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150122’, ‘150100’, ‘托克托县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150123’, ‘150100’, ‘和林格尔县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150124’, ‘150100’, ‘清水河县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150125’, ‘150100’, ‘武川县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150200’, ‘150000’, ‘包头市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150202’, ‘150200’, ‘东河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150203’, ‘150200’, ‘昆都仑区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150204’, ‘150200’, ‘青山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150205’, ‘150200’, ‘石拐区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150206’, ‘150200’, ‘白云鄂博矿区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150207’, ‘150200’, ‘九原区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150221’, ‘150200’, ‘土默特右旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150222’, ‘150200’, ‘固阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150223’, ‘150200’, ‘达尔罕茂明安联合旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150300’, ‘150000’, ‘乌海市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150302’, ‘150300’, ‘海勃湾区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150303’, ‘150300’, ‘海南区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150304’, ‘150300’, ‘乌达区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150400’, ‘150000’, ‘赤峰市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150402’, ‘150400’, ‘红山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150403’, ‘150400’, ‘元宝山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150404’, ‘150400’, ‘松山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150421’, ‘150400’, ‘阿鲁科尔沁旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150422’, ‘150400’, ‘巴林左旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150423’, ‘150400’, ‘巴林右旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150424’, ‘150400’, ‘林西县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150425’, ‘150400’, ‘克什克腾旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150426’, ‘150400’, ‘翁牛特旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150428’, ‘150400’, ‘喀喇沁旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150429’, ‘150400’, ‘宁城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150430’, ‘150400’, ‘敖汉旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150500’, ‘150000’, ‘通辽市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150502’, ‘150500’, ‘科尔沁区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150521’, ‘150500’, ‘科尔沁左翼中旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150522’, ‘150500’, ‘科尔沁左翼后旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150523’, ‘150500’, ‘开鲁县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150524’, ‘150500’, ‘库伦旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150525’, ‘150500’, ‘奈曼旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150526’, ‘150500’, ‘扎鲁特旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150581’, ‘150500’, ‘霍林郭勒市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150600’, ‘150000’, ‘鄂尔多斯市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150602’, ‘150600’, ‘东胜区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150603’, ‘150600’, ‘康巴什区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150621’, ‘150600’, ‘达拉特旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150622’, ‘150600’, ‘准格尔旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150623’, ‘150600’, ‘鄂托克前旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150624’, ‘150600’, ‘鄂托克旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150625’, ‘150600’, ‘杭锦旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150626’, ‘150600’, ‘乌审旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150627’, ‘150600’, ‘伊金霍洛旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150700’, ‘150000’, ‘呼伦贝尔市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150702’, ‘150700’, ‘海拉尔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150703’, ‘150700’, ‘扎赉诺尔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150721’, ‘150700’, ‘阿荣旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150722’, ‘150700’, ‘莫力达瓦达斡尔族自治旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150723’, ‘150700’, ‘鄂伦春自治旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150724’, ‘150700’, ‘鄂温克族自治旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150725’, ‘150700’, ‘陈巴尔虎旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150726’, ‘150700’, ‘新巴尔虎左旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150727’, ‘150700’, ‘新巴尔虎右旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150781’, ‘150700’, ‘满洲里市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150782’, ‘150700’, ‘牙克石市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150783’, ‘150700’, ‘扎兰屯市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150784’, ‘150700’, ‘额尔古纳市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150785’, ‘150700’, ‘根河市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150800’, ‘150000’, ‘巴彦淖尔市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150802’, ‘150800’, ‘临河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150821’, ‘150800’, ‘五原县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150822’, ‘150800’, ‘磴口县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150823’, ‘150800’, ‘乌拉特前旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150824’, ‘150800’, ‘乌拉特中旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150825’, ‘150800’, ‘乌拉特后旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150826’, ‘150800’, ‘杭锦后旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150900’, ‘150000’, ‘乌兰察布市’);
INSERT INTO 72crm_crm_area_two VALUES (‘150902’, ‘150900’, ‘集宁区’);
INSERT INTO 72crm_crm_area_two VALUES (‘150921’, ‘150900’, ‘卓资县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150922’, ‘150900’, ‘化德县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150923’, ‘150900’, ‘商都县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150924’, ‘150900’, ‘兴和县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150925’, ‘150900’, ‘凉城县’);
INSERT INTO 72crm_crm_area_two VALUES (‘150926’, ‘150900’, ‘察哈尔右翼前旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150927’, ‘150900’, ‘察哈尔右翼中旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150928’, ‘150900’, ‘察哈尔右翼后旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150929’, ‘150900’, ‘四子王旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘150981’, ‘150900’, ‘丰镇市’);
INSERT INTO 72crm_crm_area_two VALUES (‘152200’, ‘150000’, ‘兴安盟’);
INSERT INTO 72crm_crm_area_two VALUES (‘152201’, ‘152200’, ‘乌兰浩特市’);
INSERT INTO 72crm_crm_area_two VALUES (‘152202’, ‘152200’, ‘阿尔山市’);
INSERT INTO 72crm_crm_area_two VALUES (‘152221’, ‘152200’, ‘科尔沁右翼前旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152222’, ‘152200’, ‘科尔沁右翼中旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152223’, ‘152200’, ‘扎赉特旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152224’, ‘152200’, ‘突泉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘152500’, ‘150000’, ‘锡林郭勒盟’);
INSERT INTO 72crm_crm_area_two VALUES (‘152501’, ‘152500’, ‘二连浩特市’);
INSERT INTO 72crm_crm_area_two VALUES (‘152502’, ‘152500’, ‘锡林浩特市’);
INSERT INTO 72crm_crm_area_two VALUES (‘152522’, ‘152500’, ‘阿巴嘎旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152523’, ‘152500’, ‘苏尼特左旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152524’, ‘152500’, ‘苏尼特右旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152525’, ‘152500’, ‘东乌珠穆沁旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152526’, ‘152500’, ‘西乌珠穆沁旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152527’, ‘152500’, ‘太仆寺旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152528’, ‘152500’, ‘镶黄旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152529’, ‘152500’, ‘正镶白旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152530’, ‘152500’, ‘正蓝旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152531’, ‘152500’, ‘多伦县’);
INSERT INTO 72crm_crm_area_two VALUES (‘152900’, ‘150000’, ‘阿拉善盟’);
INSERT INTO 72crm_crm_area_two VALUES (‘152921’, ‘152900’, ‘阿拉善左旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152922’, ‘152900’, ‘阿拉善右旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘152923’, ‘152900’, ‘额济纳旗’);
INSERT INTO 72crm_crm_area_two VALUES (‘210000’, ‘0’, ‘辽宁省’);
INSERT INTO 72crm_crm_area_two VALUES (‘210100’, ‘210000’, ‘沈阳市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210102’, ‘210100’, ‘和平区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210103’, ‘210100’, ‘沈河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210104’, ‘210100’, ‘大东区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210105’, ‘210100’, ‘皇姑区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210106’, ‘210100’, ‘铁西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210111’, ‘210100’, ‘苏家屯区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210112’, ‘210100’, ‘浑南区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210113’, ‘210100’, ‘沈北新区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210114’, ‘210100’, ‘于洪区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210115’, ‘210100’, ‘辽中区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210123’, ‘210100’, ‘康平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210124’, ‘210100’, ‘法库县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210181’, ‘210100’, ‘新民市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210200’, ‘210000’, ‘大连市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210202’, ‘210200’, ‘中山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210203’, ‘210200’, ‘西岗区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210204’, ‘210200’, ‘沙河口区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210211’, ‘210200’, ‘甘井子区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210212’, ‘210200’, ‘旅顺口区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210213’, ‘210200’, ‘金州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210214’, ‘210200’, ‘普兰店区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210224’, ‘210200’, ‘长海县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210281’, ‘210200’, ‘瓦房店市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210283’, ‘210200’, ‘庄河市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210300’, ‘210000’, ‘鞍山市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210302’, ‘210300’, ‘铁东区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210303’, ‘210300’, ‘铁西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210304’, ‘210300’, ‘立山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210311’, ‘210300’, ‘千山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210321’, ‘210300’, ‘台安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210323’, ‘210300’, ‘岫岩满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210381’, ‘210300’, ‘海城市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210400’, ‘210000’, ‘抚顺市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210402’, ‘210400’, ‘新抚区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210403’, ‘210400’, ‘东洲区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210404’, ‘210400’, ‘望花区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210411’, ‘210400’, ‘顺城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210421’, ‘210400’, ‘抚顺县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210422’, ‘210400’, ‘新宾满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210423’, ‘210400’, ‘清原满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210500’, ‘210000’, ‘本溪市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210502’, ‘210500’, ‘平山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210503’, ‘210500’, ‘溪湖区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210504’, ‘210500’, ‘明山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210505’, ‘210500’, ‘南芬区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210521’, ‘210500’, ‘本溪满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210522’, ‘210500’, ‘桓仁满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210600’, ‘210000’, ‘丹东市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210602’, ‘210600’, ‘元宝区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210603’, ‘210600’, ‘振兴区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210604’, ‘210600’, ‘振安区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210624’, ‘210600’, ‘宽甸满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210681’, ‘210600’, ‘东港市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210682’, ‘210600’, ‘凤城市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210700’, ‘210000’, ‘锦州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210702’, ‘210700’, ‘古塔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210703’, ‘210700’, ‘凌河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210711’, ‘210700’, ‘太和区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210726’, ‘210700’, ‘黑山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210727’, ‘210700’, ‘义县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210781’, ‘210700’, ‘凌海市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210782’, ‘210700’, ‘北镇市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210800’, ‘210000’, ‘营口市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210802’, ‘210800’, ‘站前区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210803’, ‘210800’, ‘西市区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210804’, ‘210800’, ‘鲅鱼圈区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210811’, ‘210800’, ‘老边区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210881’, ‘210800’, ‘盖州市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210882’, ‘210800’, ‘大石桥市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210900’, ‘210000’, ‘阜新市’);
INSERT INTO 72crm_crm_area_two VALUES (‘210902’, ‘210900’, ‘海州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210903’, ‘210900’, ‘新邱区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210904’, ‘210900’, ‘太平区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210905’, ‘210900’, ‘清河门区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210911’, ‘210900’, ‘细河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘210921’, ‘210900’, ‘阜新蒙古族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘210922’, ‘210900’, ‘彰武县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211000’, ‘210000’, ‘辽阳市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211002’, ‘211000’, ‘白塔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211003’, ‘211000’, ‘文圣区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211004’, ‘211000’, ‘宏伟区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211005’, ‘211000’, ‘弓长岭区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211011’, ‘211000’, ‘太子河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211021’, ‘211000’, ‘辽阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211081’, ‘211000’, ‘灯塔市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211100’, ‘210000’, ‘盘锦市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211102’, ‘211100’, ‘双台子区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211103’, ‘211100’, ‘兴隆台区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211104’, ‘211100’, ‘大洼区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211122’, ‘211100’, ‘盘山县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211200’, ‘210000’, ‘铁岭市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211202’, ‘211200’, ‘银州区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211204’, ‘211200’, ‘清河区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211221’, ‘211200’, ‘铁岭县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211223’, ‘211200’, ‘西丰县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211224’, ‘211200’, ‘昌图县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211281’, ‘211200’, ‘调兵山市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211282’, ‘211200’, ‘开原市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211300’, ‘210000’, ‘朝阳市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211302’, ‘211300’, ‘双塔区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211303’, ‘211300’, ‘龙城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211321’, ‘211300’, ‘朝阳县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211322’, ‘211300’, ‘建平县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211324’, ‘211300’, ‘喀喇沁左翼蒙古族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211381’, ‘211300’, ‘北票市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211382’, ‘211300’, ‘凌源市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211400’, ‘210000’, ‘葫芦岛市’);
INSERT INTO 72crm_crm_area_two VALUES (‘211402’, ‘211400’, ‘连山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211403’, ‘211400’, ‘龙港区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211404’, ‘211400’, ‘南票区’);
INSERT INTO 72crm_crm_area_two VALUES (‘211421’, ‘211400’, ‘绥中县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211422’, ‘211400’, ‘建昌县’);
INSERT INTO 72crm_crm_area_two VALUES (‘211481’, ‘211400’, ‘兴城市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220000’, ‘0’, ‘吉林省’);
INSERT INTO 72crm_crm_area_two VALUES (‘220100’, ‘220000’, ‘长春市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220102’, ‘220100’, ‘南关区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220103’, ‘220100’, ‘宽城区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220104’, ‘220100’, ‘朝阳区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220105’, ‘220100’, ‘二道区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220106’, ‘220100’, ‘绿园区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220112’, ‘220100’, ‘双阳区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220113’, ‘220100’, ‘九台区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220122’, ‘220100’, ‘农安县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220182’, ‘220100’, ‘榆树市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220183’, ‘220100’, ‘德惠市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220184’, ‘220100’, ‘公主岭市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220200’, ‘220000’, ‘吉林市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220202’, ‘220200’, ‘昌邑区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220203’, ‘220200’, ‘龙潭区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220204’, ‘220200’, ‘船营区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220211’, ‘220200’, ‘丰满区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220221’, ‘220200’, ‘永吉县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220281’, ‘220200’, ‘蛟河市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220282’, ‘220200’, ‘桦甸市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220283’, ‘220200’, ‘舒兰市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220284’, ‘220200’, ‘磐石市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220300’, ‘220000’, ‘四平市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220302’, ‘220300’, ‘铁西区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220303’, ‘220300’, ‘铁东区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220322’, ‘220300’, ‘梨树县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220323’, ‘220300’, ‘伊通满族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220382’, ‘220300’, ‘双辽市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220400’, ‘220000’, ‘辽源市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220402’, ‘220400’, ‘龙山区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220403’, ‘220400’, ‘西安区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220421’, ‘220400’, ‘东丰县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220422’, ‘220400’, ‘东辽县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220500’, ‘220000’, ‘通化市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220502’, ‘220500’, ‘东昌区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220503’, ‘220500’, ‘二道江区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220521’, ‘220500’, ‘通化县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220523’, ‘220500’, ‘辉南县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220524’, ‘220500’, ‘柳河县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220581’, ‘220500’, ‘梅河口市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220582’, ‘220500’, ‘集安市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220600’, ‘220000’, ‘白山市’);
INSERT INTO 72crm_crm_area_two VALUES (‘220602’, ‘220600’, ‘浑江区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220605’, ‘220600’, ‘江源区’);
INSERT INTO 72crm_crm_area_two VALUES (‘220621’, ‘220600’, ‘抚松县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220622’, ‘220600’, ‘靖宇县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220623’, ‘220600’, ‘长白朝鲜族自治县’);
INSERT INTO 72crm_crm_area_two VALUES (‘220681’, ‘220600’, ‘临江市’);
INSERT INTO 72crm_crm_area_two

原文：https://blog.csdn.net/yuanpeij/article/details/122456327

ERP

联系站长

QQ：769220720

省市区SQL

免费ERP

最新

最热

ERP

联系站长