2018全国省市县乡最新数据库/MYsql/ACCESS资源-CSDN文库

共3个文件

sql：2个

accdb：1个

2018

省市县乡

需积分: 13 57 浏览量 2018-08-04 00:01:15 上传评论收藏 1.31MB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

SHENGSHIXIANXIANG.rar （3个子文件）

shengshishujukuMYSQL.SQL 3.84MB

MYSQL_OUTPUT.sql 4.08MB

position.accdb 4.95MB

# Host: localhost (Version: 5.5.53) # Date: 2018-08-03 23:49:42 # Generator: MySQL-Front 5.3 (Build 4.234) /*!40101 SET NAMES utf8 */; # # Structure for table "position" # CREATE TABLE `position` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `province_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `province_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `city_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `city_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `county_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `county_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `town_id` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `town_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM AUTO_INCREMENT=13008 DEFAULT CHARSET=latin1; # # Data for table "position" # INSERT INTO `position` VALUES (1,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL),(2,'11','北京市','1101','市辖区','110101','东城区','110101001','东华门街道办事处'),(3,'11','北京市','1101','市辖区','110101','东城区','110101002','景山街道办事处'),(4,'11','北京市','1101','市辖区','110101','东城区','110101003','交道口街道办事处'),(5,'11','北京市','1101','市辖区','110101','东城区','110101004','安定门街道办事处'),(6,'11','北京市','1101','市辖区','110101','东城区','110101005','北新桥街道办事处'),(7,'11','北京市','1101','市辖区','110101','东城区','110101006','东四街道办事处'),(8,'11','北京市','1101','市辖区','110101','东城区','110101007','朝阳门街道办事处'),(9,'11','北京市','1101','市辖区','110101','东城区','110101008','建国门街道办事处'),(10,'11','北京市','1101','市辖区','110101','东城区','110101009','东直门街道办事处'),(11,'11','北京市','1101','市辖区','110101','东城区','110101010','和平里街道办事处'),(12,'11','北京市','1101','市辖区','110101','东城区','110101011','前门街道办事处'),(13,'11','北京市','1101','市辖区','110101','东城区','110101012','崇文门外街道办事处'),(14,'11','北京市','1101','市辖区','110101','东城区','110101013','东花市街道办事处'),(15,'11','北京市','1101','市辖区','110101','东城区','110101014','龙潭街道办事处'),(16,'11','北京市','1101','市辖区','110101','东城区','110101015','体育馆路街道办事处'),(17,'11','北京市','1101','市辖区','110101','东城区','110101016','天坛街道办事处'),(18,'11','北京市','1101','市辖区','110101','东城区','110101017','永定门外街道办事处'),(19,'11','北京市','1101','市辖区','110102','西城区','110102001','西长安街街道办事处'),(20,'11','北京市','1101','市辖区','110102','西城区','110102003','新街口街道办事处'),(21,'11','北京市','1101','市辖区','110102','西城区','110102007','月坛街道办事处'),(22,'11','北京市','1101','市辖区','110102','西城区','110102009','展览路街道办事处'),(23,'11','北京市','1101','市辖区','110102','西城区','110102010','德胜街道办事处'),(24,'11','北京市','1101','市辖区','110102','西城区','110102011','金融街街道办事处'),(25,'11','北京市','1101','市辖区','110102','西城区','110102012','什刹海街道办事处'),(26,'11','北京市','1101','市辖区','110102','西城区','110102013','大栅栏街道办事处'),(27,'11','北京市','1101','市辖区','110102','西城区','110102014','天桥街道办事处'),(28,'11','北京市','1101','市辖区','110102','西城区','110102015','椿树街道办事处'),(29,'11','北京市','1101','市辖区','110102','西城区','110102016','陶然亭街道办事处'),(30,'11','北京市','1101','市辖区','110102','西城区','110102017','广安门内街道办事处'),(31,'11','北京市','1101','市辖区','110102','西城区','110102018','牛街街道办事处'),(32,'11','北京市','1101','市辖区','110102','西城区','110102019','白纸坊街道办事处'),(33,'11','北京市','1101','市辖区','110102','西城区','110102020','广安门外街道办事处'),(34,'11','北京市','1101','市辖区','110105','朝阳区','110105001','建外街道办事处'),(35,'11','北京市','1101','市辖区','110105','朝阳区','110105002','朝外街道办事处'),(36,'11','北京市','1101','市辖区','110105','朝阳区','110105003','呼家楼街道办事处'),(37,'11','北京市','1101','市辖区','110105','朝阳区','110105004','三里屯街道办事处'),(38,'11','北京市','1101','市辖区','110105','朝阳区','110105005','左家庄街道办事处'),(39,'11','北京市','1101','市辖区','110105','朝阳区','110105006','香河园街道办事处'),(40,'11','北京市','1101','市辖区','110105','朝阳区','110105007','和平街街道办事处'),(41,'11','北京市','1101','市辖区','110105','朝阳区','110105008','安贞街道办事处'),(42,'11','北京市','1101','市辖区','110105','朝阳区','110105009','亚运村街道办事处'),(43,'11','北京市','1101','市辖区','110105','朝阳区','110105010','小关街道办事处'),(44,'11','北京市','1101','市辖区','110105','朝阳区','110105011','酒仙桥街道办事处'),(45,'11','北京市','1101','市辖区','110105','朝阳区','110105012','麦子店街道办事处'),(46,'11','北京市','1101','市辖区','110105','朝阳区','110105013','团结湖街道办事处'),(47,'11','北京市','1101','市辖区','110105','朝阳区','110105014','六里屯街道办事处'),(48,'11','北京市','1101','市辖区','110105','朝阳区','110105015','八里庄街道办事处'),(49,'11','北京市','1101','市辖区','110105','朝阳区','110105016','双井街道办事处'),(50,'11','北京市','1101','市辖区','110105','朝阳区','110105017','劲松街道办事处'),(51,'11','北京市','1101','市辖区','110105','朝阳区','110105018','潘家园街道办事处'),(52,'11','北京市','1101','市辖区','110105','朝阳区','110105019','垡头街道办事处'),(53,'11','北京市','1101','市辖区','110105','朝阳区','110105021','南磨房地区办事处'),(54,'11','北京市','1101','市辖区','110105','朝阳区','110105022','高碑店地区办事处'),(55,'11','北京市','1101','市辖区','110105','朝阳区','110105023','将台地区办事处'),(56,'11','北京市','1101','市辖区','110105','朝阳区','110105024','太阳宫地区办事处'),(57,'11','北京市','1101','市辖区','110105','朝阳区','110105025','大屯街道办事处'),(58,'11','北京市','1101','市辖区','110105','朝阳区','110105026','望京街道办事处'),(59,'11','北京市','1101','市辖区','110105','朝阳区','110105027','小红门地区办事处'),(60,'11','北京市','1101','市辖区','110105','朝阳区','110105028','十八里店地区办事处'),(61,'11','北京市','1101','市辖区','110105','朝阳区','110105029','平房地区办事处'),(62,'11','北京市','1101','市辖区','110105','朝阳区','110105030','东风地区办事处'),(63,'11','北京市','1101','市辖区','110105','朝阳区','110105031','奥运村街道办事处'),(64,'11','北京市','1101','市辖区','110105','朝阳区','110105032','来广营地区办事处'),(65,'11','北京市','1101','市辖区','110105','朝阳区','110105033','常营地区办事处'),(66,'11','北京市','1101','市辖区','110105','朝阳区','110105034','三间房地区办事处'),(67,'11','北京市','1101','市辖区','110105','朝阳区','110105035','管庄地区办事处'),(68,'11','北京市','1101','市辖区','110105','朝阳区','110105036','金盏地区办事处'),(69,'11','北京市','1101','市辖区','110105','朝阳区','110105037','孙河地区办事处'),(70,'11','北京市','1101','市辖区','110105','朝阳区','110105038','崔各庄地区办事处'),(71,'11','北京市','1101','市辖区','110105','朝阳区','110105039','东坝地区办事处'),(72,'11','北京市','1101','市辖区','110105','朝阳区','110

评论收藏

内容反馈