zl程序教程

您现在的位置是:首页 >  数据库

当前栏目

城市区号表sql

SQL 城市
2023-09-11 14:22:42 时间

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dc_citycode
-- ----------------------------
DROP TABLE IF EXISTS `dc_citycode`;
CREATE TABLE `dc_citycode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '城市',
  `citycode` varchar(20) CHARACTER SET utf8 DEFAULT NULL COMMENT '城市区号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of dc_citycode
-- ----------------------------
INSERT INTO `dc_citycode` VALUES ('1', '北京', '010');
INSERT INTO `dc_citycode` VALUES ('2', '鄂州', '0711');
INSERT INTO `dc_citycode` VALUES ('3', '恩施', '0718');
INSERT INTO `dc_citycode` VALUES ('4', '黄冈', '0713');
INSERT INTO `dc_citycode` VALUES ('5', '黄石', '0714');
INSERT INTO `dc_citycode` VALUES ('6', '荆门', '0724');
INSERT INTO `dc_citycode` VALUES ('7', '荆州', '0716');
INSERT INTO `dc_citycode` VALUES ('8', '十堰', '0719');
INSERT INTO `dc_citycode` VALUES ('9', '随州', '0722');
INSERT INTO `dc_citycode` VALUES ('10', '武汉', '027');
INSERT INTO `dc_citycode` VALUES ('11', '咸宁', '0715');
INSERT INTO `dc_citycode` VALUES ('12', '襄樊', '0710');
INSERT INTO `dc_citycode` VALUES ('13', '孝感', '0712');
INSERT INTO `dc_citycode` VALUES ('14', '宜昌', '0717');
INSERT INTO `dc_citycode` VALUES ('15', '潮州', '0768');
INSERT INTO `dc_citycode` VALUES ('16', '东莞', '0769');
INSERT INTO `dc_citycode` VALUES ('17', '佛山', '0757');
INSERT INTO `dc_citycode` VALUES ('18', '广州', '020');
INSERT INTO `dc_citycode` VALUES ('19', '河源', '0762');
INSERT INTO `dc_citycode` VALUES ('20', '惠州', '0752');
INSERT INTO `dc_citycode` VALUES ('21', '江门', '0750');
INSERT INTO `dc_citycode` VALUES ('22', '揭阳', '0663');
INSERT INTO `dc_citycode` VALUES ('23', '茂名', '0668');
INSERT INTO `dc_citycode` VALUES ('24', '梅州', '0753');
INSERT INTO `dc_citycode` VALUES ('25', '清远', '0763');
INSERT INTO `dc_citycode` VALUES ('26', '汕头', '0754');
INSERT INTO `dc_citycode` VALUES ('27', '汕尾', '0660');
INSERT INTO `dc_citycode` VALUES ('28', '韶关', '0751');
INSERT INTO `dc_citycode` VALUES ('29', '阳江', '0662');
INSERT INTO `dc_citycode` VALUES ('30', '云浮', '0766');
INSERT INTO `dc_citycode` VALUES ('31', '湛江', '0759');
INSERT INTO `dc_citycode` VALUES ('32', '肇庆', '0758');
INSERT INTO `dc_citycode` VALUES ('33', '中山', '0760');
INSERT INTO `dc_citycode` VALUES ('34', '珠海', '0756');
INSERT INTO `dc_citycode` VALUES ('35', '上海', '021');
INSERT INTO `dc_citycode` VALUES ('36', '巴中 ', '0827');
INSERT INTO `dc_citycode` VALUES ('37', '成都', '028');
INSERT INTO `dc_citycode` VALUES ('38', '成都郊县', '');
INSERT INTO `dc_citycode` VALUES ('39', '达州', '0818');
INSERT INTO `dc_citycode` VALUES ('40', '德阳', '0838');
INSERT INTO `dc_citycode` VALUES ('41', '甘孜', '0836');
INSERT INTO `dc_citycode` VALUES ('42', '广安', '0826');
INSERT INTO `dc_citycode` VALUES ('43', '广元', '0839');
INSERT INTO `dc_citycode` VALUES ('44', '乐山', '0833');
INSERT INTO `dc_citycode` VALUES ('45', '凉山', '0834');
INSERT INTO `dc_citycode` VALUES ('46', '泸州', '0830');
INSERT INTO `dc_citycode` VALUES ('47', '眉山', '0833');
INSERT INTO `dc_citycode` VALUES ('48', '绵阳', '0816');
INSERT INTO `dc_citycode` VALUES ('49', '内江', '0832');
INSERT INTO `dc_citycode` VALUES ('50', '南充', '0817');
INSERT INTO `dc_citycode` VALUES ('51', '攀枝花', '0812');
INSERT INTO `dc_citycode` VALUES ('52', '遂宁', '0825');
INSERT INTO `dc_citycode` VALUES ('53', '雅安', '0835');
INSERT INTO `dc_citycode` VALUES ('54', '宜宾', '0831');
INSERT INTO `dc_citycode` VALUES ('55', '资阳', '0832');
INSERT INTO `dc_citycode` VALUES ('56', '自贡', '0813');
INSERT INTO `dc_citycode` VALUES ('57', '鞍山', '0412');
INSERT INTO `dc_citycode` VALUES ('58', '本溪', '0414');
INSERT INTO `dc_citycode` VALUES ('59', '朝阳', '0421');
INSERT INTO `dc_citycode` VALUES ('60', '丹东', '0415');
INSERT INTO `dc_citycode` VALUES ('61', '抚顺', '0413');
INSERT INTO `dc_citycode` VALUES ('62', '阜新', '0418');
INSERT INTO `dc_citycode` VALUES ('63', '葫芦岛', '0429');
INSERT INTO `dc_citycode` VALUES ('64', '锦州', '0416');
INSERT INTO `dc_citycode` VALUES ('65', '辽阳', '0419');
INSERT INTO `dc_citycode` VALUES ('66', '盘锦', '0427');
INSERT INTO `dc_citycode` VALUES ('67', '沈阳', '024');
INSERT INTO `dc_citycode` VALUES ('68', '铁岭', '0410');
INSERT INTO `dc_citycode` VALUES ('69', '营口', '0417');
INSERT INTO `dc_citycode` VALUES ('70', '安康', '0915');
INSERT INTO `dc_citycode` VALUES ('71', '宝鸡', '0917');
INSERT INTO `dc_citycode` VALUES ('72', '汉中', '0916');
INSERT INTO `dc_citycode` VALUES ('73', '商洛', '0914');
INSERT INTO `dc_citycode` VALUES ('74', '铜川', '0929');
INSERT INTO `dc_citycode` VALUES ('75', '渭南', '0913');
INSERT INTO `dc_citycode` VALUES ('76', '西安', '029');
INSERT INTO `dc_citycode` VALUES ('77', '咸阳', '0910');
INSERT INTO `dc_citycode` VALUES ('78', '延安', '0911');
INSERT INTO `dc_citycode` VALUES ('79', '榆林', '0912');
INSERT INTO `dc_citycode` VALUES ('80', '海南', '0898');
INSERT INTO `dc_citycode` VALUES ('81', '常州', '0519');
INSERT INTO `dc_citycode` VALUES ('82', '淮安', '0517');
INSERT INTO `dc_citycode` VALUES ('83', '连云港', '0518');
INSERT INTO `dc_citycode` VALUES ('84', '南京', '025');
INSERT INTO `dc_citycode` VALUES ('85', '南通', '0513');
INSERT INTO `dc_citycode` VALUES ('86', '苏州', '0512');
INSERT INTO `dc_citycode` VALUES ('87', '宿迁', '0527');
INSERT INTO `dc_citycode` VALUES ('88', '泰州', '0523');
INSERT INTO `dc_citycode` VALUES ('89', '无锡', '0510');
INSERT INTO `dc_citycode` VALUES ('90', '徐州', '0516');
INSERT INTO `dc_citycode` VALUES ('91', '盐城', '0515');
INSERT INTO `dc_citycode` VALUES ('92', '扬州', '0514');
INSERT INTO `dc_citycode` VALUES ('93', '镇江', '0511');
INSERT INTO `dc_citycode` VALUES ('94', '杭州', '0571');
INSERT INTO `dc_citycode` VALUES ('95', '湖州', '0572');
INSERT INTO `dc_citycode` VALUES ('96', '嘉兴', '0573');
INSERT INTO `dc_citycode` VALUES ('97', '金华', '0579');
INSERT INTO `dc_citycode` VALUES ('98', '丽水', '0578');
INSERT INTO `dc_citycode` VALUES ('99', '衢州', '0570');
INSERT INTO `dc_citycode` VALUES ('100', '绍兴', '0575');
INSERT INTO `dc_citycode` VALUES ('101', '台州', '0576');
INSERT INTO `dc_citycode` VALUES ('102', '温州', '0577');
INSERT INTO `dc_citycode` VALUES ('103', '舟山', '0580');
INSERT INTO `dc_citycode` VALUES ('104', '滨州', '0543');
INSERT INTO `dc_citycode` VALUES ('105', '德州', '0534');
INSERT INTO `dc_citycode` VALUES ('106', '东营', '0546');
INSERT INTO `dc_citycode` VALUES ('107', '菏泽', '0530');
INSERT INTO `dc_citycode` VALUES ('108', '济南', '0531');
INSERT INTO `dc_citycode` VALUES ('109', '济宁', '0537');
INSERT INTO `dc_citycode` VALUES ('110', '莱芜', '0634');
INSERT INTO `dc_citycode` VALUES ('111', '聊城', '0635');
INSERT INTO `dc_citycode` VALUES ('112', '临沂(yi)', '0539');
INSERT INTO `dc_citycode` VALUES ('113', '日照', '0633');
INSERT INTO `dc_citycode` VALUES ('114', '泰安', '0538');
INSERT INTO `dc_citycode` VALUES ('115', '威海', '0631');
INSERT INTO `dc_citycode` VALUES ('116', '潍坊', '0536');
INSERT INTO `dc_citycode` VALUES ('117', '烟台', '0535');
INSERT INTO `dc_citycode` VALUES ('118', '枣庄', '0632');
INSERT INTO `dc_citycode` VALUES ('119', '淄博', '0533');
INSERT INTO `dc_citycode` VALUES ('120', '安阳', '0372');
INSERT INTO `dc_citycode` VALUES ('121', '鹤壁', '0392');
INSERT INTO `dc_citycode` VALUES ('122', '济源', '0391');
INSERT INTO `dc_citycode` VALUES ('123', '焦作', '0391');
INSERT INTO `dc_citycode` VALUES ('124', '开封', '0378');
INSERT INTO `dc_citycode` VALUES ('125', '洛阳', '0379');
INSERT INTO `dc_citycode` VALUES ('126', '漯河', '0395');
INSERT INTO `dc_citycode` VALUES ('127', '南阳', '0377');
INSERT INTO `dc_citycode` VALUES ('128', '平顶山', '0375');
INSERT INTO `dc_citycode` VALUES ('129', '濮阳', '0393');
INSERT INTO `dc_citycode` VALUES ('130', '三门峡', '0398');
INSERT INTO `dc_citycode` VALUES ('131', '商丘', '0370');
INSERT INTO `dc_citycode` VALUES ('132', '新乡', '0373');
INSERT INTO `dc_citycode` VALUES ('133', '信阳', '0376');
INSERT INTO `dc_citycode` VALUES ('134', '许昌', '0374');
INSERT INTO `dc_citycode` VALUES ('135', '郑州', '0371');
INSERT INTO `dc_citycode` VALUES ('136', '周口', '0394');
INSERT INTO `dc_citycode` VALUES ('137', '驻马店', '0396');
INSERT INTO `dc_citycode` VALUES ('138', '天津', '022');
INSERT INTO `dc_citycode` VALUES ('139', '重庆', '023');
INSERT INTO `dc_citycode` VALUES ('140', '福州', '0591');
INSERT INTO `dc_citycode` VALUES ('141', '龙岩', '0597');
INSERT INTO `dc_citycode` VALUES ('142', '南平', '0599');
INSERT INTO `dc_citycode` VALUES ('143', '宁德', '0593');
INSERT INTO `dc_citycode` VALUES ('144', '莆田', '0594');
INSERT INTO `dc_citycode` VALUES ('145', '泉州', '0595');
INSERT INTO `dc_citycode` VALUES ('146', '三明', '0598');
INSERT INTO `dc_citycode` VALUES ('147', '厦门', '0592');
INSERT INTO `dc_citycode` VALUES ('148', '漳州', '0596');
INSERT INTO `dc_citycode` VALUES ('149', '长沙', '0731');
INSERT INTO `dc_citycode` VALUES ('150', '常德', '0736');
INSERT INTO `dc_citycode` VALUES ('151', '郴州', '0735');
INSERT INTO `dc_citycode` VALUES ('152', '衡阳', '0734');
INSERT INTO `dc_citycode` VALUES ('153', '怀化', '0745');
INSERT INTO `dc_citycode` VALUES ('154', '吉首', '0743');
INSERT INTO `dc_citycode` VALUES ('155', '娄底', '0738');
INSERT INTO `dc_citycode` VALUES ('156', '邵阳', '0739');
INSERT INTO `dc_citycode` VALUES ('157', '湘潭', '0732');
INSERT INTO `dc_citycode` VALUES ('158', '益阳', '0737');
INSERT INTO `dc_citycode` VALUES ('159', '永州', '0746');
INSERT INTO `dc_citycode` VALUES ('160', '岳阳', '0730');
INSERT INTO `dc_citycode` VALUES ('161', '张家界', '0744');
INSERT INTO `dc_citycode` VALUES ('162', '株洲', '0733');
INSERT INTO `dc_citycode` VALUES ('163', '深圳', '0755');
INSERT INTO `dc_citycode` VALUES ('164', '安庆', '0556');
INSERT INTO `dc_citycode` VALUES ('165', '蚌埠', '0552');
INSERT INTO `dc_citycode` VALUES ('166', '巢湖', '0565');
INSERT INTO `dc_citycode` VALUES ('167', '池州', '0566');
INSERT INTO `dc_citycode` VALUES ('168', '滁州', '0550');
INSERT INTO `dc_citycode` VALUES ('169', '阜(fu)阳', '0558');
INSERT INTO `dc_citycode` VALUES ('170', '毫州', '0558');
INSERT INTO `dc_citycode` VALUES ('171', '合肥', '0551');
INSERT INTO `dc_citycode` VALUES ('172', '淮北', '0561');
INSERT INTO `dc_citycode` VALUES ('173', '淮南', '0554');
INSERT INTO `dc_citycode` VALUES ('174', '黄山', '0559');
INSERT INTO `dc_citycode` VALUES ('175', '六(lu)安', '0564');
INSERT INTO `dc_citycode` VALUES ('176', '马鞍山', '0555');
INSERT INTO `dc_citycode` VALUES ('177', '宿州', '0557');
INSERT INTO `dc_citycode` VALUES ('178', '铜陵', '0562');
INSERT INTO `dc_citycode` VALUES ('179', '芜湖', '0553');
INSERT INTO `dc_citycode` VALUES ('180', '宣城', '0563');
INSERT INTO `dc_citycode` VALUES ('181', '大连', '0411');
INSERT INTO `dc_citycode` VALUES ('182', '青岛', '0532');
INSERT INTO `dc_citycode` VALUES ('183', '宁波', '0574');
INSERT INTO `dc_citycode` VALUES ('184', '保定', '0312');
INSERT INTO `dc_citycode` VALUES ('185', '沧州', '0317');
INSERT INTO `dc_citycode` VALUES ('186', '承德', '0314');
INSERT INTO `dc_citycode` VALUES ('187', '邯郸', '0310');
INSERT INTO `dc_citycode` VALUES ('188', '衡水', '0318');
INSERT INTO `dc_citycode` VALUES ('189', '廊坊', '0316');
INSERT INTO `dc_citycode` VALUES ('190', '秦皇岛', '0335');
INSERT INTO `dc_citycode` VALUES ('191', '石家庄', '0311');
INSERT INTO `dc_citycode` VALUES ('192', '唐山', '0315');
INSERT INTO `dc_citycode` VALUES ('193', '邢台', '0319');
INSERT INTO `dc_citycode` VALUES ('194', '张家口', '0313');
INSERT INTO `dc_citycode` VALUES ('195', '大庆', '0459');
INSERT INTO `dc_citycode` VALUES ('196', '大兴安岭', '0457');
INSERT INTO `dc_citycode` VALUES ('197', '哈尔滨', '0451');
INSERT INTO `dc_citycode` VALUES ('198', '鹤岗', '0468');
INSERT INTO `dc_citycode` VALUES ('199', '黑河', '0456');
INSERT INTO `dc_citycode` VALUES ('200', '鸡西', '0467');
INSERT INTO `dc_citycode` VALUES ('201', '佳木斯', '0454');
INSERT INTO `dc_citycode` VALUES ('202', '牡丹江', '0453');
INSERT INTO `dc_citycode` VALUES ('203', '齐齐哈尔', '0452');
INSERT INTO `dc_citycode` VALUES ('204', '绥化', '0455');
INSERT INTO `dc_citycode` VALUES ('205', '伊春', '0458');
INSERT INTO `dc_citycode` VALUES ('206', '保山', '0875');
INSERT INTO `dc_citycode` VALUES ('207', '楚雄', '0878');
INSERT INTO `dc_citycode` VALUES ('208', '大理', '0872');
INSERT INTO `dc_citycode` VALUES ('209', '德宏', '0692');
INSERT INTO `dc_citycode` VALUES ('210', '红河', '0873');
INSERT INTO `dc_citycode` VALUES ('211', '景洪', '0691');
INSERT INTO `dc_citycode` VALUES ('212', '昆明', '0871');
INSERT INTO `dc_citycode` VALUES ('213', '丽江', '0888');
INSERT INTO `dc_citycode` VALUES ('214', '临沧', '0883');
INSERT INTO `dc_citycode` VALUES ('215', '曲靖', '0874');
INSERT INTO `dc_citycode` VALUES ('216', '思茅', '0879');
INSERT INTO `dc_citycode` VALUES ('217', '文山', '0876');
INSERT INTO `dc_citycode` VALUES ('218', '玉溪', '0877');
INSERT INTO `dc_citycode` VALUES ('219', '昭通', '0870');
INSERT INTO `dc_citycode` VALUES ('220', '白城', '0436');
INSERT INTO `dc_citycode` VALUES ('221', '长春', '0431');
INSERT INTO `dc_citycode` VALUES ('222', '吉林', '0432');
INSERT INTO `dc_citycode` VALUES ('223', '辽源', '0437');
INSERT INTO `dc_citycode` VALUES ('224', '四平', '0434');
INSERT INTO `dc_citycode` VALUES ('225', '松原', '0438');
INSERT INTO `dc_citycode` VALUES ('226', '通化', '0435');
INSERT INTO `dc_citycode` VALUES ('227', '延吉', '0433');
INSERT INTO `dc_citycode` VALUES ('228', '长治', '0355');
INSERT INTO `dc_citycode` VALUES ('229', '大同', '0352');
INSERT INTO `dc_citycode` VALUES ('230', '晋城', '0356');
INSERT INTO `dc_citycode` VALUES ('231', '晋中', '0354');
INSERT INTO `dc_citycode` VALUES ('232', '临汾', '0357');
INSERT INTO `dc_citycode` VALUES ('233', '吕梁', '0359');
INSERT INTO `dc_citycode` VALUES ('234', '朔州', '0349');
INSERT INTO `dc_citycode` VALUES ('235', '太原', '0351');
INSERT INTO `dc_citycode` VALUES ('236', '忻州', '0350');
INSERT INTO `dc_citycode` VALUES ('237', '阳泉', '0353');
INSERT INTO `dc_citycode` VALUES ('238', '运城', '0359');
INSERT INTO `dc_citycode` VALUES ('239', '阿克苏', '0997');
INSERT INTO `dc_citycode` VALUES ('240', '博州', '0909');
INSERT INTO `dc_citycode` VALUES ('241', '昌吉', '0994');
INSERT INTO `dc_citycode` VALUES ('242', '哈密', '0902');
INSERT INTO `dc_citycode` VALUES ('243', '喀什(kashi)', '0998');
INSERT INTO `dc_citycode` VALUES ('244', '克拉玛依', '0990');
INSERT INTO `dc_citycode` VALUES ('245', '库尔勒', '0996');
INSERT INTO `dc_citycode` VALUES ('246', '奎屯', '0992');
INSERT INTO `dc_citycode` VALUES ('247', '石河子', '0993');
INSERT INTO `dc_citycode` VALUES ('248', '塔城', '0901');
INSERT INTO `dc_citycode` VALUES ('249', '吐鲁番', '0995');
INSERT INTO `dc_citycode` VALUES ('250', '乌鲁木齐', '0991');
INSERT INTO `dc_citycode` VALUES ('251', '伊犁', '0999');
INSERT INTO `dc_citycode` VALUES ('252', '抚州', '0794');
INSERT INTO `dc_citycode` VALUES ('253', '赣gan州', '0797');
INSERT INTO `dc_citycode` VALUES ('254', '吉安', '0796');
INSERT INTO `dc_citycode` VALUES ('255', '景德镇', '0798');
INSERT INTO `dc_citycode` VALUES ('256', '九江', '0792');
INSERT INTO `dc_citycode` VALUES ('257', '南昌', '0791');
INSERT INTO `dc_citycode` VALUES ('258', '萍乡', '0799');
INSERT INTO `dc_citycode` VALUES ('259', '上饶', '0793');
INSERT INTO `dc_citycode` VALUES ('260', '新余', '0790');
INSERT INTO `dc_citycode` VALUES ('261', '宜春', '0795');
INSERT INTO `dc_citycode` VALUES ('262', '鹰潭', '0701');
INSERT INTO `dc_citycode` VALUES ('263', '百色', '0776');
INSERT INTO `dc_citycode` VALUES ('264', '北海', '0779');
INSERT INTO `dc_citycode` VALUES ('265', '桂林', '0773');
INSERT INTO `dc_citycode` VALUES ('266', '河池', '0778');
INSERT INTO `dc_citycode` VALUES ('267', '贺州', '0774');
INSERT INTO `dc_citycode` VALUES ('268', '来宾', '0772');
INSERT INTO `dc_citycode` VALUES ('269', '柳州', '0772');
INSERT INTO `dc_citycode` VALUES ('270', '南宁', '0771');
INSERT INTO `dc_citycode` VALUES ('271', '钦州', '0777');
INSERT INTO `dc_citycode` VALUES ('272', '梧州', '0774');
INSERT INTO `dc_citycode` VALUES ('273', '玉林', '0775');
INSERT INTO `dc_citycode` VALUES ('274', '巴彦淖尔', '0478');
INSERT INTO `dc_citycode` VALUES ('275', '包头', '0472');
INSERT INTO `dc_citycode` VALUES ('276', '赤峰', '0476');
INSERT INTO `dc_citycode` VALUES ('277', '鄂尔多斯', '0477');
INSERT INTO `dc_citycode` VALUES ('278', '呼和浩特', '0471');
INSERT INTO `dc_citycode` VALUES ('279', '呼伦贝尔', '0470');
INSERT INTO `dc_citycode` VALUES ('280', '通辽', '0475');
INSERT INTO `dc_citycode` VALUES ('281', '乌海', '0473');
INSERT INTO `dc_citycode` VALUES ('282', '乌兰察布', '0474');
INSERT INTO `dc_citycode` VALUES ('283', '锡林郭勒', '0479');
INSERT INTO `dc_citycode` VALUES ('284', '白银', '0943');
INSERT INTO `dc_citycode` VALUES ('285', '酒泉', '0937');
INSERT INTO `dc_citycode` VALUES ('286', '兰州', '0931');
INSERT INTO `dc_citycode` VALUES ('287', '天水', '0938');
INSERT INTO `dc_citycode` VALUES ('288', '武威', '0935');
INSERT INTO `dc_citycode` VALUES ('289', '张掖', '0936');
INSERT INTO `dc_citycode` VALUES ('290', '宁夏', '0951');
INSERT INTO `dc_citycode` VALUES ('291', '安顺', '0853');
INSERT INTO `dc_citycode` VALUES ('292', '毕节', '0857');
INSERT INTO `dc_citycode` VALUES ('293', '贵阳', '0851');
INSERT INTO `dc_citycode` VALUES ('294', '六盘水', '0858');
INSERT INTO `dc_citycode` VALUES ('295', '黔东南', '0855');
INSERT INTO `dc_citycode` VALUES ('296', '黔南', '0854');
INSERT INTO `dc_citycode` VALUES ('297', '黔西南(兴义)', '0859');
INSERT INTO `dc_citycode` VALUES ('298', '铜仁', '0856');
INSERT INTO `dc_citycode` VALUES ('299', '遵义', '0852');
INSERT INTO `dc_citycode` VALUES ('300', '青海', '0971');