/*
Navicat MySQL Data Transfer
Source Server : rm-bp1r0w4w223gh4eo8o.mysql.rds.aliyuncs.com_3306
Source Server Version : 50634
Source Host : rm-bp1r0w4w223gh4eo8o.mysql.rds.aliyuncs.com:3306
Source Database : baodaibao
Target Server Type : MYSQL
Target Server Version : 50634
File Encoding : 65001
Date: 2017-05-08 15:15:05
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for p_destrict_county
-- ----------------------------
DROP TABLE IF EXISTS `p_destrict_county`;
CREATE TABLE `p_destrict_county` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '区县id',
`province_id` int(11) NOT NULL COMMENT '省id',
`city_id` int(11) NOT NULL DEFAULT '0' COMMENT '市id',
`name` varchar(255) DEFAULT NULL COMMENT '区县名称',
`spell` varchar(255) DEFAULT NULL COMMENT '区县名称拼音',
`code` varchar(255) DEFAULT NULL COMMENT '区县代码',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注',
`status` int(3) NOT NULL DEFAULT '1' COMMENT '状态（0：删除，1：使用，2：禁用）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3150 DEFAULT CHARSET=utf8 COMMENT='区县表';
-- ----------------------------
-- Records of p_destrict_county
-- ----------------------------
INSERT INTO `p_destrict_county` VALUES ('1', '1', '0', '市辖区', 'Shixiaqu', '110100', null, '1');
INSERT INTO `p_destrict_county` VALUES ('2', '1', '0', '东城区', 'Dongcheng Qu', '110101', null, '1');
INSERT INTO `p_destrict_county` VALUES ('3', '1', '0', '西城区', 'Xicheng Qu', '110102', null, '1');
INSERT INTO `p_destrict_county` VALUES ('4', '1', '0', '朝阳区', 'Chaoyang Qu', '110105', null, '1');
INSERT INTO `p_destrict_county` VALUES ('5', '1', '0', '丰台区', 'Fengtai Qu', '110106', null, '1');
INSERT INTO `p_destrict_county` VALUES ('6', '1', '0', '石景山区', 'Shijingshan Qu', '110107', null, '1');
INSERT INTO `p_destrict_county` VALUES ('7', '1', '0', '海淀区', 'Haidian Qu', '110108', null, '1');
INSERT INTO `p_destrict_county` VALUES ('8', '1', '0', '门头沟区', 'Mentougou Qu', '110109', null, '1');
INSERT INTO `p_destrict_county` VALUES ('9', '1', '0', '房山区', 'Fangshan Qu', '110111', null, '1');
INSERT INTO `p_destrict_county` VALUES ('10', '1', '0', '通州区', 'Tongzhou Qu', '110112', null, '1');
INSERT INTO `p_destrict_county` VALUES ('11', '1', '0', '顺义区', 'Shunyi Qu', '110113', null, '1');
INSERT INTO `p_destrict_county` VALUES ('12', '1', '0', '昌平区', 'Changping Qu', '110114', null, '1');
INSERT INTO `p_destrict_county` VALUES ('13', '1', '0', '大兴区', 'Daxing Qu', '110115', null, '1');
INSERT INTO `p_destrict_county` VALUES ('14', '1', '0', '怀柔区', 'Huairou Qu', '110116', null, '1');
INSERT INTO `p_destrict_county` VALUES ('15', '1', '0', '平谷区', 'Pinggu Qu', '110117', null, '1');
INSERT INTO `p_destrict_county` VALUES ('16', '1', '0', '密云县', 'Miyun Xian ', '110228', null, '1');
INSERT INTO `p_destrict_county` VALUES ('17', '1', '0', '延庆县', 'Yanqing Xian', '110229', null, '1');
INSERT INTO `p_destrict_county` VALUES ('18', '2', '0', '市辖区', 'Shixiaqu', '120100', null, '1');
INSERT INTO `p_destrict_county` VALUES ('19', '2', '0', '和平区', 'Heping Qu', '120101', null, '1');
INSERT INTO `p_destrict_county` VALUES ('20', '2', '0', '河东区', 'Hedong Qu', '120102', null, '1');
INSERT INTO `p_destrict_county` VALUES ('21', '2', '0', '河西区', 'Hexi Qu', '120103', null, '1');
INSERT INTO `p_destrict_county` VALUES ('22', '2', '0', '南开区', 'Nankai Qu', '120104', null, '1');
INSERT INTO `p_destrict_county` VALUES ('23', '2', '0', '河北区', 'Hebei Qu', '120105', null, '1');
INSERT INTO `p_destrict_county` VALUES ('24', '2', '0', '红桥区', 'Hongqiao Qu', '120106', null, '1');
INSERT INTO `p_destrict_county` VALUES ('25', '2', '0', '东丽区', 'Dongli Qu', '120110', null, '1');
INSERT INTO `p_destrict_county` VALUES ('26', '2', '0', '西青区', 'Xiqing Qu', '120111', null, '1');
INSERT INTO `p_destrict_county` VALUES ('27', '2', '0', '津南区', 'Jinnan Qu', '120112', null, '1');
INSERT INTO `p_destrict_county` VALUES ('28', '2', '0', '北辰区', 'Beichen Qu', '120113', null, '1');
INSERT INTO `p_destrict_county` VALUES ('29', '2', '0', '武清区', 'Wuqing Qu', '120114', null, '1');
INSERT INTO `p_destrict_county` VALUES ('30', '2', '0', '宝坻区', 'Baodi Qu', '120115', null, '1');
INSERT INTO `p_destrict_county` VALUES ('31', '2', '0', '滨海新区', 'Dagang Qu', '120116', null, '1');
INSERT INTO `p_destrict_county` VALUES ('32', '2', '0', '宁河县', 'Ninghe Xian', '120221', null, '1');
INSERT INTO `p_destrict_county` VALUES ('33', '2', '0', '静海县', 'Jinghai Xian', '120223', null, '1');
INSERT INTO `p_destrict_county` VALUES ('34', '2', '0', '蓟县', 'Ji Xian', '120225', null, '1');
INSERT INTO `p_destrict_county` VALUES ('35', '3', '1', '市辖区', 'Shixiaqu', '130101', null, '1');
INSERT INTO `p_destrict_county` VALUES ('36', '3', '1', '长安区', 'Chang', '130102', null, '1');
INSERT INTO `p_destrict_county` VALUES ('37', '3', '1', '桥东区', 'Qiaodong Qu', '130103', null, '1');
INSERT INTO `p_destrict_county` VALUES ('38', '3', '1', '桥西区', 'Qiaoxi Qu', '130104', null, '1');
INSERT INTO `p_destrict_county` VALUES ('39', '3', '1', '新华区', 'Xinhua Qu', '130105', null, '1');
INSERT INTO `p_destrict_county` VALUES ('40', '3', '1', '井陉矿区', 'Jingxing Kuangqu', '130107', null, '1');
INSERT INTO `p_destrict_county` VALUES ('41', '3', '1', '裕华区', 'Yuhua Qu', '130108', null, '1');
INSERT INTO `p_destrict_county` VALUES ('42', '3', '1', '井陉县', 'Jingxing Xian', '130121', null, '1');
INSERT INTO `p_destrict_county` VALUES ('43', '3', '1', '正定县', 'Zhengding Xian', '130123', null, '1');
INSERT INTO `p_destrict_county` VALUES ('44', '3', '1', '栾城县', 'Luancheng Xian', '130124', null, '1');
INSERT INTO `p_destrict_county` VALUES ('45', '3', '1', '行唐县', 'Xingtang Xian', '130125', null, '1');
INSERT INTO `p_destrict_county` VALUES ('46', '3', '1', '灵寿县', 'Lingshou Xian ', '130126', null, '1');
INSERT INTO `p_destrict_county` VALUES ('47', '3', '1', '高邑县', 'Gaoyi Xian', '130127', null, '1');
INSERT INTO `p_destrict_county` VALUES ('48', '3', '1', '深泽县', 'Shenze Xian', '130128', null, '1');
INSERT INTO `p_destrict_county` VALUES ('49', '3', '1', '赞皇县', 'Zanhuang Xian', '130129', null, '1');
INSERT INTO `p_destrict_county` VALUES ('50', '3', '1', '无极县', 'Wuji Xian', '130130', null, '1');
INSERT INTO `p_destrict_county` VALUES ('51', '3', '1', '平山县', 'Pingshan Xian', '130131', null, '1');
INSERT INTO `p_destrict_county` VALUES ('52', '3', '1', '元氏县', 'Yuanshi Xian', '130132', null, '1');
INSERT INTO `p_destrict_county` VALUES ('53', '3', '1', '赵县', 'Zhao Xian', '130133', null, '1');
INSERT INTO `p_destrict_county` VALUES ('54', '3', '1', '辛集市', 'Xinji Shi', '130181', null, '1');
INSERT INTO `p_destrict_county` VALUES ('55', '3', '1', '藁城市', 'Gaocheng Shi', '130182', null, '1');
INSERT INTO `p_destrict_county` VALUES ('56', '3', '1', '晋州市', 'Jinzhou Shi', '130183', null, '1');
INSERT INTO `p_destrict_county` VALUES ('57', '3', '1', '新乐市', 'Xinle Shi', '130184', null, '1');
INSERT INTO `p_destrict_county` VALUES ('58', '3', '1', '鹿泉市', 'Luquan Shi', '130185', null, '1');
INSERT INTO `p_destrict_county` VALUES ('59', '3', '2', '市辖区', 'Shixiaqu', '130201', null, '1');
INSERT INTO `p_destrict_county` VALUES ('60', '3', '2', '路南区', 'Lunan Qu', '130202', null, '1');
INSERT INTO `p_destrict_county` VALUES ('61', '3', '2', '路北区', 'Lubei Qu', '130203', null, '1');
INSERT INTO `p_destrict_county` VALUES ('62', '3', '2', '古冶区', 'Guye Qu', '130204', null, '1');
INSERT INTO `p_destrict_county` VALUES ('63', '3', '2', '开平区', 'Kaiping Qu', '130205', null, '1');
INSER
全国省市区县数据库下载
5星 · 超过95%的资源 需积分: 48 73 浏览量
2017-05-08
15:58:11
上传
评论 3
收藏 253KB ZIP 举报 
全国省市区县数据库.zip （6个子文件） 
全国省市区县数据库 
province.xlsx 12KB city.xlsx 25KB
destrict_county.sql 346KB destrict_county.xlsx 170KB city.sql 33KB province.sql 5KB资源评论
yan_xi_zao2017-11-03少数据，数据机构不错
qwfys2002020-10-29除了数据少以外，其他的还好
