中國城市區(qū)號 300個(gè)。


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;


DROP TABLE IF EXISTS `citycode`;
CREATE TABLE `citycode`  (
  `codeId` int(11) NOT NULL AUTO_INCREMENT,
  `company` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `city` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
  `citycode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市區(qū)號',
  PRIMARY KEY (`codeId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 512 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of citycode
-- ----------------------------
INSERT INTO `citycode` VALUES (1, '1', '北京', '010');
INSERT INTO `citycode` VALUES (2, '2', '鄂州', '0711');
INSERT INTO `citycode` VALUES (3, '2', '恩施', '0718');
INSERT INTO `citycode` VALUES (4, '2', '黃岡', '0713');
INSERT INTO `citycode` VALUES (5, '2', '黃石', '0714');
INSERT INTO `citycode` VALUES (6, '2', '荊門', '0724');
INSERT INTO `citycode` VALUES (7, '2', '荊州', '0716');
INSERT INTO `citycode` VALUES (8, '2', '十堰', '0719');
INSERT INTO `citycode` VALUES (9, '2', '隨州', '0722');
INSERT INTO `citycode` VALUES (10, '2', '武漢', '027');
INSERT INTO `citycode` VALUES (11, '2', '咸寧', '0715');
INSERT INTO `citycode` VALUES (12, '2', '襄樊', '0710');
INSERT INTO `citycode` VALUES (13, '2', '孝感', '0712');
INSERT INTO `citycode` VALUES (14, '2', '宜昌', '0717');
INSERT INTO `citycode` VALUES (15, '3', '潮州', '0768');
INSERT INTO `citycode` VALUES (16, '3', '東莞', '0769');
INSERT INTO `citycode` VALUES (17, '3', '佛山', '0757');
INSERT INTO `citycode` VALUES (18, '3', '廣州', '020');
INSERT INTO `citycode` VALUES (19, '3', '河源', '0762');
INSERT INTO `citycode` VALUES (20, '3', '惠州', '0752');
INSERT INTO `citycode` VALUES (21, '3', '江門', '0750');
INSERT INTO `citycode` VALUES (22, '3', '揭陽', '0663');
INSERT INTO `citycode` VALUES (23, '3', '茂名', '0668');
INSERT INTO `citycode` VALUES (24, '3', '梅州', '0753');
INSERT INTO `citycode` VALUES (25, '3', '清遠(yuǎn)', '0763');
INSERT INTO `citycode` VALUES (26, '3', '汕頭', '0754');
INSERT INTO `citycode` VALUES (27, '3', '汕尾', '0660');
INSERT INTO `citycode` VALUES (28, '3', '韶關(guān)', '0751');
INSERT INTO `citycode` VALUES (29, '3', '陽江', '0662');
INSERT INTO `citycode` VALUES (30, '3', '云浮', '0766');
INSERT INTO `citycode` VALUES (31, '3', '湛江', '0759');
INSERT INTO `citycode` VALUES (32, '3', '肇慶', '0758');
INSERT INTO `citycode` VALUES (33, '3', '中山', '0760');
INSERT INTO `citycode` VALUES (34, '3', '珠海', '0756');
INSERT INTO `citycode` VALUES (35, '4', '上海', '021');
INSERT INTO `citycode` VALUES (36, '5', '巴中 ', '0827');
INSERT INTO `citycode` VALUES (37, '5', '成都', '028');
INSERT INTO `citycode` VALUES (38, '5', '成都郊縣', '');
INSERT INTO `citycode` VALUES (39, '5', '達(dá)州', '0818');
INSERT INTO `citycode` VALUES (40, '5', '德陽', '0838');
INSERT INTO `citycode` VALUES (41, '5', '甘孜', '0836');
INSERT INTO `citycode` VALUES (42, '5', '廣安', '0826');
INSERT INTO `citycode` VALUES (43, '5', '廣元', '0839');
INSERT INTO `citycode` VALUES (44, '5', '樂山', '0833');
INSERT INTO `citycode` VALUES (45, '5', '涼山', '0834');
INSERT INTO `citycode` VALUES (46, '5', '瀘州', '0830');
INSERT INTO `citycode` VALUES (47, '5', '眉山', '0833');
INSERT INTO `citycode` VALUES (48, '5', '綿陽', '0816');
INSERT INTO `citycode` VALUES (49, '5', '內(nèi)江', '0832');
INSERT INTO `citycode` VALUES (50, '5', '南充', '0817');
INSERT INTO `citycode` VALUES (51, '5', '攀枝花', '0812');
INSERT INTO `citycode` VALUES (52, '5', '遂寧', '0825');
INSERT INTO `citycode` VALUES (53, '5', '雅安', '0835');
INSERT INTO `citycode` VALUES (54, '5', '宜賓', '0831');
INSERT INTO `citycode` VALUES (55, '5', '資陽', '0832');
INSERT INTO `citycode` VALUES (56, '5', '自貢', '0813');
INSERT INTO `citycode` VALUES (57, '6', '鞍山', '0412');
INSERT INTO `citycode` VALUES (58, '6', '本溪', '0414');
INSERT INTO `citycode` VALUES (59, '6', '朝陽', '0421');
INSERT INTO `citycode` VALUES (60, '6', '丹東', '0415');
INSERT INTO `citycode` VALUES (61, '6', '撫順', '0413');
INSERT INTO `citycode` VALUES (62, '6', '阜新', '0418');
INSERT INTO `citycode` VALUES (63, '6', '葫蘆島', '0429');
INSERT INTO `citycode` VALUES (64, '6', '錦州', '0416');
INSERT INTO `citycode` VALUES (65, '6', '遼陽', '0419');
INSERT INTO `citycode` VALUES (66, '6', '盤錦', '0427');
INSERT INTO `citycode` VALUES (67, '6', '沈陽', '024');
INSERT INTO `citycode` VALUES (68, '6', '鐵嶺', '0410');
INSERT INTO `citycode` VALUES (69, '6', '營口', '0417');
INSERT INTO `citycode` VALUES (70, '7', '安康', '0915');
INSERT INTO `citycode` VALUES (71, '7', '寶雞', '0917');
INSERT INTO `citycode` VALUES (72, '7', '漢中', '0916');
INSERT INTO `citycode` VALUES (73, '7', '商洛', '0914');
INSERT INTO `citycode` VALUES (74, '7', '銅川', '0929');
INSERT INTO `citycode` VALUES (75, '7', '渭南', '0913');
INSERT INTO `citycode` VALUES (76, '7', '西安', '029');
INSERT INTO `citycode` VALUES (77, '7', '咸陽', '0910');
INSERT INTO `citycode` VALUES (78, '7', '延安', '0911');
INSERT INTO `citycode` VALUES (79, '7', '榆林', '0912');
INSERT INTO `citycode` VALUES (80, '8', '海南', '0898');
INSERT INTO `citycode` VALUES (81, 'A', '常州', '0519');
INSERT INTO `citycode` VALUES (82, 'A', '淮安', '0517');
INSERT INTO `citycode` VALUES (83, 'A', '連云港', '0518');
INSERT INTO `citycode` VALUES (84, 'A', '南京', '025');
INSERT INTO `citycode` VALUES (85, 'A', '南通', '0513');
INSERT INTO `citycode` VALUES (86, 'A', '蘇州', '0512');
INSERT INTO `citycode` VALUES (87, 'A', '宿遷', '0527');
INSERT INTO `citycode` VALUES (88, 'A', '泰州', '0523');
INSERT INTO `citycode` VALUES (89, 'A', '無錫', '0510');
INSERT INTO `citycode` VALUES (90, 'A', '徐州', '0516');
INSERT INTO `citycode` VALUES (91, 'A', '鹽城', '0515');
INSERT INTO `citycode` VALUES (92, 'A', '揚(yáng)州', '0514');
INSERT INTO `citycode` VALUES (93, 'A', '鎮(zhèn)江', '0511');
INSERT INTO `citycode` VALUES (94, 'B', '杭州', '0571');
INSERT INTO `citycode` VALUES (95, 'B', '湖州', '0572');
INSERT INTO `citycode` VALUES (96, 'B', '嘉興', '0573');
INSERT INTO `citycode` VALUES (97, 'B', '金華', '0579');
INSERT INTO `citycode` VALUES (98, 'B', '麗水', '0578');
INSERT INTO `citycode` VALUES (99, 'B', '衢州', '0570');
INSERT INTO `citycode` VALUES (100, 'B', '紹興', '0575');
INSERT INTO `citycode` VALUES (101, 'B', '臺州', '0576');
INSERT INTO `citycode` VALUES (102, 'B', '溫州', '0577');
INSERT INTO `citycode` VALUES (103, 'B', '舟山', '0580');
INSERT INTO `citycode` VALUES (104, 'C', '濱州', '0543');
INSERT INTO `citycode` VALUES (105, 'C', '德州', '0534');
INSERT INTO `citycode` VALUES (106, 'C', '東營', '0546');
INSERT INTO `citycode` VALUES (107, 'C', '菏澤', '0530');
INSERT INTO `citycode` VALUES (108, 'C', '濟(jì)南', '0531');
INSERT INTO `citycode` VALUES (109, 'C', '濟(jì)寧', '0537');
INSERT INTO `citycode` VALUES (110, 'C', '萊蕪', '0634');
INSERT INTO `citycode` VALUES (111, 'C', '聊城', '0635');
INSERT INTO `citycode` VALUES (112, 'C', '臨沂（yi）', '0539');
INSERT INTO `citycode` VALUES (113, 'C', '日照', '0633');
INSERT INTO `citycode` VALUES (114, 'C', '泰安', '0538');
INSERT INTO `citycode` VALUES (115, 'C', '威海', '0631');
INSERT INTO `citycode` VALUES (116, 'C', '濰坊', '0536');
INSERT INTO `citycode` VALUES (117, 'C', '煙臺', '0535');
INSERT INTO `citycode` VALUES (118, 'C', '棗莊', '0632');
INSERT INTO `citycode` VALUES (119, 'C', '淄博', '0533');
INSERT INTO `citycode` VALUES (120, 'D', '安陽', '0372');
INSERT INTO `citycode` VALUES (121, 'D', '鶴壁', '0392');
INSERT INTO `citycode` VALUES (122, 'D', '濟(jì)源', '0391');
INSERT INTO `citycode` VALUES (123, 'D', '焦作', '0391');
INSERT INTO `citycode` VALUES (124, 'D', '開封', '0378');
INSERT INTO `citycode` VALUES (125, 'D', '洛陽', '0379');
INSERT INTO `citycode` VALUES (126, 'D', '漯河', '0395');
INSERT INTO `citycode` VALUES (127, 'D', '南陽', '0377');
INSERT INTO `citycode` VALUES (128, 'D', '平頂山', '0375');
INSERT INTO `citycode` VALUES (129, 'D', '濮陽', '0393');
INSERT INTO `citycode` VALUES (130, 'D', '三門峽', '0398');
INSERT INTO `citycode` VALUES (131, 'D', '商丘', '0370');
INSERT INTO `citycode` VALUES (132, 'D', '新鄉(xiāng)', '0373');
INSERT INTO `citycode` VALUES (133, 'D', '信陽', '0376');
INSERT INTO `citycode` VALUES (134, 'D', '許昌', '0374');
INSERT INTO `citycode` VALUES (135, 'D', '鄭州', '0371');
INSERT INTO `citycode` VALUES (136, 'D', '周口', '0394');
INSERT INTO `citycode` VALUES (137, 'D', '駐馬店', '0396');
INSERT INTO `citycode` VALUES (138, 'E', '天津', '022');
INSERT INTO `citycode` VALUES (139, 'F', '重慶', '023');
INSERT INTO `citycode` VALUES (140, 'G', '福州', '0591');
INSERT INTO `citycode` VALUES (141, 'G', '龍巖', '0597');
INSERT INTO `citycode` VALUES (142, 'G', '南平', '0599');
INSERT INTO `citycode` VALUES (143, 'G', '寧德', '0593');
INSERT INTO `citycode` VALUES (144, 'G', '莆田', '0594');
INSERT INTO `citycode` VALUES (145, 'G', '泉州', '0595');
INSERT INTO `citycode` VALUES (146, 'G', '三明', '0598');
INSERT INTO `citycode` VALUES (147, 'G', '廈門', '0592');
INSERT INTO `citycode` VALUES (148, 'G', '漳州', '0596');
INSERT INTO `citycode` VALUES (149, 'H', '長沙', '0731');
INSERT INTO `citycode` VALUES (150, 'H', '常德', '0736');
INSERT INTO `citycode` VALUES (151, 'H', '郴州', '0735');
INSERT INTO `citycode` VALUES (152, 'H', '衡陽', '0734');
INSERT INTO `citycode` VALUES (153, 'H', '懷化', '0745');
INSERT INTO `citycode` VALUES (154, 'H', '吉首', '0743');
INSERT INTO `citycode` VALUES (155, 'H', '婁底', '0738');
INSERT INTO `citycode` VALUES (156, 'H', '邵陽', '0739');
INSERT INTO `citycode` VALUES (157, 'H', '湘潭', '0732');
INSERT INTO `citycode` VALUES (158, 'H', '益陽', '0737');
INSERT INTO `citycode` VALUES (159, 'H', '永州', '0746');
INSERT INTO `citycode` VALUES (160, 'H', '岳陽', '0730');
INSERT INTO `citycode` VALUES (161, 'H', '張家界', '0744');
INSERT INTO `citycode` VALUES (162, 'H', '株洲', '0733');
INSERT INTO `citycode` VALUES (163, 'I', '深圳', '0755');
INSERT INTO `citycode` VALUES (164, 'J', '安慶', '0556');
INSERT INTO `citycode` VALUES (165, 'J', '蚌埠', '0552');
INSERT INTO `citycode` VALUES (166, 'J', '巢湖', '0565');
INSERT INTO `citycode` VALUES (167, 'J', '池州', '0566');
INSERT INTO `citycode` VALUES (168, 'J', '滁州', '0550');
INSERT INTO `citycode` VALUES (169, 'J', '阜（fu）陽', '0558');
INSERT INTO `citycode` VALUES (170, 'J', '毫州', '0558');
INSERT INTO `citycode` VALUES (171, 'J', '合肥', '0551');
INSERT INTO `citycode` VALUES (172, 'J', '淮北', '0561');
INSERT INTO `citycode` VALUES (173, 'J', '淮南', '0554');
INSERT INTO `citycode` VALUES (174, 'J', '黃山', '0559');
INSERT INTO `citycode` VALUES (175, 'J', '六（lu）安', '0564');
INSERT INTO `citycode` VALUES (176, 'J', '馬鞍山', '0555');
INSERT INTO `citycode` VALUES (177, 'J', '宿州', '0557');
INSERT INTO `citycode` VALUES (178, 'J', '銅陵', '0562');
INSERT INTO `citycode` VALUES (179, 'J', '蕪湖', '0553');
INSERT INTO `citycode` VALUES (180, 'J', '宣城', '0563');
INSERT INTO `citycode` VALUES (181, 'K', '大連', '0411');
INSERT INTO `citycode` VALUES (182, 'L', '青島', '0532');
INSERT INTO `citycode` VALUES (183, 'M', '寧波', '0574');
INSERT INTO `citycode` VALUES (184, 'N', '保定', '0312');
INSERT INTO `citycode` VALUES (185, 'N', '滄州', '0317');
INSERT INTO `citycode` VALUES (186, 'N', '承德', '0314');
INSERT INTO `citycode` VALUES (187, 'N', '邯鄲', '0310');
INSERT INTO `citycode` VALUES (188, 'N', '衡水', '0318');
INSERT INTO `citycode` VALUES (189, 'N', '廊坊', '0316');
INSERT INTO `citycode` VALUES (190, 'N', '秦皇島', '0335');
INSERT INTO `citycode` VALUES (191, 'N', '石家莊', '0311');
INSERT INTO `citycode` VALUES (192, 'N', '唐山', '0315');
INSERT INTO `citycode` VALUES (193, 'N', '邢臺', '0319');
INSERT INTO `citycode` VALUES (194, 'N', '張家口', '0313');
INSERT INTO `citycode` VALUES (195, 'O', '大慶', '0459');
INSERT INTO `citycode` VALUES (196, 'O', '大興安嶺', '0457');
INSERT INTO `citycode` VALUES (197, 'O', '哈爾濱', '0451');
INSERT INTO `citycode` VALUES (198, 'O', '鶴崗', '0468');
INSERT INTO `citycode` VALUES (199, 'O', '黑河', '0456');
INSERT INTO `citycode` VALUES (200, 'O', '雞西', '0467');
INSERT INTO `citycode` VALUES (201, 'O', '佳木斯', '0454');
INSERT INTO `citycode` VALUES (202, 'O', '牡丹江', '0453');
INSERT INTO `citycode` VALUES (203, 'O', '齊齊哈爾', '0452');
INSERT INTO `citycode` VALUES (204, 'O', '綏化', '0455');
INSERT INTO `citycode` VALUES (205, 'O', '伊春', '0458');
INSERT INTO `citycode` VALUES (206, 'P', '保山', '0875');
INSERT INTO `citycode` VALUES (207, 'P', '楚雄', '0878');
INSERT INTO `citycode` VALUES (208, 'P', '大理', '0872');
INSERT INTO `citycode` VALUES (209, 'P', '德宏', '0692');
INSERT INTO `citycode` VALUES (210, 'P', '紅河', '0873');
INSERT INTO `citycode` VALUES (211, 'P', '景洪', '0691');
INSERT INTO `citycode` VALUES (212, 'P', '昆明', '0871');
INSERT INTO `citycode` VALUES (213, 'P', '麗江', '0888');
INSERT INTO `citycode` VALUES (214, 'P', '臨滄', '0883');
INSERT INTO `citycode` VALUES (215, 'P', '曲靖', '0874');
INSERT INTO `citycode` VALUES (216, 'P', '思茅', '0879');
INSERT INTO `citycode` VALUES (217, 'P', '文山', '0876');
INSERT INTO `citycode` VALUES (218, 'P', '玉溪', '0877');
INSERT INTO `citycode` VALUES (219, 'P', '昭通', '0870');
INSERT INTO `citycode` VALUES (220, 'Q', '白城', '0436');
INSERT INTO `citycode` VALUES (221, 'Q', '長春', '0431');
INSERT INTO `citycode` VALUES (222, 'Q', '吉林', '0432');
INSERT INTO `citycode` VALUES (223, 'Q', '遼源', '0437');
INSERT INTO `citycode` VALUES (224, 'Q', '四平', '0434');
INSERT INTO `citycode` VALUES (225, 'Q', '松原', '0438');
INSERT INTO `citycode` VALUES (226, 'Q', '通化', '0435');
INSERT INTO `citycode` VALUES (227, 'Q', '延吉', '0433');
INSERT INTO `citycode` VALUES (228, 'R', '長治', '0355');
INSERT INTO `citycode` VALUES (229, 'R', '大同', '0352');
INSERT INTO `citycode` VALUES (230, 'R', '晉城', '0356');
INSERT INTO `citycode` VALUES (231, 'R', '晉中', '0354');
INSERT INTO `citycode` VALUES (232, 'R', '臨汾', '0357');
INSERT INTO `citycode` VALUES (233, 'R', '呂梁', '0359');
INSERT INTO `citycode` VALUES (234, 'R', '朔州', '0349');
INSERT INTO `citycode` VALUES (235, 'R', '太原', '0351');
INSERT INTO `citycode` VALUES (236, 'R', '忻州', '0350');
INSERT INTO `citycode` VALUES (237, 'R', '陽泉', '0353');
INSERT INTO `citycode` VALUES (238, 'R', '運(yùn)城', '0359');
INSERT INTO `citycode` VALUES (239, 'S', '阿克蘇', '0997');
INSERT INTO `citycode` VALUES (240, 'S', '博州', '0909');
INSERT INTO `citycode` VALUES (241, 'S', '昌吉', '0994');
INSERT INTO `citycode` VALUES (242, 'S', '哈密', '0902');
INSERT INTO `citycode` VALUES (243, 'S', '喀什（kashi）', '0998');
INSERT INTO `citycode` VALUES (244, 'S', '克拉瑪依', '0990');
INSERT INTO `citycode` VALUES (245, 'S', '庫爾勒', '0996');
INSERT INTO `citycode` VALUES (246, 'S', '奎屯', '0992');
INSERT INTO `citycode` VALUES (247, 'S', '石河子', '0993');
INSERT INTO `citycode` VALUES (248, 'S', '塔城', '0901');
INSERT INTO `citycode` VALUES (249, 'S', '吐魯番', '0995');
INSERT INTO `citycode` VALUES (250, 'S', '烏魯木齊', '0991');
INSERT INTO `citycode` VALUES (251, 'S', '伊犁', '0999');
INSERT INTO `citycode` VALUES (252, 'T', '撫州', '0794');
INSERT INTO `citycode` VALUES (253, 'T', '贛gan州', '0797');
INSERT INTO `citycode` VALUES (254, 'T', '吉安', '0796');
INSERT INTO `citycode` VALUES (255, 'T', '景德鎮(zhèn)', '0798');
INSERT INTO `citycode` VALUES (256, 'T', '九江', '0792');
INSERT INTO `citycode` VALUES (257, 'T', '南昌', '0791');
INSERT INTO `citycode` VALUES (258, 'T', '萍鄉(xiāng)', '0799');
INSERT INTO `citycode` VALUES (259, 'T', '上饒', '0793');
INSERT INTO `citycode` VALUES (260, 'T', '新余', '0790');
INSERT INTO `citycode` VALUES (261, 'T', '宜春', '0795');
INSERT INTO `citycode` VALUES (262, 'T', '鷹潭', '0701');
INSERT INTO `citycode` VALUES (263, 'U', '百色', '0776');
INSERT INTO `citycode` VALUES (264, 'U', '北海', '0779');
INSERT INTO `citycode` VALUES (265, 'U', '桂林', '0773');
INSERT INTO `citycode` VALUES (266, 'U', '河池', '0778');
INSERT INTO `citycode` VALUES (267, 'U', '賀州', '0774');
INSERT INTO `citycode` VALUES (268, 'U', '來賓', '0772');
INSERT INTO `citycode` VALUES (269, 'U', '柳州', '0772');
INSERT INTO `citycode` VALUES (270, 'U', '南寧', '0771');
INSERT INTO `citycode` VALUES (271, 'U', '欽州', '0777');
INSERT INTO `citycode` VALUES (272, 'U', '梧州', '0774');
INSERT INTO `citycode` VALUES (273, 'U', '玉林', '0775');
INSERT INTO `citycode` VALUES (274, 'V', '巴彥淖爾', '0478');
INSERT INTO `citycode` VALUES (275, 'V', '包頭', '0472');
INSERT INTO `citycode` VALUES (276, 'V', '赤峰', '0476');
INSERT INTO `citycode` VALUES (277, 'V', '鄂爾多斯', '0477');
INSERT INTO `citycode` VALUES (278, 'V', '呼和浩特', '0471');
INSERT INTO `citycode` VALUES (279, 'V', '呼倫貝爾', '0470');
INSERT INTO `citycode` VALUES (280, 'V', '通遼', '0475');
INSERT INTO `citycode` VALUES (281, 'V', '烏海', '0473');
INSERT INTO `citycode` VALUES (282, 'V', '烏蘭察布', '0474');
INSERT INTO `citycode` VALUES (283, 'V', '錫林郭勒', '0479');
INSERT INTO `citycode` VALUES (284, 'W', '白銀', '0943');
INSERT INTO `citycode` VALUES (285, 'W', '酒泉', '0937');
INSERT INTO `citycode` VALUES (286, 'W', '蘭州', '0931');
INSERT INTO `citycode` VALUES (287, 'W', '天水', '0938');
INSERT INTO `citycode` VALUES (288, 'W', '武威', '0935');
INSERT INTO `citycode` VALUES (289, 'W', '張掖', '0936');
INSERT INTO `citycode` VALUES (290, 'X', '寧夏', '0951');
INSERT INTO `citycode` VALUES (291, 'Y', '安順', '0853');
INSERT INTO `citycode` VALUES (292, 'Y', '畢節(jié)', '0857');
INSERT INTO `citycode` VALUES (293, 'Y', '貴陽', '0851');
INSERT INTO `citycode` VALUES (294, 'Y', '六盤水', '0858');
INSERT INTO `citycode` VALUES (295, 'Y', '黔東南', '0855');
INSERT INTO `citycode` VALUES (296, 'Y', '黔南', '0854');
INSERT INTO `citycode` VALUES (297, 'Y', '黔西南（興義）', '0859');
INSERT INTO `citycode` VALUES (298, 'Y', '銅仁', '0856');
INSERT INTO `citycode` VALUES (299, 'Y', '遵義', '0852');
INSERT INTO `citycode` VALUES (300, 'Z', '青海', '0971');

SET FOREIGN_KEY_CHECKS = 1;

?