首页 / MYSQL / 中国城市区号脚本-mysql
中国城市区号脚本-mysql
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了中国城市区号脚本-mysql，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含16005字，纯文字阅读大概需要23分钟。
内容图文
中国城市区号 300个。
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 '城市区号', 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', '清远', '0763'); INSERT INTO `citycode` VALUES (26, '3', '汕头', '0754'); INSERT INTO `citycode` VALUES (27, '3', '汕尾', '0660'); INSERT INTO `citycode` VALUES (28, '3', '韶关', '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', '达州', '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', '内江', '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', '扬州', '0514'); INSERT INTO `citycode` VALUES (93, 'A', '镇江', '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', '济南', '0531'); INSERT INTO `citycode` VALUES (109, 'C', '济宁', '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', '济源', '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', '新乡', '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', '运城', '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', '景德镇', '0798'); INSERT INTO `citycode` VALUES (256, 'T', '九江', '0792'); INSERT INTO `citycode` VALUES (257, 'T', '南昌', '0791'); INSERT INTO `citycode` VALUES (258, 'T', '萍乡', '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', '毕节', '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;
内容总结
以上是互联网集市为您收集整理的中国城市区号脚本-mysql全部内容，希望文章能够帮你解决中国城市区号脚本-mysql所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】