全国地址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