-
省级、市级、县级、镇级、村级中国五级行政区划的MySQL完整数据-SQL文件
资源介绍
中国五级省市县镇村的MySQL完整数据，已经做成SQL文件，带建表语句
/*
Navicat MySQL Data Transfer
Target Server Type : MYSQL
Target Server Version : 50612
File Encoding : 65001
Date: 2017-03-07 16:05:36
*/
DROP TABLE IF EXISTS `thk_position`;
CREATE TABLE `thk_position` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`province_id` bigint(20) unsigned NOT NULL,
`province_name` char(64) NOT NULL,
`city_id` bigint(20) unsigned NOT NULL,
`city_name` char(64) NOT NULL,
`county_id` bigint(20) unsigned NOT NULL,
`county_name` char(64) NOT NULL,
`town_id` bigint(20) unsigned NOT NULL,
`town_name` char(64) NOT NULL,
`village_id` bigint(20) unsigned NOT NULL,
`village_name` char(64) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `village_id` (`village_id`),
KEY `province_id` (`province_id`) USING BTREE,
KEY `city_id` (`city_id`) USING BTREE,
KEY `town_id` (`town_id`) USING BTREE,
KEY `county_id` (`county_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=693338 DEFAULT CHARSET=utf8 COMMENT='省市县镇村数据';
INSERT INTO `thk_position` VALUES ('1', '110', '北京市', '110100000000', '市辖区', '110101000000', '东城区', '110101001000', '东华门街道办事处', '110101001001', '多福巷社区');