全国-电话区号 sql

/*
Date: 2015-3-10 18:33:56
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for area_code
-- ----------------------------
CREATE TABLE `area_code` (
`id` int(11) NOT NULL auto_increment,
`city` varchar(10) default NULL,
`code` varchar(5) default NULL,
`province` varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `area_code` VALUES ('1', '北京市', '010', '北京市');
INSERT INTO `area_code` VALUES ('2', '天津市', '022', '天津市');
INSERT INTO `area_code` VALUES ('3', '上海市', '021', '上海市');
INSERT INTO `area_code` VALUES ('4', '重庆市', '023', '重庆市');
INSERT INTO `area_code` VALUES ('5', '全省', '0898', '海南省');
INSERT INTO `area_code` VALUES ('6', '石家庄', '0311', '河北省');
INSERT INTO `area_code` VALUES ('7', '唐山市', '0315', '河北省');
INSERT INTO `area_code` VALUES ('8', '青黄岛', '0335', '河北省');
INSERT INTO `area_code` VALUES ('9', '邯郸市', '0310', '河北省');
INSERT INTO `area_code` VALUES ('10', '邢台市', '0319', '河北省');
INSERT INTO `area_code` VALUES ('11', '保定市', '0312', '河北省');
INSERT INTO `area_code` VALUES ('12', '张家口市', '0313', '河北省');
INSERT INTO `area_code` VALUES ('13', '承德市', '0314', '河北省');
INSERT INTO `area_code` VALUES ('14', '沧州市', '0317', '河北省');
INSERT INTO `area_code` VALUES ('15', '廊坊市', '0316', '河北省');
INSERT INTO `area_code` VALUES ('16', '衡水市', '0318', '河北省');
INSERT INTO `area_code` VALUES ('17', '太原市', '0351', '山西省');
INSERT INTO `area_code` VALUES ('18', '大同市', '0352', '山西省');
INSERT INTO `area_code` VALUES ('19', '阳泉市', '0353', '山西省');
INSERT INTO `area_code` VALUES ('20', '长治市', '0355', '山西省');
INSERT INTO `area_code` VALUES ('21', '晋城市', '0356', '山西省');
INSERT INTO `area_code` VALUES ('22', '朔州市', '0349', '山西省');
INSERT INTO `area_code` VALUES ('23', '忻州市', '0350', '山西省');
INSERT INTO `area_code` VALUES ('24', '吕梁市', '0358', '山西省');
INSERT INTO `area_code` VALUES ('25', '晋中市', '0354', '山西省');
INSERT INTO `area_code` VALUES ('26', '临汾市', '0357', '山西省');
INSERT INTO `area_code` VALUES ('27', '运城市', '0359', '山西省');
INSERT INTO `area_code` VALUES ('28', '呼和浩特', '0471', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('29', '包头市', '0472', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('30', '乌海市', '0473', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('31', '赤峰市', '0476', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('32', '通辽市', '0475', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('33', '呼伦贝尔市', '0470', '内蒙古自治区');
INSERT INTO `area_code` VALU

ES ('34', '兴安盟', '0482', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('35', '锡林郭勒盟', '0479', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('36', '乌兰察布市', '0474', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('37', '鄂尔多斯市', '0477', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('38', '巴彦淖尔市', '0478', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('39', '阿拉善盟', '0483', '内蒙古自治区');
INSERT INTO `area_code` VALUES ('40', '沈阳市', '024', '辽宁省');
INSERT INTO `area_code` VALUES ('41', '大连市', '0411', '辽宁省');
INSERT INTO `area_code` VALUES ('42', '鞍山市', '0412', '辽宁省');
INSERT INTO `area_code` VALUES ('43', '抚顺市', '0413', '辽宁省');
INSERT INTO `area_code` VALUES ('44', '本溪市', '0414', '辽宁省');
INSERT INTO `area_code` VALUES ('45', '丹东市', '0415', '辽宁省');
INSERT INTO `area_code` VALUES ('46', '锦州市', '0416', '辽宁省');
INSERT INTO `area_code` VALUES ('47', '营口市', '0417', '辽宁省');
INSERT INTO `area_code` VALUES ('48', '阜新市', '0418', '辽宁省');
INSERT INTO `area_code` VALUES ('49', '辽阳市', '0419', '辽宁省');
INSERT INTO `area_code` VALUES ('50', '盘锦市', '0427', '辽宁省');
INSERT INTO `area_code` VALUES ('51', '铁岭市', '0410', '辽宁省');
INSERT INTO `area_code` VALUES ('52', '朝阳市', '0421', '辽宁省');
INSERT INTO `area_code` VALUES ('53', '葫芦岛市', '0429', '辽宁省');
INSERT INTO `area_code` VALUES ('54', '长春市', '0431', '吉林省');
INSERT INTO `area_code` VALUES ('55', '吉林市', '0432', '吉林省');
INSERT INTO `area_code` VALUES ('56', '四平市', '0434', '吉林省');
INSERT INTO `area_code` VALUES ('57', '辽源市', '0437', '吉林省');
INSERT INTO `area_code` VALUES ('58', '通话市', '0435', '吉林省');
INSERT INTO `area_code` VALUES ('59', '辉南县', '0448', '吉林省');
INSERT INTO `area_code` VALUES ('60', '集安市', '0435', '吉林省');
INSERT INTO `area_code` VALUES ('61', '白山市', '0439', '吉林省');
INSERT INTO `area_code` VALUES ('62', '松原市', '0438', '吉林省');
INSERT INTO `area_code` VALUES ('63', '白城市', '0436', '吉林省');
INSERT INTO `area_code` VALUES ('64', '延吉市', '0433', '吉林省');
INSERT INTO `area_code` VALUES ('65', '珲春市', '0440', '吉林省');
INSERT INTO `area_code` VALUES ('66', '龙井市', '0433', '吉林省');
INSERT INTO `area_code` VALUES ('67', '哈尔滨市', '0451', '黑龙江省');
INSERT INTO `area_code` VALUES ('68', '齐齐哈尔市', '0452', '黑龙江省');
INSERT INTO `area_code` VALUES ('69', '鸡西市', '0467', '黑龙江省');
INSERT INTO `area_code` VALUES ('70', '鹤岗市', '0468', '黑龙江省');
INSERT INTO `area_code` VALUES ('71', '双鸭山市', '0469', '黑龙江省');
INSERT INTO `area_code` VALUES ('72', '大庆市', '0459', '黑龙江省');
INSERT INTO `area_code` VALUE

S ('73', '伊春市', '0458', '黑龙江省');
INSERT INTO `area_code` VALUES ('74', '佳木斯市', '0454', '黑龙江省');
INSERT INTO `area_code` VALUES ('75', '七台河市', '0464', '黑龙江省');
INSERT INTO `area_code` VALUES ('76', '牡丹江市', '0453', '黑龙江省');
INSERT INTO `area_code` VALUES ('77', '黑河市', '0456', '黑龙江省');
INSERT INTO `area_code` VALUES ('78', '绥化市', '0455', '黑龙江省');
INSERT INTO `area_code` VALUES ('79', '大兴安岭地区', '0457', '黑龙江省');
INSERT INTO `area_code` VALUES ('80', '南京市', '025', '江苏省');
INSERT INTO `area_code` VALUES ('81', '无锡市', '0510', '江苏省');
INSERT INTO `area_code` VALUES ('82', '徐州市', '0516', '江苏省');
INSERT INTO `area_code` VALUES ('83', '常州市', '0519', '江苏省');
INSERT INTO `area_code` VALUES ('84', '苏州市', '0512', '江苏省');
INSERT INTO `area_code` VALUES ('85', '南通市', '0513', '江苏省');
INSERT INTO `area_code` VALUES ('86', '连云港市', '0518', '江苏省');
INSERT INTO `area_code` VALUES ('87', '淮安市', '0517', '江苏省');
INSERT INTO `area_code` VALUES ('88', '宿迁市', '0527', '江苏省');
INSERT INTO `area_code` VALUES ('89', '盐城市', '0515', '江苏省');
INSERT INTO `area_code` VALUES ('90', '扬州市', '0514', '江苏省');
INSERT INTO `area_code` VALUES ('91', '泰州市', '0523', '江苏省');
INSERT INTO `area_code` VALUES ('92', '镇江市', '0511', '江苏省');
INSERT INTO `area_code` VALUES ('93', '杭州市', '0571', '浙江省');
INSERT INTO `area_code` VALUES ('94', '宁波市', '0574', '浙江省');
INSERT INTO `area_code` VALUES ('95', '温州市', '0577', '浙江省');
INSERT INTO `area_code` VALUES ('96', '嘉兴市', '0573', '浙江省');
INSERT INTO `area_code` VALUES ('97', '湖州市', '0572', '浙江省');
INSERT INTO `area_code` VALUES ('98', '绍兴市', '0575', '浙江省');
INSERT INTO `area_code` VALUES ('99', '金华市', '0579', '浙江省');
INSERT INTO `area_code` VALUES ('100', '衢州市', '0570', '浙江省');
INSERT INTO `area_code` VALUES ('101', '舟山市', '0580', '浙江省');
INSERT INTO `area_code` VALUES ('102', '台州市', '0576', '浙江省');
INSERT INTO `area_code` VALUES ('103', '丽水市', '0578', '浙江省');
INSERT INTO `area_code` VALUES ('104', '合肥市', '0551', '安徽省');
INSERT INTO `area_code` VALUES ('105', '芜湖市', '0553', '安徽省');
INSERT INTO `area_code` VALUES ('106', '蚌埠市', '0552', '安徽省');
INSERT INTO `area_code` VALUES ('107', '淮南市', '0554', '安徽省');
INSERT INTO `area_code` VALUES ('108', '马鞍山市', '0555', '安徽省');
INSERT INTO `area_code` VALUES ('109', '淮北市', '0561', '安徽省');
INSERT INTO `area_code` VALUES ('110', '铜陵市', '0562', '安徽省');
INSERT INTO `area_code` VALUES ('111', '安庆市', '0556', '安徽省');
INSERT INTO `area_code` VALUES ('112', '桐城市', '0556', '安徽省');
INSERT INTO

`area_code` VALUES ('113', '黄山市', '0559', '安徽省');
INSERT INTO `area_code` VALUES ('114', '滁州市', '0550', '安徽省');
INSERT INTO `area_code` VALUES ('115', '阜阳市', '0558', '安徽省');
INSERT INTO `area_code` VALUES ('116', '宿州市', '0557', '安徽省');
INSERT INTO `area_code` VALUES ('117', '六安市', '0564', '安徽省');
INSERT INTO `area_code` VALUES ('118', '宣城市', '0563', '安徽省');
INSERT INTO `area_code` VALUES ('119', '巢湖市', '0565', '安徽省');
INSERT INTO `area_code` VALUES ('120', '池州市', '0566', '安徽省');
INSERT INTO `area_code` VALUES ('121', '福州市', '0591', '福建省');
INSERT INTO `area_code` VALUES ('122', '厦门市', '0592', '福建省');
INSERT INTO `area_code` VALUES ('123', '莆田市', '0594', '福建省');
INSERT INTO `area_code` VALUES ('124', '三明市', '0598', '福建省');
INSERT INTO `area_code` VALUES ('125', '泉州市', '0595', '福建省');
INSERT INTO `area_code` VALUES ('126', '漳州市', '0596', '福建省');
INSERT INTO `area_code` VALUES ('127', '南平市', '0599', '福建省');
INSERT INTO `area_code` VALUES ('128', '龙岩市', '0597', '福建省');
INSERT INTO `area_code` VALUES ('129', '宁德市', '0593', '福建省');
INSERT INTO `area_code` VALUES ('130', '南昌市', '0791', '江西省');
INSERT INTO `area_code` VALUES ('131', '景德镇市', '0798', '江西省');
INSERT INTO `area_code` VALUES ('132', '萍乡市', '0799', '江西省');
INSERT INTO `area_code` VALUES ('133', '九江市', '0792', '江西省');
INSERT INTO `area_code` VALUES ('134', '新余市', '0790', '江西省');
INSERT INTO `area_code` VALUES ('135', '鹰潭市', '0701', '江西省');
INSERT INTO `area_code` VALUES ('136', '赣州市', '0797', '江西省');
INSERT INTO `area_code` VALUES ('137', '宜春市', '0795', '江西省');
INSERT INTO `area_code` VALUES ('138', '上饶市', '0793', '江西省');
INSERT INTO `area_code` VALUES ('139', '吉安市', '0796', '江西省');
INSERT INTO `area_code` VALUES ('140', '抚州市', '0794', '江西省');
INSERT INTO `area_code` VALUES ('141', '济南市', '0531', '山东省');
INSERT INTO `area_code` VALUES ('142', '长清市', '0531', '山东省');
INSERT INTO `area_code` VALUES ('143', '平阴县', '0531', '山东省');
INSERT INTO `area_code` VALUES ('144', '济阳县', '0531', '山东省');
INSERT INTO `area_code` VALUES ('145', '商河县', '0531', '山东省');
INSERT INTO `area_code` VALUES ('146', '章丘市', '0531', '山东省');
INSERT INTO `area_code` VALUES ('147', '青岛市', '0532', '山东省');
INSERT INTO `area_code` VALUES ('148', '胶州市', '0532', '山东省');
INSERT INTO `area_code` VALUES ('149', '即墨市', '0532', '山东省');
INSERT INTO `area_code` VALUES ('150', '平度市', '0532', '山东省');
INSERT INTO `area_code` VALUES ('151', '胶南市', '0532', '山东省');
INSERT INTO `area_code` VALUES ('152', '莱西市', '0532', '山东省');
INSERT IN

TO `area_code` VALUES ('153', '淄博市', '0533', '山东省');
INSERT INTO `area_code` VALUES ('154', '桓台县', '0533', '山东省');
INSERT INTO `area_code` VALUES ('155', '高青县', '0533', '山东省');
INSERT INTO `area_code` VALUES ('156', '沂源县', '0533', '山东省');
INSERT INTO `area_code` VALUES ('157', '枣庄市', '0632', '山东省');
INSERT INTO `area_code` VALUES ('158', '滕州市', '0632', '山东省');
INSERT INTO `area_code` VALUES ('159', '东营市', '0546', '山东省');
INSERT INTO `area_code` VALUES ('160', '垦利县', '0546', '山东省');
INSERT INTO `area_code` VALUES ('161', '利津县', '0546', '山东省');
INSERT INTO `area_code` VALUES ('162', '广饶县', '0546', '山东省');
INSERT INTO `area_code` VALUES ('163', '烟台市', '0535', '山东省');
INSERT INTO `area_code` VALUES ('164', '牟平区', '0535', '山东省');
INSERT INTO `area_code` VALUES ('165', '长岛县', '0535', '山东省');
INSERT INTO `area_code` VALUES ('166', '潍坊市', '0536', '山东省');
INSERT INTO `area_code` VALUES ('167', '济宁市', '0537', '山东省');
INSERT INTO `area_code` VALUES ('168', '泰安市', '0538', '山东省');
INSERT INTO `area_code` VALUES ('169', '威海市', '0631', '山东省');
INSERT INTO `area_code` VALUES ('170', '日照市', '0633', '山东省');
INSERT INTO `area_code` VALUES ('171', '莱芜市', '0634', '山东省');
INSERT INTO `area_code` VALUES ('172', '滨州市', '0543', '山东省');
INSERT INTO `area_code` VALUES ('173', '德州市', '0534', '山东省');
INSERT INTO `area_code` VALUES ('174', '聊城市', '0635', '山东省');
INSERT INTO `area_code` VALUES ('175', '临沂市', '0539', '山东省');
INSERT INTO `area_code` VALUES ('176', '荷泽市', '0530', '山东省');
INSERT INTO `area_code` VALUES ('177', '曹县', '0530', '山东省');
INSERT INTO `area_code` VALUES ('178', '郓城县', '0530', '山东省');
INSERT INTO `area_code` VALUES ('179', '郑州市', '0371', '河南省');
INSERT INTO `area_code` VALUES ('180', '开封市', '0378', '河南省');
INSERT INTO `area_code` VALUES ('181', '洛阳市', '0379', '河南省');
INSERT INTO `area_code` VALUES ('182', '平顶山市', '0375', '河南省');
INSERT INTO `area_code` VALUES ('183', '安阳市', '0372', '河南省');
INSERT INTO `area_code` VALUES ('184', '鹤壁市', '0392', '河南省');
INSERT INTO `area_code` VALUES ('185', '新乡市', '0373', '河南省');
INSERT INTO `area_code` VALUES ('186', '焦作市', '0391', '河南省');
INSERT INTO `area_code` VALUES ('187', '濮阳市', '0393', '河南省');
INSERT INTO `area_code` VALUES ('188', '许昌市', '0374', '河南省');
INSERT INTO `area_code` VALUES ('189', '漯河市', '0395', '河南省');
INSERT INTO `area_code` VALUES ('190', '三门峡市', '0398', '河南省');
INSERT INTO `area_code` VALUES ('191', '南阳市', '0377', '河南省');
INSERT INTO `area_code` VALUES ('192', '商丘市', '0370', '河南省');
INSERT

INTO `area_code` VALUES ('193', '周口市', '0394', '河南省');
INSERT INTO `area_code` VALUES ('194', '驻马店市', '0396', '河南省');
INSERT INTO `area_code` VALUES ('195', '信阳市', '0376', '河南省');
INSERT INTO `area_code` VALUES ('196', '济源市', '0391', '河南省');
INSERT INTO `area_code` VALUES ('197', '武汉市', '027', '湖北省');
INSERT INTO `area_code` VALUES ('198', '黄石市', '0714', '湖北省');
INSERT INTO `area_code` VALUES ('199', '十堰市', '0719', '湖北省');
INSERT INTO `area_code` VALUES ('200', '宜昌市', '0717', '湖北省');
INSERT INTO `area_code` VALUES ('201', '襄阳市', '0710', '湖北省');
INSERT INTO `area_code` VALUES ('202', '鄂州市', '0711', '湖北省');
INSERT INTO `area_code` VALUES ('203', '荆门市', '0724', '湖北省');
INSERT INTO `area_code` VALUES ('204', '孝感市', '0712', '湖北省');
INSERT INTO `area_code` VALUES ('205', '黄冈市', '0713', '湖北省');
INSERT INTO `area_code` VALUES ('206', '荆州市', '0716', '湖北省');
INSERT INTO `area_code` VALUES ('207', '天门市', '0728', '湖北省');
INSERT INTO `area_code` VALUES ('208', '随州市', '0722', '湖北省');
INSERT INTO `area_code` VALUES ('209', '咸宁市', '0715', '湖北省');
INSERT INTO `area_code` VALUES ('210', '恩施土家族', '0718', '湖北省');
INSERT INTO `area_code` VALUES ('211', '长沙市', '0731', '湖南省');
INSERT INTO `area_code` VALUES ('212', '湘潭市', '0731', '湖南省');
INSERT INTO `area_code` VALUES ('213', '株洲市', '0731', '湖南省');
INSERT INTO `area_code` VALUES ('214', '衡阳市', '0734', '湖南省');
INSERT INTO `area_code` VALUES ('215', '邵阳市', '0739', '湖南省');
INSERT INTO `area_code` VALUES ('216', '岳阳市', '0730', '湖南省');
INSERT INTO `area_code` VALUES ('217', '常德市', '0736', '湖南省');
INSERT INTO `area_code` VALUES ('218', '张家界市', '0744', '湖南省');
INSERT INTO `area_code` VALUES ('219', '益阳市', '0737', '湖南省');
INSERT INTO `area_code` VALUES ('220', '郴州市', '0735', '湖南省');
INSERT INTO `area_code` VALUES ('221', '永州市', '0746', '湖南省');
INSERT INTO `area_code` VALUES ('222', '怀化市', '0745', '湖南省');
INSERT INTO `area_code` VALUES ('223', '娄底市', '0738', '湖南省');
INSERT INTO `area_code` VALUES ('224', '湘西土家族苗族', '0743', '湖南省');
INSERT INTO `area_code` VALUES ('225', '广州市', '020', '广东省');
INSERT INTO `area_code` VALUES ('226', '韶关市', '0751', '广东省');
INSERT INTO `area_code` VALUES ('227', '深圳市', '0755', '广东省');
INSERT INTO `area_code` VALUES ('228', '珠海市', '0756', '广东省');
INSERT INTO `area_code` VALUES ('229', '汕头市', '0754', '广东省');
INSERT INTO `area_code` VALUES ('230', '潮阳区', '0754', '广东省');
INSERT INTO `area_code` VALUES ('231', '潮南区', '0754', '广东省');
INSERT INTO `area_code` VALUES ('232', '江门市', '0750',

'广东省');
INSERT INTO `area_code` VALUES ('233', '湛江市', '0759', '广东省');
INSERT INTO `area_code` VALUES ('234', '茂名市', '0668', '广东省');
INSERT INTO `area_code` VALUES ('235', '肇庆市', '0758', '广东省');
INSERT INTO `area_code` VALUES ('236', '惠州市', '0752', '广东省');
INSERT INTO `area_code` VALUES ('237', '梅州市', '0753', '广东省');
INSERT INTO `area_code` VALUES ('238', '汕尾市', '0660', '广东省');
INSERT INTO `area_code` VALUES ('239', '河源市', '0762', '广东省');
INSERT INTO `area_code` VALUES ('240', '阳江市', '0662', '广东省');
INSERT INTO `area_code` VALUES ('241', '清远市', '0763', '广东省');
INSERT INTO `area_code` VALUES ('242', '东莞市', '0769', '广东省');
INSERT INTO `area_code` VALUES ('243', '中山市', '0760', '广东省');
INSERT INTO `area_code` VALUES ('244', '潮州市', '0768', '广东省');
INSERT INTO `area_code` VALUES ('245', '揭阳市', '0663', '广东省');
INSERT INTO `area_code` VALUES ('246', '顺德区', '0757', '广东省');
INSERT INTO `area_code` VALUES ('247', '佛山市', '0757', '广东省');
INSERT INTO `area_code` VALUES ('248', '南宁市', '0771', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('249', '柳州市', '0772', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('250', '桂林市', '0773', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('251', '梧州市', '0774', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('252', '北海市', '0779', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('253', '防城港市', '0770', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('254', '贵港市', '0775', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('255', '钦州市', '0777', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('256', '百色市', '0776', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('257', '河池市', '0778', '广西壮族自治区');
INSERT INTO `area_code` VALUES ('258', '成都市', '028', '四川省');
INSERT INTO `area_code` VALUES ('259', '自贡市', '0813', '四川省');
INSERT INTO `area_code` VALUES ('260', '泸州市', '0830', '四川省');
INSERT INTO `area_code` VALUES ('261', '攀枝花市', '0812', '四川省');
INSERT INTO `area_code` VALUES ('262', '德阳市', '0838', '四川省');
INSERT INTO `area_code` VALUES ('263', '绵阳市', '0816', '四川省');
INSERT INTO `area_code` VALUES ('264', '广元市', '0839', '四川省');
INSERT INTO `area_code` VALUES ('265', '遂宁市', '0825', '四川省');
INSERT INTO `area_code` VALUES ('266', '内江市', '0832', '四川省');
INSERT INTO `area_code` VALUES ('267', '乐山市', '0833', '四川省');
INSERT INTO `area_code` VALUES ('268', '南充市', '0817', '四川省');
INSERT INTO `area_code` VALUES ('269', '广安市', '0826', '四川省');
INSERT INTO `area_code` VALUES ('270', '宜宾市', '0831', '四川省');
INSERT IN

TO `area_code` VALUES ('271', '达州市', '0818', '四川省');
INSERT INTO `area_code` VALUES ('272', '雅安市', '0835', '四川省');
INSERT INTO `area_code` VALUES ('273', '阿坝藏族羌族', '0837', '四川省');
INSERT INTO `area_code` VALUES ('274', '甘孜藏族', '0836', '四川省');
INSERT INTO `area_code` VALUES ('275', '凉山彝族', '0834', '四川省');
INSERT INTO `area_code` VALUES ('276', '巴中市', '0827', '四川省');
INSERT INTO `area_code` VALUES ('277', '贵阳市', '0851', '贵州省');
INSERT INTO `area_code` VALUES ('278', '六盘水市', '0858', '贵州省');
INSERT INTO `area_code` VALUES ('279', '遵义市', '0852', '贵州省');
INSERT INTO `area_code` VALUES ('280', '铜仁地区', '0856', '贵州省');
INSERT INTO `area_code` VALUES ('281', '毕节地区', '0857', '贵州省');
INSERT INTO `area_code` VALUES ('282', '安顺市', '0853', '贵州省');
INSERT INTO `area_code` VALUES ('283', '黔东南苗族侗族', '0855', '贵州省');
INSERT INTO `area_code` VALUES ('284', '黔南布依族苗族', '0854', '贵州省');
INSERT INTO `area_code` VALUES ('285', '昆明市', '0871', '云南省');
INSERT INTO `area_code` VALUES ('286', '昭通市', '0870', '云南省');
INSERT INTO `area_code` VALUES ('287', '曲靖市', '0874', '云南省');
INSERT INTO `area_code` VALUES ('288', '楚雄彝族', '0878', '云南省');
INSERT INTO `area_code` VALUES ('289', '玉溪市', '0877', '云南省');
INSERT INTO `area_code` VALUES ('290', '红河哈尼族彝族', '0873', '云南省');
INSERT INTO `area_code` VALUES ('291', '文山壮族苗族', '0876', '云南省');
INSERT INTO `area_code` VALUES ('292', '思茅市', '0879', '云南省');
INSERT INTO `area_code` VALUES ('293', '西双版纳傣族', '0691', '云南省');
INSERT INTO `area_code` VALUES ('294', '大理白族', '0872', '云南省');
INSERT INTO `area_code` VALUES ('295', '保山市', '0875', '云南省');
INSERT INTO `area_code` VALUES ('296', '德宏傣族景颇族', '0692', '云南省');
INSERT INTO `area_code` VALUES ('297', '丽江市', '0888', '云南省');
INSERT INTO `area_code` VALUES ('298', '怒江僳僳族', '0886', '云南省');
INSERT INTO `area_code` VALUES ('299', '迪庆藏族', '0887', '云南省');
INSERT INTO `area_code` VALUES ('300', '临沧市', '0883', '云南省');
INSERT INTO `area_code` VALUES ('301', '拉萨市', '0891', '西藏自治区');
INSERT INTO `area_code` VALUES ('302', '昌都地区', '0895', '西藏自治区');
INSERT INTO `area_code` VALUES ('303', '山南地区', '0893', '西藏自治区');
INSERT INTO `area_code` VALUES ('304', '日喀则地区', '0892', '西藏自治区');
INSERT INTO `area_code` VALUES ('305', '那曲地区', '0896', '西藏自治区');
INSERT INTO `area_code` VALUES ('306', '阿里地区', '0897', '西藏自治区');
INSERT INTO `area_code` VALUES ('307', '林芝地区', '0894', '西藏自治区');
INSERT INTO `area_code` VALUES ('308', '西安市、咸阳市', '0

29', '陕西省');
INSERT INTO `area_code` VALUES ('309', '铜川市', '0919', '陕西省');
INSERT INTO `area_code` VALUES ('310', '宝鸡市', '0917', '陕西省');
INSERT INTO `area_code` VALUES ('311', '西安市、咸阳市', '029', '陕西省');
INSERT INTO `area_code` VALUES ('312', '渭南市', '0913', '陕西省');
INSERT INTO `area_code` VALUES ('313', '汉中市', '0916', '陕西省');
INSERT INTO `area_code` VALUES ('314', '安康市', '0915', '陕西省');
INSERT INTO `area_code` VALUES ('315', '商洛市', '0914', '陕西省');
INSERT INTO `area_code` VALUES ('316', '延安市', '0911', '陕西省');
INSERT INTO `area_code` VALUES ('317', '榆林市', '0912', '陕西省');
INSERT INTO `area_code` VALUES ('318', '兰州市', '0931', '甘肃省');
INSERT INTO `area_code` VALUES ('319', '嘉峪关市', '0937', '甘肃省');
INSERT INTO `area_code` VALUES ('320', '金昌市', '0935', '甘肃省');
INSERT INTO `area_code` VALUES ('321', '白银市', '0943', '甘肃省');
INSERT INTO `area_code` VALUES ('322', '天水市', '0938', '甘肃省');
INSERT INTO `area_code` VALUES ('323', '酒泉市', '0937', '甘肃省');
INSERT INTO `area_code` VALUES ('324', '张掖市', '0936', '甘肃省');
INSERT INTO `area_code` VALUES ('325', '武威市', '0935', '甘肃省');
INSERT INTO `area_code` VALUES ('326', '定西市', '0935', '甘肃省');
INSERT INTO `area_code` VALUES ('327', '陇南市', '0939', '甘肃省');
INSERT INTO `area_code` VALUES ('328', '平凉市', '0933', '甘肃省');
INSERT INTO `area_code` VALUES ('329', '庆阳市', '0934', '甘肃省');
INSERT INTO `area_code` VALUES ('330', '临夏回族', '0930', '甘肃省');
INSERT INTO `area_code` VALUES ('331', '甘南藏族', '0941', '甘肃省');
INSERT INTO `area_code` VALUES ('332', '西宁市', '0971', '青海省');
INSERT INTO `area_code` VALUES ('333', '海东地区', '0972', '青海省');
INSERT INTO `area_code` VALUES ('334', '海北藏族', '0970', '青海省');
INSERT INTO `area_code` VALUES ('335', '黄南藏族', '0973', '青海省');
INSERT INTO `area_code` VALUES ('336', '海南藏族', '0974', '青海省');
INSERT INTO `area_code` VALUES ('337', '果洛藏族', '0975', '青海省');
INSERT INTO `area_code` VALUES ('338', '玉树藏族', '0976', '青海省');
INSERT INTO `area_code` VALUES ('339', '海西蒙古族藏族', '0977', '青海省');
INSERT INTO `area_code` VALUES ('340', '银川市', '0951', '宁夏回族自治区');
INSERT INTO `area_code` VALUES ('341', '石嘴山市', '0952', '宁夏回族自治区');
INSERT INTO `area_code` VALUES ('342', '吴忠市', '0953', '宁夏回族自治区');
INSERT INTO `area_code` VALUES ('343', '固原市', '0954', '宁夏回族自治区');
INSERT INTO `area_code` VALUES ('344', '中卫市', '0955', '宁夏回族自治区');
INSERT INTO `area_code` VALUES ('345', '乌鲁木齐市', '0991', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('346', '克拉玛依市', '0990', '新

疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('347', '石河子市', '0993', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('348', '吐鲁番地区', '0995', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('349', '哈密地区', '0905', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('350', '昌吉回族', '0994', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('351', '博尔塔拉蒙古族', '0909', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('352', '巴音郭楞蒙古族', '0996', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('353', '阿克苏地区', '0997', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('354', '克孜勒苏柯尔克孜', '0908', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('355', '喀什地区', '0998', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('356', '和田地区', '0903', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('357', '伊犁哈萨克', '0999', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('358', '奎屯市', '0992', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('359', '塔城地区', '0901', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('360', '阿勒泰地区', '0906', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('361', '乌苏市', '0992', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('362', '沙湾县', '0993', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('363', '和布克赛尔蒙古县', '0990', '新疆维吾尔自治区');
INSERT INTO `area_code` VALUES ('364', '台湾省', '00886', '中国其他地区');
INSERT INTO `area_code` VALUES ('365', '香港', '00852', '中国其他地区');
INSERT INTO `area_code` VALUES ('366', '澳门', '00853', '中国其他地区');