全国省市县（区）镇村，通用sql,

/* SQLyog Ultimate v11.27 (64 bit) MySQL - 5.0.77 : Database - gfh ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*Table structure for table `area` */ DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` int(11) NOT NULL auto_increment, `area_id` varchar(11) default NULL, `area_pid` varchar(11) default NULL, `area_text` varchar(50) default NULL, `level` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=766963 DEFAULT CHARSET=utf8 COMMENT='全国省市区街道'; /*Data for the table `area` */ insert into `area`(`id`,`area_id`,`area_pid`,`area_text`,`level`) values (1,'11','0','北京市',1),(2,'1101','11','市辖区',2),(3,'110101','1101','东城区',3),(4,'110101001','110101','东华门街道',4),(5,'110101002','110101','景山街道',4),(6,'110101003','110101','交道口街道',4),(7,'110101004','110101','安定门街道',4),(8,'110101005','110101','北新桥街道',4),(9,'110101006','110101','东四街道',4),(10,'110101007','110101','朝阳门街道',4),(11,'110101008','110101','建国门街道',4),(12,'110101009','110101','东直门街道',4),(13,'110101010','110101','和平里街道',4),(14,'110102','1101','西城区',3),(15,'110102001','110102','西长安街街道',4),(16,'110102003','110102','新街口街道',4),(17,'110102007','110102','月坛街道',4),(18,'110102009','110102','展览路街道',4),(19,'110102010','110102','德胜街道',4),(20,'110102011','110102','金融街街道',4),(21,'110102012','110102','什刹海街道',4),(22,'110103','1101','崇文区',3),(23,'110103001','110103','前门街道',4),(24,'110103002','110103','崇文门外街道',4),(25,'110103003','110103','东花市街道',4),(26,'110103004','110103','龙潭街道',4),(27,'110103005','110103','体育馆路街道',4),(28,'110103006','110103','天坛街道',4),(29,'110103007','110103','永定门外街道',4),(30,'110104','1101','宣武区',3),(31,'110104001','110104','大栅栏街道',4),(32,'110104002','110104','天桥街道',4),(33,'110104003','110104','椿树街道',4),(34,'110104004','110104','陶然亭街道',4),(35,'110104005','110104','广安门内街道',4),(36,'110104006','110104','牛街街道',4),(37,'110104007','110104','白纸坊街道',4),(38,'110104008','110104','广安门外街道',4),(39,'110105','1101','朝阳区',3),(40,'110105001','110105','建外街道',4),(41,'110105002','110105','朝外街道',4),(42,'110105003','110105','呼家楼街道',4),(43,'110105004','110105','三里屯街道',4),(44,'110105005','110105','左家庄街道',4),(45,'110105006','110105','香河园街道',4),(46,'110105007','110105','和平街街道',4),(47,'110105008','110105','安贞街道',4),(48,'110105009','110105','亚运村街道',4),(49,'110105010','110105','小关街道',4),(50,'110105011','110105','酒仙桥街道',4),(51,'110105012','110105','麦子店街道',4),(52,'110105013','110105','团结湖街道',4),(53,'110105014','110105','六里屯街道',4),(54,'110105015','110105','八里庄街道',4),(55,'110105016','110105','双井街道',4),(56,'110105017','110105','劲松街道',4),(57,'110105018','110105','潘家园街道',4),(58,'110105019','110105','垡头街道',4),(59,'110105021','110105','南磨房地区',4),(60,'110105022','110105','高碑店地区',4),(61,'110105023','110105','将台地区',4),(62,'110105024','110105','太阳宫地区',4),(63,'110105025','110105','大屯街道',4),(64,'110105026','110105','望京街道',4),(65,'110105027','110105','小红门地区',4),(66,'110105028','110105','十八里店地区',4),(67,'110105029','110105','平房地区',4),(68,'110105030','110105','东风地区',4),(69,'110105031','110105','奥运村地区',4),(70,'110105032','110105','来广营地区',4),(71,'110105033','110105','常营回族地区',4),(72,'110105034','110105','三间房地区',4),(73,'110105035','110105','管庄地区',4),(74,'110105036','110105','金盏地区',4),(75,'110105037','110105','孙河地区',4),(76,'110105038','110105','崔各庄地区',4),(77,'110105039','110105','东坝地区',4),(78,'110105040','110105','黑庄户地区',4),(79,'110105041','110105','豆各庄地区',4),(80,'110105042','110105','王四营地区',4),(81,'110105400','110105','首都机场街道',4),(82,'110105501','110105','望京开发街道',4),(83,'110106','1101','丰台区',3),(84,'110106001','110106','右安门街道',4),(85,'110106002','110106','太平桥街道',4),(86,'110106003','110106','西罗园街道',4),(87,'110106004','110106','大红门街道',4),(88,'110106005','110106','南苑街道',4),(89,'110106006','110106','东高地街道',4),(90,'110106007','110106','东铁匠营街道',4),(91,'110106008','110106','卢沟桥街道',4),(92,'110106009','110106','丰台街道',4),(93,'110106010','110106','新村街道',4),(94,'110106011','110106','长辛店街道',4),(95,'110106012','110106','云岗街道',4),(96,'110106013','110106','方庄地区',4),(97,'110106014','110106','宛平城地区',4),(98,'110106015','110106','马家堡街道',4),(99,'110106016','110106','和义街道',4),(100,'110106100','110106','长辛店镇',4),(101,'110106101','110106','王佐镇',4),(102,'110106201','110106','卢沟桥乡',4),(103,'110106202','110106','花乡',4),(104,'110106203','110106','南苑乡',4),(105,'110107','1101','石景山区',3),(106,'110107001','110107','八宝山街道',4),(107,'110107002','110107','老山街道',4),(108,'110107003','110107','八角街道',4),(109,'110107004','110107','古城街道',4),(110,'110107005','110107','苹果园街道',4),(111,'110107006','110107','金顶街街道',4),(112,'110107009','110107','广宁街道',4),(113,'110107010','110107','五里坨街道',4),(114,'110107011','110107','鲁谷社区行政事务管理中心',4),(115,'110108','1101','海淀区',3),(116,'110108001','110108','万寿路街道',4),(117,'110108002','110108','永定路街道',4),(118,'110108003','110108','羊坊店街道',4),(119,'110108004','110108','甘家口街道',4),(120,'110108005','110108','八里庄街道',4),(121,'110108006','110108','紫竹院街道',4),(122,'110108007','110108','北下关街道',4),(123,'110108008','110108','北太平庄街道',4),(124,'110108010','110108','学院路街道',4),(125,'110108011','110108','中关村街道',4),(126,'110108012','110108','海淀街道',4),(127,'110108013','110108','青龙桥街道',4),(128,'110108014','110108','清华园街道',4),(129,'110108015','110108','燕园街道',4),(130,'110108016','110108','香山街道',4),(131,'110108017','110108','清河街道',4),(132,'110108018','110108','花园路街道',4),(133,'110108019','110108','西三旗街道',4),(134,'110108020','110108','马连洼街道',4),(135,'110108021','110108','田村路街道',4),(136,'110108022','110108','上地街道',4),(137,'110108023','110108','万柳地区',4),(138,'110108024','110108','东升地区',4),(139,'110108025','110108','曙光街道',4),(140,'110108101','110108','温泉镇',4),(141,'110108102','110108','四季青镇',4),(142,'110108103','110108','西北旺镇',4),(143,'110108104','110108','苏家坨镇',4),(144,'110108105','110108','上庄镇',4),(145,'110109','1101','门头沟区',3),(146,'110109001','110109','大峪街道',4),(147,'110109002','110109','城子街道',4),(148,'110109003','110109','东辛房街道',4),(149,'110109004','110109','大台街道',4),(150,'110109005','110109','王平地区',4),(151,'110109101','110109','潭柘寺镇',4),(152,'110109102','110109','永定镇',4),(153,'110109103','110109','龙泉镇',4),(154,'110109104','110109','军庄镇',4),(155,'110109105','110109','雁翅镇',4),(156,'110109106','110109','斋堂镇',4),(157,'110109107','110109','清水镇',4),(158,'11010