全国-电话区号 sql
/*
财神节是哪一天2019Date: 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', '河北省');11月英文
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', '内蒙古自治区');
五行穿衣指南2022年5月26
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

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。