destoon全国省市地区destoon如何导入全国省市数据

 DestoonCMS   高蒙   阅读(1973)   评论(0)   2016-03-24 15:30:04    destoon导入全国省市数据 destoon省市数据 destoon地区选择 


destoon默认里面是有默认省市数据的area.sql文件的,在后台直接导入就可以了。但是,在我使用的6.0版本里面,直接导入area.sql文件是出错的。于是,我就用navicat进行处理下,再次的点击导入地区省市,就可以正确的显示了。

省市地区文件下载,百度云盘地址:

链接: http://pan.baidu.com/s/1dEaLCeX 密码: x986

area.sql文件地址:

/file/setting/area.sql

后台导入操作:

    后台 => 系统维护 => 系统设置 => 地区设置 => 导入省市

不明白设置看图:

333.jpg

省市地区代码:

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : destoon

Target Server Type    : MYSQL
Target Server Version : 50505
File Encoding         : 65001

Date: 2016-03-24 15:16:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for destoon_area
-- ----------------------------
DROP TABLE IF EXISTS `destoon_area`;
CREATE TABLE `destoon_area` (
  `areaid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `areaname` varchar(50) DEFAULT '',
  `parentid` int(10) unsigned DEFAULT '0',
  `arrparentid` varchar(255) DEFAULT '',
  `child` tinyint(1) DEFAULT '0',
  `arrchildid` text,
  `listorder` smallint(4) unsigned DEFAULT '0',
  PRIMARY KEY (`areaid`)
) ENGINE=MyISAM AUTO_INCREMENT=392 DEFAULT CHARSET=utf8 COMMENT='地区';

-- ----------------------------
-- Records of destoon_area
-- ----------------------------
INSERT INTO `destoon_area` VALUES ('1', '北京', '0', '0', '0', '1', '1');
INSERT INTO `destoon_area` VALUES ('2', '上海', '0', '0', '0', '2', '2');
INSERT INTO `destoon_area` VALUES ('3', '天津', '0', '0', '0', '3', '3');
INSERT INTO `destoon_area` VALUES ('4', '重庆', '0', '0', '0', '4', '4');
INSERT INTO `destoon_area` VALUES ('5', '河北', '0', '0', '1', '5,35,36,37,38,39,40,41,42,43,44,45', '5');
INSERT INTO `destoon_area` VALUES ('6', '山西', '0', '0', '1', '6,46,47,48,49,50,51,52,53,54,55,56', '6');
INSERT INTO `destoon_area` VALUES ('7', '内蒙古', '0', '0', '1', '7,57,58,59,60,61,62,63,64,65,66,67,68', '7');
INSERT INTO `destoon_area` VALUES ('8', '辽宁', '0', '0', '1', '8,69,70,71,72,73,74,75,76,77,78,79,80,81,82', '8');
INSERT INTO `destoon_area` VALUES ('9', '吉林', '0', '0', '1', '9,83,84,85,86,87,88,89,90,91', '9');
INSERT INTO `destoon_area` VALUES ('10', '黑龙江', '0', '0', '1', '10,92,93,94,95,96,97,98,99,100,101,102,103,104', '10');
INSERT INTO `destoon_area` VALUES ('11', '江苏', '0', '0', '1', '11,105,106,107,108,109,110,111,112,113,114,115,116,117', '11');
INSERT INTO `destoon_area` VALUES ('12', '浙江', '0', '0', '1', '12,118,119,120,121,122,123,124,125,126,127,128', '12');
INSERT INTO `destoon_area` VALUES ('13', '安徽', '0', '0', '1', '13,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145', '13');
INSERT INTO `destoon_area` VALUES ('14', '福建', '0', '0', '1', '14,146,147,148,149,150,151,152,153,154', '14');
INSERT INTO `destoon_area` VALUES ('15', '江西', '0', '0', '1', '15,155,156,157,158,159,160,161,162,163,164,165', '15');
INSERT INTO `destoon_area` VALUES ('16', '山东', '0', '0', '1', '16,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182', '16');
INSERT INTO `destoon_area` VALUES ('17', '河南', '0', '0', '1', '17,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199', '17');
INSERT INTO `destoon_area` VALUES ('18', '湖北', '0', '0', '1', '18,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216', '18');
INSERT INTO `destoon_area` VALUES ('19', '湖南', '0', '0', '1', '19,217,218,219,220,221,222,223,224,225,226,227,228,229,230', '19');
INSERT INTO `destoon_area` VALUES ('20', '广东', '0', '0', '1', '20,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251', '20');
INSERT INTO `destoon_area` VALUES ('21', '广西', '0', '0', '1', '21,252,253,254,255,256,257,258,259,260,261,262,263,264,265', '21');
INSERT INTO `destoon_area` VALUES ('22', '海南', '0', '0', '1', '22,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283', '22');
INSERT INTO `destoon_area` VALUES ('23', '四川', '0', '0', '1', '23,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304', '23');
INSERT INTO `destoon_area` VALUES ('24', '贵州', '0', '0', '1', '24,305,306,307,308,309,310,311,312,313', '24');
INSERT INTO `destoon_area` VALUES ('25', '云南', '0', '0', '1', '25,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329', '25');
INSERT INTO `destoon_area` VALUES ('26', '西藏', '0', '0', '1', '26,330,331,332,333,334,335,336', '26');
INSERT INTO `destoon_area` VALUES ('27', '陕西', '0', '0', '1', '27,337,338,339,340,341,342,343,344,345,346', '27');
INSERT INTO `destoon_area` VALUES ('28', '甘肃', '0', '0', '1', '28,347,348,349,350,351,352,353,354,355,356,357,358,359,360', '28');
INSERT INTO `destoon_area` VALUES ('29', '青海', '0', '0', '1', '29,361,362,363,364,365,366,367,368', '29');
INSERT INTO `destoon_area` VALUES ('30', '宁夏', '0', '0', '1', '30,369,370,371,372,373', '30');
INSERT INTO `destoon_area` VALUES ('31', '新疆', '0', '0', '1', '31,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391', '31');
INSERT INTO `destoon_area` VALUES ('32', '台湾', '0', '0', '0', '32', '32');
INSERT INTO `destoon_area` VALUES ('33', '香港', '0', '0', '0', '33', '33');
INSERT INTO `destoon_area` VALUES ('34', '澳门', '0', '0', '0', '34', '34');
INSERT INTO `destoon_area` VALUES ('35', '石家庄市', '5', '0,5', '0', '35', '35');
INSERT INTO `destoon_area` VALUES ('36', '唐山市', '5', '0,5', '0', '36', '36');
INSERT INTO `destoon_area` VALUES ('37', '秦皇岛市', '5', '0,5', '0', '37', '37');
INSERT INTO `destoon_area` VALUES ('38', '邯郸市', '5', '0,5', '0', '38', '38');
INSERT INTO `destoon_area` VALUES ('39', '邢台市', '5', '0,5', '0', '39', '39');
INSERT INTO `destoon_area` VALUES ('40', '保定市', '5', '0,5', '0', '40', '40');
INSERT INTO `destoon_area` VALUES ('41', '张家口市', '5', '0,5', '0', '41', '41');
INSERT INTO `destoon_area` VALUES ('42', '承德市', '5', '0,5', '0', '42', '42');
INSERT INTO `destoon_area` VALUES ('43', '沧州市', '5', '0,5', '0', '43', '43');
INSERT INTO `destoon_area` VALUES ('44', '廊坊市', '5', '0,5', '0', '44', '44');
INSERT INTO `destoon_area` VALUES ('45', '衡水市', '5', '0,5', '0', '45', '45');
INSERT INTO `destoon_area` VALUES ('46', '太原市', '6', '0,6', '0', '46', '46');
INSERT INTO `destoon_area` VALUES ('47', '大同市', '6', '0,6', '0', '47', '47');
INSERT INTO `destoon_area` VALUES ('48', '阳泉市', '6', '0,6', '0', '48', '48');
INSERT INTO `destoon_area` VALUES ('49', '长治市', '6', '0,6', '0', '49', '49');
INSERT INTO `destoon_area` VALUES ('50', '晋城市', '6', '0,6', '0', '50', '50');
INSERT INTO `destoon_area` VALUES ('51', '朔州市', '6', '0,6', '0', '51', '51');
INSERT INTO `destoon_area` VALUES ('52', '晋中市', '6', '0,6', '0', '52', '52');
INSERT INTO `destoon_area` VALUES ('53', '运城市', '6', '0,6', '0', '53', '53');
INSERT INTO `destoon_area` VALUES ('54', '忻州市', '6', '0,6', '0', '54', '54');
INSERT INTO `destoon_area` VALUES ('55', '临汾市', '6', '0,6', '0', '55', '55');
INSERT INTO `destoon_area` VALUES ('56', '吕梁市', '6', '0,6', '0', '56', '56');
INSERT INTO `destoon_area` VALUES ('57', '呼和浩特市', '7', '0,7', '0', '57', '57');
INSERT INTO `destoon_area` VALUES ('58', '包头市', '7', '0,7', '0', '58', '58');
INSERT INTO `destoon_area` VALUES ('59', '乌海市', '7', '0,7', '0', '59', '59');
INSERT INTO `destoon_area` VALUES ('60', '赤峰市', '7', '0,7', '0', '60', '60');
INSERT INTO `destoon_area` VALUES ('61', '通辽市', '7', '0,7', '0', '61', '61');
INSERT INTO `destoon_area` VALUES ('62', '鄂尔多斯市', '7', '0,7', '0', '62', '62');
INSERT INTO `destoon_area` VALUES ('63', '呼伦贝尔市', '7', '0,7', '0', '63', '63');
INSERT INTO `destoon_area` VALUES ('64', '巴彦淖尔市', '7', '0,7', '0', '64', '64');
INSERT INTO `destoon_area` VALUES ('65', '乌兰察布市', '7', '0,7', '0', '65', '65');
INSERT INTO `destoon_area` VALUES ('66', '兴安盟', '7', '0,7', '0', '66', '66');
INSERT INTO `destoon_area` VALUES ('67', '锡林郭勒盟', '7', '0,7', '0', '67', '67');
INSERT INTO `destoon_area` VALUES ('68', '阿拉善盟', '7', '0,7', '0', '68', '68');
INSERT INTO `destoon_area` VALUES ('69', '沈阳市', '8', '0,8', '0', '69', '69');
INSERT INTO `destoon_area` VALUES ('70', '大连市', '8', '0,8', '0', '70', '70');
INSERT INTO `destoon_area` VALUES ('71', '鞍山市', '8', '0,8', '0', '71', '71');
INSERT INTO `destoon_area` VALUES ('72', '抚顺市', '8', '0,8', '0', '72', '72');
INSERT INTO `destoon_area` VALUES ('73', '本溪市', '8', '0,8', '0', '73', '73');
INSERT INTO `destoon_area` VALUES ('74', '丹东市', '8', '0,8', '0', '74', '74');
INSERT INTO `destoon_area` VALUES ('75', '锦州市', '8', '0,8', '0', '75', '75');
INSERT INTO `destoon_area` VALUES ('76', '营口市', '8', '0,8', '0', '76', '76');
INSERT INTO `destoon_area` VALUES ('77', '阜新市', '8', '0,8', '0', '77', '77');
INSERT INTO `destoon_area` VALUES ('78', '辽阳市', '8', '0,8', '0', '78', '78');
INSERT INTO `destoon_area` VALUES ('79', '盘锦市', '8', '0,8', '0', '79', '79');
INSERT INTO `destoon_area` VALUES ('80', '铁岭市', '8', '0,8', '0', '80', '80');
INSERT INTO `destoon_area` VALUES ('81', '朝阳市', '8', '0,8', '0', '81', '81');
INSERT INTO `destoon_area` VALUES ('82', '葫芦岛市', '8', '0,8', '0', '82', '82');
INSERT INTO `destoon_area` VALUES ('83', '长春市', '9', '0,9', '0', '83', '83');
INSERT INTO `destoon_area` VALUES ('84', '吉林市', '9', '0,9', '0', '84', '84');
INSERT INTO `destoon_area` VALUES ('85', '四平市', '9', '0,9', '0', '85', '85');
INSERT INTO `destoon_area` VALUES ('86', '辽源市', '9', '0,9', '0', '86', '86');
INSERT INTO `destoon_area` VALUES ('87', '通化市', '9', '0,9', '0', '87', '87');
INSERT INTO `destoon_area` VALUES ('88', '白山市', '9', '0,9', '0', '88', '88');
INSERT INTO `destoon_area` VALUES ('89', '松原市', '9', '0,9', '0', '89', '89');
INSERT INTO `destoon_area` VALUES ('90', '白城市', '9', '0,9', '0', '90', '90');
INSERT INTO `destoon_area` VALUES ('91', '延边朝鲜族自治州', '9', '0,9', '0', '91', '91');
INSERT INTO `destoon_area` VALUES ('92', '哈尔滨市', '10', '0,10', '0', '92', '92');
INSERT INTO `destoon_area` VALUES ('93', '齐齐哈尔市', '10', '0,10', '0', '93', '93');
INSERT INTO `destoon_area` VALUES ('94', '鸡西市', '10', '0,10', '0', '94', '94');
INSERT INTO `destoon_area` VALUES ('95', '鹤岗市', '10', '0,10', '0', '95', '95');
INSERT INTO `destoon_area` VALUES ('96', '双鸭山市', '10', '0,10', '0', '96', '96');
INSERT INTO `destoon_area` VALUES ('97', '大庆市', '10', '0,10', '0', '97', '97');
INSERT INTO `destoon_area` VALUES ('98', '伊春市', '10', '0,10', '0', '98', '98');
INSERT INTO `destoon_area` VALUES ('99', '佳木斯市', '10', '0,10', '0', '99', '99');
INSERT INTO `destoon_area` VALUES ('100', '七台河市', '10', '0,10', '0', '100', '100');
INSERT INTO `destoon_area` VALUES ('101', '牡丹江市', '10', '0,10', '0', '101', '101');
INSERT INTO `destoon_area` VALUES ('102', '黑河市', '10', '0,10', '0', '102', '102');
INSERT INTO `destoon_area` VALUES ('103', '绥化市', '10', '0,10', '0', '103', '103');
INSERT INTO `destoon_area` VALUES ('104', '大兴安岭地区', '10', '0,10', '0', '104', '104');
INSERT INTO `destoon_area` VALUES ('105', '南京市', '11', '0,11', '0', '105', '105');
INSERT INTO `destoon_area` VALUES ('106', '无锡市', '11', '0,11', '0', '106', '106');
INSERT INTO `destoon_area` VALUES ('107', '徐州市', '11', '0,11', '0', '107', '107');
INSERT INTO `destoon_area` VALUES ('108', '常州市', '11', '0,11', '0', '108', '108');
INSERT INTO `destoon_area` VALUES ('109', '苏州市', '11', '0,11', '0', '109', '109');
INSERT INTO `destoon_area` VALUES ('110', '南通市', '11', '0,11', '0', '110', '110');
INSERT INTO `destoon_area` VALUES ('111', '连云港市', '11', '0,11', '0', '111', '111');
INSERT INTO `destoon_area` VALUES ('112', '淮安市', '11', '0,11', '0', '112', '112');
INSERT INTO `destoon_area` VALUES ('113', '盐城市', '11', '0,11', '0', '113', '113');
INSERT INTO `destoon_area` VALUES ('114', '扬州市', '11', '0,11', '0', '114', '114');
INSERT INTO `destoon_area` VALUES ('115', '镇江市', '11', '0,11', '0', '115', '115');
INSERT INTO `destoon_area` VALUES ('116', '泰州市', '11', '0,11', '0', '116', '116');
INSERT INTO `destoon_area` VALUES ('117', '宿迁市', '11', '0,11', '0', '117', '117');
INSERT INTO `destoon_area` VALUES ('118', '杭州市', '12', '0,12', '0', '118', '118');
INSERT INTO `destoon_area` VALUES ('119', '宁波市', '12', '0,12', '0', '119', '119');
INSERT INTO `destoon_area` VALUES ('120', '温州市', '12', '0,12', '0', '120', '120');
INSERT INTO `destoon_area` VALUES ('121', '嘉兴市', '12', '0,12', '0', '121', '121');
INSERT INTO `destoon_area` VALUES ('122', '湖州市', '12', '0,12', '0', '122', '122');
INSERT INTO `destoon_area` VALUES ('123', '绍兴市', '12', '0,12', '0', '123', '123');
INSERT INTO `destoon_area` VALUES ('124', '金华市', '12', '0,12', '0', '124', '124');
INSERT INTO `destoon_area` VALUES ('125', '衢州市', '12', '0,12', '0', '125', '125');
INSERT INTO `destoon_area` VALUES ('126', '舟山市', '12', '0,12', '0', '126', '126');
INSERT INTO `destoon_area` VALUES ('127', '台州市', '12', '0,12', '0', '127', '127');
INSERT INTO `destoon_area` VALUES ('128', '丽水市', '12', '0,12', '0', '128', '128');
INSERT INTO `destoon_area` VALUES ('129', '合肥市', '13', '0,13', '0', '129', '129');
INSERT INTO `destoon_area` VALUES ('130', '芜湖市', '13', '0,13', '0', '130', '130');
INSERT INTO `destoon_area` VALUES ('131', '蚌埠市', '13', '0,13', '0', '131', '131');
INSERT INTO `destoon_area` VALUES ('132', '淮南市', '13', '0,13', '0', '132', '132');
INSERT INTO `destoon_area` VALUES ('133', '马鞍山市', '13', '0,13', '0', '133', '133');
INSERT INTO `destoon_area` VALUES ('134', '淮北市', '13', '0,13', '0', '134', '134');
INSERT INTO `destoon_area` VALUES ('135', '铜陵市', '13', '0,13', '0', '135', '135');
INSERT INTO `destoon_area` VALUES ('136', '安庆市', '13', '0,13', '0', '136', '136');
INSERT INTO `destoon_area` VALUES ('137', '黄山市', '13', '0,13', '0', '137', '137');
INSERT INTO `destoon_area` VALUES ('138', '滁州市', '13', '0,13', '0', '138', '138');
INSERT INTO `destoon_area` VALUES ('139', '阜阳市', '13', '0,13', '0', '139', '139');
INSERT INTO `destoon_area` VALUES ('140', '宿州市', '13', '0,13', '0', '140', '140');
INSERT INTO `destoon_area` VALUES ('141', '巢湖市', '13', '0,13', '0', '141', '141');
INSERT INTO `destoon_area` VALUES ('142', '六安市', '13', '0,13', '0', '142', '142');
INSERT INTO `destoon_area` VALUES ('143', '亳州市', '13', '0,13', '0', '143', '143');
INSERT INTO `destoon_area` VALUES ('144', '池州市', '13', '0,13', '0', '144', '144');
INSERT INTO `destoon_area` VALUES ('145', '宣城市', '13', '0,13', '0', '145', '145');
INSERT INTO `destoon_area` VALUES ('146', '福州市', '14', '0,14', '0', '146', '146');
INSERT INTO `destoon_area` VALUES ('147', '厦门市', '14', '0,14', '0', '147', '147');
INSERT INTO `destoon_area` VALUES ('148', '莆田市', '14', '0,14', '0', '148', '148');
INSERT INTO `destoon_area` VALUES ('149', '三明市', '14', '0,14', '0', '149', '149');
INSERT INTO `destoon_area` VALUES ('150', '泉州市', '14', '0,14', '0', '150', '150');
INSERT INTO `destoon_area` VALUES ('151', '漳州市', '14', '0,14', '0', '151', '151');
INSERT INTO `destoon_area` VALUES ('152', '南平市', '14', '0,14', '0', '152', '152');
INSERT INTO `destoon_area` VALUES ('153', '龙岩市', '14', '0,14', '0', '153', '153');
INSERT INTO `destoon_area` VALUES ('154', '宁德市', '14', '0,14', '0', '154', '154');
INSERT INTO `destoon_area` VALUES ('155', '南昌市', '15', '0,15', '0', '155', '155');
INSERT INTO `destoon_area` VALUES ('156', '景德镇市', '15', '0,15', '0', '156', '156');
INSERT INTO `destoon_area` VALUES ('157', '萍乡市', '15', '0,15', '0', '157', '157');
INSERT INTO `destoon_area` VALUES ('158', '九江市', '15', '0,15', '0', '158', '158');
INSERT INTO `destoon_area` VALUES ('159', '新余市', '15', '0,15', '0', '159', '159');
INSERT INTO `destoon_area` VALUES ('160', '鹰潭市', '15', '0,15', '0', '160', '160');
INSERT INTO `destoon_area` VALUES ('161', '赣州市', '15', '0,15', '0', '161', '161');
INSERT INTO `destoon_area` VALUES ('162', '吉安市', '15', '0,15', '0', '162', '162');
INSERT INTO `destoon_area` VALUES ('163', '宜春市', '15', '0,15', '0', '163', '163');
INSERT INTO `destoon_area` VALUES ('164', '抚州市', '15', '0,15', '0', '164', '164');
INSERT INTO `destoon_area` VALUES ('165', '上饶市', '15', '0,15', '0', '165', '165');
INSERT INTO `destoon_area` VALUES ('166', '济南市', '16', '0,16', '0', '166', '166');
INSERT INTO `destoon_area` VALUES ('167', '青岛市', '16', '0,16', '0', '167', '167');
INSERT INTO `destoon_area` VALUES ('168', '淄博市', '16', '0,16', '0', '168', '168');
INSERT INTO `destoon_area` VALUES ('169', '枣庄市', '16', '0,16', '0', '169', '169');
INSERT INTO `destoon_area` VALUES ('170', '东营市', '16', '0,16', '0', '170', '170');
INSERT INTO `destoon_area` VALUES ('171', '烟台市', '16', '0,16', '0', '171', '171');
INSERT INTO `destoon_area` VALUES ('172', '潍坊市', '16', '0,16', '0', '172', '172');
INSERT INTO `destoon_area` VALUES ('173', '济宁市', '16', '0,16', '0', '173', '173');
INSERT INTO `destoon_area` VALUES ('174', '泰安市', '16', '0,16', '0', '174', '174');
INSERT INTO `destoon_area` VALUES ('175', '威海市', '16', '0,16', '0', '175', '175');
INSERT INTO `destoon_area` VALUES ('176', '日照市', '16', '0,16', '0', '176', '176');
INSERT INTO `destoon_area` VALUES ('177', '莱芜市', '16', '0,16', '0', '177', '177');
INSERT INTO `destoon_area` VALUES ('178', '临沂市', '16', '0,16', '0', '178', '178');
INSERT INTO `destoon_area` VALUES ('179', '德州市', '16', '0,16', '0', '179', '179');
INSERT INTO `destoon_area` VALUES ('180', '聊城市', '16', '0,16', '0', '180', '180');
INSERT INTO `destoon_area` VALUES ('181', '滨州市', '16', '0,16', '0', '181', '181');
INSERT INTO `destoon_area` VALUES ('182', '荷泽市', '16', '0,16', '0', '182', '182');
INSERT INTO `destoon_area` VALUES ('183', '郑州市', '17', '0,17', '0', '183', '183');
INSERT INTO `destoon_area` VALUES ('184', '开封市', '17', '0,17', '0', '184', '184');
INSERT INTO `destoon_area` VALUES ('185', '洛阳市', '17', '0,17', '0', '185', '185');
INSERT INTO `destoon_area` VALUES ('186', '平顶山市', '17', '0,17', '0', '186', '186');
INSERT INTO `destoon_area` VALUES ('187', '安阳市', '17', '0,17', '0', '187', '187');
INSERT INTO `destoon_area` VALUES ('188', '鹤壁市', '17', '0,17', '0', '188', '188');
INSERT INTO `destoon_area` VALUES ('189', '新乡市', '17', '0,17', '0', '189', '189');
INSERT INTO `destoon_area` VALUES ('190', '焦作市', '17', '0,17', '0', '190', '190');
INSERT INTO `destoon_area` VALUES ('191', '濮阳市', '17', '0,17', '0', '191', '191');
INSERT INTO `destoon_area` VALUES ('192', '许昌市', '17', '0,17', '0', '192', '192');
INSERT INTO `destoon_area` VALUES ('193', '漯河市', '17', '0,17', '0', '193', '193');
INSERT INTO `destoon_area` VALUES ('194', '三门峡市', '17', '0,17', '0', '194', '194');
INSERT INTO `destoon_area` VALUES ('195', '南阳市', '17', '0,17', '0', '195', '195');
INSERT INTO `destoon_area` VALUES ('196', '商丘市', '17', '0,17', '0', '196', '196');
INSERT INTO `destoon_area` VALUES ('197', '信阳市', '17', '0,17', '0', '197', '197');
INSERT INTO `destoon_area` VALUES ('198', '周口市', '17', '0,17', '0', '198', '198');
INSERT INTO `destoon_area` VALUES ('199', '驻马店市', '17', '0,17', '0', '199', '199');
INSERT INTO `destoon_area` VALUES ('200', '武汉市', '18', '0,18', '0', '200', '200');
INSERT INTO `destoon_area` VALUES ('201', '黄石市', '18', '0,18', '0', '201', '201');
INSERT INTO `destoon_area` VALUES ('202', '十堰市', '18', '0,18', '0', '202', '202');
INSERT INTO `destoon_area` VALUES ('203', '宜昌市', '18', '0,18', '0', '203', '203');
INSERT INTO `destoon_area` VALUES ('204', '襄樊市', '18', '0,18', '0', '204', '204');
INSERT INTO `destoon_area` VALUES ('205', '鄂州市', '18', '0,18', '0', '205', '205');
INSERT INTO `destoon_area` VALUES ('206', '荆门市', '18', '0,18', '0', '206', '206');
INSERT INTO `destoon_area` VALUES ('207', '孝感市', '18', '0,18', '0', '207', '207');
INSERT INTO `destoon_area` VALUES ('208', '荆州市', '18', '0,18', '0', '208', '208');
INSERT INTO `destoon_area` VALUES ('209', '黄冈市', '18', '0,18', '0', '209', '209');
INSERT INTO `destoon_area` VALUES ('210', '咸宁市', '18', '0,18', '0', '210', '210');
INSERT INTO `destoon_area` VALUES ('211', '随州市', '18', '0,18', '0', '211', '211');
INSERT INTO `destoon_area` VALUES ('212', '恩施土家族苗族自治州', '18', '0,18', '0', '212', '212');
INSERT INTO `destoon_area` VALUES ('213', '仙桃市', '18', '0,18', '0', '213', '213');
INSERT INTO `destoon_area` VALUES ('214', '潜江市', '18', '0,18', '0', '214', '214');
INSERT INTO `destoon_area` VALUES ('215', '天门市', '18', '0,18', '0', '215', '215');
INSERT INTO `destoon_area` VALUES ('216', '神农架林区', '18', '0,18', '0', '216', '216');
INSERT INTO `destoon_area` VALUES ('217', '长沙市', '19', '0,19', '0', '217', '217');
INSERT INTO `destoon_area` VALUES ('218', '株洲市', '19', '0,19', '0', '218', '218');
INSERT INTO `destoon_area` VALUES ('219', '湘潭市', '19', '0,19', '0', '219', '219');
INSERT INTO `destoon_area` VALUES ('220', '衡阳市', '19', '0,19', '0', '220', '220');
INSERT INTO `destoon_area` VALUES ('221', '邵阳市', '19', '0,19', '0', '221', '221');
INSERT INTO `destoon_area` VALUES ('222', '岳阳市', '19', '0,19', '0', '222', '222');
INSERT INTO `destoon_area` VALUES ('223', '常德市', '19', '0,19', '0', '223', '223');
INSERT INTO `destoon_area` VALUES ('224', '张家界市', '19', '0,19', '0', '224', '224');
INSERT INTO `destoon_area` VALUES ('225', '益阳市', '19', '0,19', '0', '225', '225');
INSERT INTO `destoon_area` VALUES ('226', '郴州市', '19', '0,19', '0', '226', '226');
INSERT INTO `destoon_area` VALUES ('227', '永州市', '19', '0,19', '0', '227', '227');
INSERT INTO `destoon_area` VALUES ('228', '怀化市', '19', '0,19', '0', '228', '228');
INSERT INTO `destoon_area` VALUES ('229', '娄底市', '19', '0,19', '0', '229', '229');
INSERT INTO `destoon_area` VALUES ('230', '湘西土家族苗族自治州', '19', '0,19', '0', '230', '230');
INSERT INTO `destoon_area` VALUES ('231', '广州市', '20', '0,20', '0', '231', '231');
INSERT INTO `destoon_area` VALUES ('232', '韶关市', '20', '0,20', '0', '232', '232');
INSERT INTO `destoon_area` VALUES ('233', '深圳市', '20', '0,20', '0', '233', '233');
INSERT INTO `destoon_area` VALUES ('234', '珠海市', '20', '0,20', '0', '234', '234');
INSERT INTO `destoon_area` VALUES ('235', '汕头市', '20', '0,20', '0', '235', '235');
INSERT INTO `destoon_area` VALUES ('236', '佛山市', '20', '0,20', '0', '236', '236');
INSERT INTO `destoon_area` VALUES ('237', '江门市', '20', '0,20', '0', '237', '237');
INSERT INTO `destoon_area` VALUES ('238', '湛江市', '20', '0,20', '0', '238', '238');
INSERT INTO `destoon_area` VALUES ('239', '茂名市', '20', '0,20', '0', '239', '239');
INSERT INTO `destoon_area` VALUES ('240', '肇庆市', '20', '0,20', '0', '240', '240');
INSERT INTO `destoon_area` VALUES ('241', '惠州市', '20', '0,20', '0', '241', '241');
INSERT INTO `destoon_area` VALUES ('242', '梅州市', '20', '0,20', '0', '242', '242');
INSERT INTO `destoon_area` VALUES ('243', '汕尾市', '20', '0,20', '0', '243', '243');
INSERT INTO `destoon_area` VALUES ('244', '河源市', '20', '0,20', '0', '244', '244');
INSERT INTO `destoon_area` VALUES ('245', '阳江市', '20', '0,20', '0', '245', '245');
INSERT INTO `destoon_area` VALUES ('246', '清远市', '20', '0,20', '0', '246', '246');
INSERT INTO `destoon_area` VALUES ('247', '东莞市', '20', '0,20', '0', '247', '247');
INSERT INTO `destoon_area` VALUES ('248', '中山市', '20', '0,20', '0', '248', '248');
INSERT INTO `destoon_area` VALUES ('249', '潮州市', '20', '0,20', '0', '249', '249');
INSERT INTO `destoon_area` VALUES ('250', '揭阳市', '20', '0,20', '0', '250', '250');
INSERT INTO `destoon_area` VALUES ('251', '云浮市', '20', '0,20', '0', '251', '251');
INSERT INTO `destoon_area` VALUES ('252', '南宁市', '21', '0,21', '0', '252', '252');
INSERT INTO `destoon_area` VALUES ('253', '柳州市', '21', '0,21', '0', '253', '253');
INSERT INTO `destoon_area` VALUES ('254', '桂林市', '21', '0,21', '0', '254', '254');
INSERT INTO `destoon_area` VALUES ('255', '梧州市', '21', '0,21', '0', '255', '255');
INSERT INTO `destoon_area` VALUES ('256', '北海市', '21', '0,21', '0', '256', '256');
INSERT INTO `destoon_area` VALUES ('257', '防城港市', '21', '0,21', '0', '257', '257');
INSERT INTO `destoon_area` VALUES ('258', '钦州市', '21', '0,21', '0', '258', '258');
INSERT INTO `destoon_area` VALUES ('259', '贵港市', '21', '0,21', '0', '259', '259');
INSERT INTO `destoon_area` VALUES ('260', '玉林市', '21', '0,21', '0', '260', '260');
INSERT INTO `destoon_area` VALUES ('261', '百色市', '21', '0,21', '0', '261', '261');
INSERT INTO `destoon_area` VALUES ('262', '贺州市', '21', '0,21', '0', '262', '262');
INSERT INTO `destoon_area` VALUES ('263', '河池市', '21', '0,21', '0', '263', '263');
INSERT INTO `destoon_area` VALUES ('264', '来宾市', '21', '0,21', '0', '264', '264');
INSERT INTO `destoon_area` VALUES ('265', '崇左市', '21', '0,21', '0', '265', '265');
INSERT INTO `destoon_area` VALUES ('266', '海口市', '22', '0,22', '0', '266', '266');
INSERT INTO `destoon_area` VALUES ('267', '三亚市', '22', '0,22', '0', '267', '267');
INSERT INTO `destoon_area` VALUES ('268', '五指山市', '22', '0,22', '0', '268', '268');
INSERT INTO `destoon_area` VALUES ('269', '琼海市', '22', '0,22', '0', '269', '269');
INSERT INTO `destoon_area` VALUES ('270', '儋州市', '22', '0,22', '0', '270', '270');
INSERT INTO `destoon_area` VALUES ('271', '文昌市', '22', '0,22', '0', '271', '271');
INSERT INTO `destoon_area` VALUES ('272', '万宁市', '22', '0,22', '0', '272', '272');
INSERT INTO `destoon_area` VALUES ('273', '东方市', '22', '0,22', '0', '273', '273');
INSERT INTO `destoon_area` VALUES ('274', '定安县', '22', '0,22', '0', '274', '274');
INSERT INTO `destoon_area` VALUES ('275', '屯昌县', '22', '0,22', '0', '275', '275');
INSERT INTO `destoon_area` VALUES ('276', '澄迈县', '22', '0,22', '0', '276', '276');
INSERT INTO `destoon_area` VALUES ('277', '临高县', '22', '0,22', '0', '277', '277');
INSERT INTO `destoon_area` VALUES ('278', '白沙黎族自治县', '22', '0,22', '0', '278', '278');
INSERT INTO `destoon_area` VALUES ('279', '昌江黎族自治县', '22', '0,22', '0', '279', '279');
INSERT INTO `destoon_area` VALUES ('280', '乐东黎族自治县', '22', '0,22', '0', '280', '280');
INSERT INTO `destoon_area` VALUES ('281', '陵水黎族自治县', '22', '0,22', '0', '281', '281');
INSERT INTO `destoon_area` VALUES ('282', '保亭黎族苗族自治县', '22', '0,22', '0', '282', '282');
INSERT INTO `destoon_area` VALUES ('283', '琼中黎族苗族自治县', '22', '0,22', '0', '283', '283');
INSERT INTO `destoon_area` VALUES ('284', '成都市', '23', '0,23', '0', '284', '284');
INSERT INTO `destoon_area` VALUES ('285', '自贡市', '23', '0,23', '0', '285', '285');
INSERT INTO `destoon_area` VALUES ('286', '攀枝花市', '23', '0,23', '0', '286', '286');
INSERT INTO `destoon_area` VALUES ('287', '泸州市', '23', '0,23', '0', '287', '287');
INSERT INTO `destoon_area` VALUES ('288', '德阳市', '23', '0,23', '0', '288', '288');
INSERT INTO `destoon_area` VALUES ('289', '绵阳市', '23', '0,23', '0', '289', '289');
INSERT INTO `destoon_area` VALUES ('290', '广元市', '23', '0,23', '0', '290', '290');
INSERT INTO `destoon_area` VALUES ('291', '遂宁市', '23', '0,23', '0', '291', '291');
INSERT INTO `destoon_area` VALUES ('292', '内江市', '23', '0,23', '0', '292', '292');
INSERT INTO `destoon_area` VALUES ('293', '乐山市', '23', '0,23', '0', '293', '293');
INSERT INTO `destoon_area` VALUES ('294', '南充市', '23', '0,23', '0', '294', '294');
INSERT INTO `destoon_area` VALUES ('295', '眉山市', '23', '0,23', '0', '295', '295');
INSERT INTO `destoon_area` VALUES ('296', '宜宾市', '23', '0,23', '0', '296', '296');
INSERT INTO `destoon_area` VALUES ('297', '广安市', '23', '0,23', '0', '297', '297');
INSERT INTO `destoon_area` VALUES ('298', '达州市', '23', '0,23', '0', '298', '298');
INSERT INTO `destoon_area` VALUES ('299', '雅安市', '23', '0,23', '0', '299', '299');
INSERT INTO `destoon_area` VALUES ('300', '巴中市', '23', '0,23', '0', '300', '300');
INSERT INTO `destoon_area` VALUES ('301', '资阳市', '23', '0,23', '0', '301', '301');
INSERT INTO `destoon_area` VALUES ('302', '阿坝藏族羌族自治州', '23', '0,23', '0', '302', '302');
INSERT INTO `destoon_area` VALUES ('303', '甘孜藏族自治州', '23', '0,23', '0', '303', '303');
INSERT INTO `destoon_area` VALUES ('304', '凉山彝族自治州', '23', '0,23', '0', '304', '304');
INSERT INTO `destoon_area` VALUES ('305', '贵阳市', '24', '0,24', '0', '305', '305');
INSERT INTO `destoon_area` VALUES ('306', '六盘水市', '24', '0,24', '0', '306', '306');
INSERT INTO `destoon_area` VALUES ('307', '遵义市', '24', '0,24', '0', '307', '307');
INSERT INTO `destoon_area` VALUES ('308', '安顺市', '24', '0,24', '0', '308', '308');
INSERT INTO `destoon_area` VALUES ('309', '铜仁地区', '24', '0,24', '0', '309', '309');
INSERT INTO `destoon_area` VALUES ('310', '黔西南布依族苗族自治州', '24', '0,24', '0', '310', '310');
INSERT INTO `destoon_area` VALUES ('311', '毕节地区', '24', '0,24', '0', '311', '311');
INSERT INTO `destoon_area` VALUES ('312', '黔东南苗族侗族自治州', '24', '0,24', '0', '312', '312');
INSERT INTO `destoon_area` VALUES ('313', '黔南布依族苗族自治州', '24', '0,24', '0', '313', '313');
INSERT INTO `destoon_area` VALUES ('314', '昆明市', '25', '0,25', '0', '314', '314');
INSERT INTO `destoon_area` VALUES ('315', '曲靖市', '25', '0,25', '0', '315', '315');
INSERT INTO `destoon_area` VALUES ('316', '玉溪市', '25', '0,25', '0', '316', '316');
INSERT INTO `destoon_area` VALUES ('317', '保山市', '25', '0,25', '0', '317', '317');
INSERT INTO `destoon_area` VALUES ('318', '昭通市', '25', '0,25', '0', '318', '318');
INSERT INTO `destoon_area` VALUES ('319', '丽江市', '25', '0,25', '0', '319', '319');
INSERT INTO `destoon_area` VALUES ('320', '思茅市', '25', '0,25', '0', '320', '320');
INSERT INTO `destoon_area` VALUES ('321', '临沧市', '25', '0,25', '0', '321', '321');
INSERT INTO `destoon_area` VALUES ('322', '楚雄彝族自治州', '25', '0,25', '0', '322', '322');
INSERT INTO `destoon_area` VALUES ('323', '红河哈尼族彝族自治州', '25', '0,25', '0', '323', '323');
INSERT INTO `destoon_area` VALUES ('324', '文山壮族苗族自治州', '25', '0,25', '0', '324', '324');
INSERT INTO `destoon_area` VALUES ('325', '西双版纳傣族自治州', '25', '0,25', '0', '325', '325');
INSERT INTO `destoon_area` VALUES ('326', '大理白族自治州', '25', '0,25', '0', '326', '326');
INSERT INTO `destoon_area` VALUES ('327', '德宏傣族景颇族自治州', '25', '0,25', '0', '327', '327');
INSERT INTO `destoon_area` VALUES ('328', '怒江傈僳族自治州', '25', '0,25', '0', '328', '328');
INSERT INTO `destoon_area` VALUES ('329', '迪庆藏族自治州', '25', '0,25', '0', '329', '329');
INSERT INTO `destoon_area` VALUES ('330', '拉萨市', '26', '0,26', '0', '330', '330');
INSERT INTO `destoon_area` VALUES ('331', '昌都地区', '26', '0,26', '0', '331', '331');
INSERT INTO `destoon_area` VALUES ('332', '山南地区', '26', '0,26', '0', '332', '332');
INSERT INTO `destoon_area` VALUES ('333', '日喀则地区', '26', '0,26', '0', '333', '333');
INSERT INTO `destoon_area` VALUES ('334', '那曲地区', '26', '0,26', '0', '334', '334');
INSERT INTO `destoon_area` VALUES ('335', '阿里地区', '26', '0,26', '0', '335', '335');
INSERT INTO `destoon_area` VALUES ('336', '林芝地区', '26', '0,26', '0', '336', '336');
INSERT INTO `destoon_area` VALUES ('337', '西安市', '27', '0,27', '0', '337', '337');
INSERT INTO `destoon_area` VALUES ('338', '铜川市', '27', '0,27', '0', '338', '338');
INSERT INTO `destoon_area` VALUES ('339', '宝鸡市', '27', '0,27', '0', '339', '339');
INSERT INTO `destoon_area` VALUES ('340', '咸阳市', '27', '0,27', '0', '340', '340');
INSERT INTO `destoon_area` VALUES ('341', '渭南市', '27', '0,27', '0', '341', '341');
INSERT INTO `destoon_area` VALUES ('342', '延安市', '27', '0,27', '0', '342', '342');
INSERT INTO `destoon_area` VALUES ('343', '汉中市', '27', '0,27', '0', '343', '343');
INSERT INTO `destoon_area` VALUES ('344', '榆林市', '27', '0,27', '0', '344', '344');
INSERT INTO `destoon_area` VALUES ('345', '安康市', '27', '0,27', '0', '345', '345');
INSERT INTO `destoon_area` VALUES ('346', '商洛市', '27', '0,27', '0', '346', '346');
INSERT INTO `destoon_area` VALUES ('347', '兰州市', '28', '0,28', '0', '347', '347');
INSERT INTO `destoon_area` VALUES ('348', '嘉峪关市', '28', '0,28', '0', '348', '348');
INSERT INTO `destoon_area` VALUES ('349', '金昌市', '28', '0,28', '0', '349', '349');
INSERT INTO `destoon_area` VALUES ('350', '白银市', '28', '0,28', '0', '350', '350');
INSERT INTO `destoon_area` VALUES ('351', '天水市', '28', '0,28', '0', '351', '351');
INSERT INTO `destoon_area` VALUES ('352', '武威市', '28', '0,28', '0', '352', '352');
INSERT INTO `destoon_area` VALUES ('353', '张掖市', '28', '0,28', '0', '353', '353');
INSERT INTO `destoon_area` VALUES ('354', '平凉市', '28', '0,28', '0', '354', '354');
INSERT INTO `destoon_area` VALUES ('355', '酒泉市', '28', '0,28', '0', '355', '355');
INSERT INTO `destoon_area` VALUES ('356', '庆阳市', '28', '0,28', '0', '356', '356');
INSERT INTO `destoon_area` VALUES ('357', '定西市', '28', '0,28', '0', '357', '357');
INSERT INTO `destoon_area` VALUES ('358', '陇南市', '28', '0,28', '0', '358', '358');
INSERT INTO `destoon_area` VALUES ('359', '临夏回族自治州', '28', '0,28', '0', '359', '359');
INSERT INTO `destoon_area` VALUES ('360', '甘南藏族自治州', '28', '0,28', '0', '360', '360');
INSERT INTO `destoon_area` VALUES ('361', '西宁市', '29', '0,29', '0', '361', '361');
INSERT INTO `destoon_area` VALUES ('362', '海东地区', '29', '0,29', '0', '362', '362');
INSERT INTO `destoon_area` VALUES ('363', '海北藏族自治州', '29', '0,29', '0', '363', '363');
INSERT INTO `destoon_area` VALUES ('364', '黄南藏族自治州', '29', '0,29', '0', '364', '364');
INSERT INTO `destoon_area` VALUES ('365', '海南藏族自治州', '29', '0,29', '0', '365', '365');
INSERT INTO `destoon_area` VALUES ('366', '果洛藏族自治州', '29', '0,29', '0', '366', '366');
INSERT INTO `destoon_area` VALUES ('367', '玉树藏族自治州', '29', '0,29', '0', '367', '367');
INSERT INTO `destoon_area` VALUES ('368', '海西蒙古族藏族自治州', '29', '0,29', '0', '368', '368');
INSERT INTO `destoon_area` VALUES ('369', '银川市', '30', '0,30', '0', '369', '369');
INSERT INTO `destoon_area` VALUES ('370', '石嘴山市', '30', '0,30', '0', '370', '370');
INSERT INTO `destoon_area` VALUES ('371', '吴忠市', '30', '0,30', '0', '371', '371');
INSERT INTO `destoon_area` VALUES ('372', '固原市', '30', '0,30', '0', '372', '372');
INSERT INTO `destoon_area` VALUES ('373', '中卫市', '30', '0,30', '0', '373', '373');
INSERT INTO `destoon_area` VALUES ('374', '乌鲁木齐市', '31', '0,31', '0', '374', '374');
INSERT INTO `destoon_area` VALUES ('375', '克拉玛依市', '31', '0,31', '0', '375', '375');
INSERT INTO `destoon_area` VALUES ('376', '吐鲁番地区', '31', '0,31', '0', '376', '376');
INSERT INTO `destoon_area` VALUES ('377', '哈密地区', '31', '0,31', '0', '377', '377');
INSERT INTO `destoon_area` VALUES ('378', '昌吉回族自治州', '31', '0,31', '0', '378', '378');
INSERT INTO `destoon_area` VALUES ('379', '博尔塔拉蒙古自治州', '31', '0,31', '0', '379', '379');
INSERT INTO `destoon_area` VALUES ('380', '巴音郭楞蒙古自治州', '31', '0,31', '0', '380', '380');
INSERT INTO `destoon_area` VALUES ('381', '阿克苏地区', '31', '0,31', '0', '381', '381');
INSERT INTO `destoon_area` VALUES ('382', '克孜勒苏柯尔克孜自治州', '31', '0,31', '0', '382', '382');
INSERT INTO `destoon_area` VALUES ('383', '喀什地区', '31', '0,31', '0', '383', '383');
INSERT INTO `destoon_area` VALUES ('384', '和田地区', '31', '0,31', '0', '384', '384');
INSERT INTO `destoon_area` VALUES ('385', '伊犁哈萨克自治州', '31', '0,31', '0', '385', '385');
INSERT INTO `destoon_area` VALUES ('386', '塔城地区', '31', '0,31', '0', '386', '386');
INSERT INTO `destoon_area` VALUES ('387', '阿勒泰地区', '31', '0,31', '0', '387', '387');
INSERT INTO `destoon_area` VALUES ('388', '石河子市', '31', '0,31', '0', '388', '388');
INSERT INTO `destoon_area` VALUES ('389', '阿拉尔市', '31', '0,31', '0', '389', '389');
INSERT INTO `destoon_area` VALUES ('390', '图木舒克市', '31', '0,31', '0', '390', '390');
INSERT INTO `destoon_area` VALUES ('391', '五家渠市', '31', '0,31', '0', '391', '391');

 




相关文章



我要评论


站长昵称:(*)

输入内容:


评论列表


高蒙

男,程序猿一枚

 

人生要是没有理想, 那跟一条咸鱼有什么分别。


关于我

  http://www.shuchengxian.com

高蒙个人博客是以PHP技术为主的程序员个人博客。博客主要发布php开发中遇到的问题以及解决办法,同时个人博客也分享网站模板素材,jquery插件等方面素材。


站点声明:相关侵权、举报、投诉及建议等,请发E-mail:936594075#qq.com(#替换成@)。

Copyright © 2018, www.shuchengxian.com, All rights reserved. 个人博客皖公网安备 34152302000022号 皖ICP备15015490号

关键词:个人博客,PHP博客,PHP博客程序,高蒙博客,高蒙个人博客,php程序员博客,程序员个人博客