全国省市对应电话区号sql、xlsx

/* Navicat MySQL Data Transfer Source Server : temp Source Server Version : 50022 Source Host : localhost:3306 Source Database : posm Target Server Type : MYSQL Target Server Version : 50022 File Encoding : 65001 Date: 2015-10-07 10:36:20 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for fanwe -- ---------------------------- DROP TABLE IF EXISTS `fanwe`; CREATE TABLE `fanwe` ( `id` smallint(3) unsigned NOT NULL auto_increment, `num` varchar(10) NOT NULL COMMENT '区号', `address` varchar(50) NOT NULL COMMENT '区号地址', `province` varchar(50) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of fanwe -- ---------------------------- INSERT INTO `fanwe` VALUES ('1', '010', '北京市', '北京市'); INSERT INTO `fanwe` VALUES ('2', '021', '上海市', '上海市'); INSERT INTO `fanwe` VALUES ('3', '022', '天津市', '天津市'); INSERT INTO `fanwe` VALUES ('4', '023', '重庆市', '重庆市'); INSERT INTO `fanwe` VALUES ('5', '852', '香港', '香港'); INSERT INTO `fanwe` VALUES ('6', '853', '澳门', '澳门'); INSERT INTO `fanwe` VALUES ('7', '0310', '邯郸市', '河北省'); INSERT INTO `fanwe` VALUES ('8', '0311', '石家庄', '河北省'); INSERT INTO `fanwe` VALUES ('9', '0312', '保定市', '河北省'); INSERT INTO `fanwe` VALUES ('10', '0313', '张家口', '河北省'); INSERT INTO `fanwe` VALUES ('11', '0314', '承德市', '河北省'); INSERT INTO `fanwe` VALUES ('12', '0315', '唐山市', '河北省'); INSERT INTO `fanwe` VALUES ('13', '0316', '廊坊市', '河北省'); INSERT INTO `fanwe` VALUES ('14', '0317', '沧州市', '河北省'); INSERT INTO `fanwe` VALUES ('15', '0318', '衡水市', '河北省'); INSERT INTO `fanwe` VALUES ('16', '0319', '邢台市', '河北省'); INSERT INTO `fanwe` VALUES ('17', '0335', '秦皇岛', '河北省'); INSERT INTO `fanwe` VALUES ('18', '0570', '衢州市', '浙江省'); INSERT INTO `fanwe` VALUES ('19', '0571', '杭州市', '浙江省'); INSERT INTO `fanwe` VALUES ('20', '0572', '湖州市', '浙江省'); INSERT INTO `fanwe` VALUES ('21', '0573', '嘉兴市', '浙江省'); INSERT INTO `fanwe` VALUES ('22', '0574', '宁波市', '浙江省'); INSERT INTO `fanwe` VALUES ('23', '0575', '绍兴市', '浙江省'); INSERT INTO `fanwe` VALUES ('24', '0576', '台州市', '浙江省'); INSERT INTO `fanwe` VALUES ('25', '0577', '温州市', '浙江省'); INSERT INTO `fanwe` VALUES ('26', '0578', '丽水市', '浙江省'); INSERT INTO `fanwe` VALUES ('27', '0579', '金华市', '浙江省'); INSERT INTO `fanwe` VALUES ('28', '0580', '舟山市', '浙江省'); INSERT INTO `fanwe` VALUES ('29', '024', '沈阳市', '辽宁省'); INSERT INTO `fanwe` VALUES ('30', '0410', '铁岭市', '辽宁省'); INSERT INTO `fanwe` VALUES ('31', '0411', '大连市', '辽宁省'); INSERT INTO `fanwe` VALUES ('32', '0412', '鞍山市', '辽宁省'); INSERT INTO `fanwe` VALUES ('33', '0413', '抚顺市', '辽宁省'); INSERT INTO `fanwe` VALUES ('34', '0414', '本溪市', '辽宁省'); INSERT INTO `fanwe` VALUES ('35', '0415', '丹东市', '辽宁省'); INSERT INTO `fanwe` VALUES ('36', '0416', '锦州市', '辽宁省'); INSERT INTO `fanwe` VALUES ('37', '0417', '营口市', '辽宁省'); INSERT INTO `fanwe` VALUES ('38', '0418', '阜新市', '辽宁省'); INSERT INTO `fanwe` VALUES ('39', '0419', '辽阳市', '辽宁省'); INSERT INTO `fanwe` VALUES ('40', '0421', '朝阳市', '辽宁省'); INSERT INTO `fanwe` VALUES ('41', '0427', '盘锦市', '辽宁省'); INSERT INTO `fanwe` VALUES ('42', '0429', '葫芦岛', '辽宁省'); INSERT INTO `fanwe` VALUES ('43', '027', '武汉市', '湖北省'); INSERT INTO `fanwe` VALUES ('44', '0710', '襄城市', '湖北省'); INSERT INTO `fanwe` VALUES ('45', '0711', '鄂州市', '湖北省'); INSERT INTO `fanwe` VALUES ('46', '0712', '孝感市', '湖北省'); INSERT INTO `fanwe` VALUES ('47', '0713', '黄州市', '湖北省'); INSERT INTO `fanwe` VALUES ('48', '0714', '黄石市', '湖北省'); INSERT INTO `fanwe` VALUES ('49', '0715', '咸宁市', '湖北省'); INSERT INTO `fanwe` VALUES ('50', '0716', '荆沙市', '湖北省'); INSERT INTO `fanwe` VALUES ('51', '0717', '宜昌市', '湖北省'); INSERT INTO `fanwe` VALUES ('52', '0718', '恩施市', '湖北省'); INSERT INTO `fanwe` VALUES ('53', '0719', '十堰市', '湖北省'); INSERT INTO `fanwe` VALUES ('54', '0722', '随枣市', '湖北省'); INSERT INTO `fanwe` VALUES ('55', '0724', '荆门市', '湖北省'); INSERT INTO `fanwe` VALUES ('56', '0728', '江汉市', '湖北省'); INSERT INTO `fanwe` VALUES ('57', '025', '南京市', '江苏省'); INSERT INTO `fanwe` VALUES ('58', '0510', '无锡市', '江苏省'); INSERT INTO `fanwe` VALUES ('59', '0511', '镇江市', '江苏省'); INSERT INTO `fanwe` VALUES ('60', '0512', '苏州市', '江苏省'); INSERT INTO `fanwe` VALUES ('61', '0513', '南通市', '江苏省'); INSERT INTO `fanwe` VALUES ('62', '0514', '扬州市', '江苏省'); INSERT INTO `fanwe` VALUES ('63', '0515', '盐城市', '江苏省'); INSERT INTO `fanwe` VALUES ('64', '0516', '徐州市', '江苏省'); INSERT INTO `fanwe` VALUES ('65', '0517', '淮阴市', '江苏省'); INSERT INTO `fanwe` VALUES ('66', '0517', '淮安市', '江苏省'); INSERT INTO `fanwe` VALUES ('67', '0518', '连云港', '江苏省'); INSERT INTO `fanwe` VALUES ('68', '0519', '常州市', '江苏省'); INSERT INTO `fanwe` VALUES ('69', '0523', '泰州市', '江苏省'); INSERT INTO `fanwe` VALUES ('70', '0470', '海拉尔', '内蒙古'); INSERT INTO `fanwe` VALUES ('71', '0471', '呼和浩特', '内蒙古'); INSERT INTO `fanwe` VALUES ('72', '0472', '包头市', '内蒙古'); INSERT INTO `fanwe` VALUES ('73', '0473', '乌海市', '内蒙古'); INSERT INTO `fanwe` VALUES ('74', '0474', '集宁市', '内蒙古'); INSERT INTO `fanwe` VALUES ('75', '0475', '通辽市', '内蒙古'); INSERT INTO `fanwe` VALUES ('76', '0476', '赤峰市', '内蒙古'); INSERT INTO `fanwe` VALUES ('77', '0477', '东胜市', '内蒙古'); INSERT INTO `fanwe` VALUES ('78', '0478', '临河市', '内蒙古'); INSERT INTO `fanwe` VALUES ('79', '0479', '锡林浩特', '内蒙古'); INSERT INTO `fanwe` VALUES ('80', '0482', '乌兰浩特', '内蒙古'); INSERT INTO `fanwe` VALUES ('81', '0483', '阿拉善左旗', '内蒙古'); INSERT INTO `fanwe` VALUES ('82', '0790', '新余市', '江西省'); INSERT INTO `fanwe` VALUES ('83', '0791', '南昌市', '江西省'); INSERT INTO `fanwe` VALUES ('84', '0792', '九江市', '江西省'); INSERT INTO `fanwe` VALUES ('85', '0793', '上饶市', '江西省'); INSERT INTO `fanwe` VALUES ('86', '0794', '临川市', '江西省'); INSERT INTO `fanwe` VALUES ('87', '0795', '宜春市', '江西省'); INSERT INTO `fanwe` VALUES ('88', '0796', '吉安市', '江西省'); INSERT INTO `fanwe` VALUES ('89', '0797', '赣州市', '江西省'); INSERT INTO `fanwe` VALUES ('90', '0798', '景德镇', '江西省'); INSERT INTO `fanwe` VALUES ('91', '0799', '萍乡市', '江西省'); INSERT INTO `fanwe` VALUES ('92', '0701', '鹰潭市', '江西省'); INSERT INTO `fanwe` VALUES ('93', '0350', '忻州市', '山西省'); INSERT INTO `fanwe` VALUES ('94', '0351', '太原市', '山西省'); INSERT INTO `fanwe` VALUES ('95', '0352', '大同市', '山西省'); INSERT INTO `fanwe` VALUES ('96', '0353', '阳泉市', '山西省'); INSERT INTO `fanwe` VALUES ('97', '0354', '榆次市', '山西省'); INSERT INTO `fanwe` VALUES ('98', '0355', '长治市', '山西省'); INSERT INTO `fanwe` VALUES ('99', '0356', '晋城市', '山西省'); INSERT INTO `fanwe` VALUES ('100', '0357', '临汾市', '山西省'); INSERT INTO `fanwe` VALUES ('101', '0358', '离石市', '山西省'); INSERT INTO `fanwe` VALUES ('102', '0359', '运城市', '山西省'); INSERT INTO `fanwe` VALUES ('103', '0930', '�