全国地址SQL数据文件（精确到区县）

全国地址SQL数据文件（精确到区县）

导出自MySQL

CREATE TABLE `com_area` (  `id` bigint(20) NOT NULL AUTO_INCREMENT,  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,  `last_modified_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,  `display_order` int(11) DEFAULT NULL,  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,  `pid` bigint(20) DEFAULT NULL,  PRIMARY KEY (`id`),  KEY `FK_Reference_02` (`pid`),  CONSTRAINT `com_area_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `com_area` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=3924 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;-- ------------------------------ Records of com_area-- ----------------------------INSERT INTO `com_area` VALUES ('1', '2016-10-29 08:07:39', '2016-10-29 08:07:39', '0', '1', null);INSERT INTO `com_area` VALUES ('2', '2016-10-29 08:07:44', '2016-10-29 08:07:44', '110000', '北京市', '1');INSERT INTO `com_area` VALUES ('3', '2016-10-29 08:07:44', '2016-10-29 08:07:44', '110101', '东城区', '2');......
下载地址：
http://download.csdn.net/detail/wangfei0904306/9748322