中国省市区三级数据库表.sql

# MySQL-Front 5.1 (Build 2.7) /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */; /*!40101 SET SQL_MODE='' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */; /*!40103 SET SQL_NOTES='ON' */; # Host: localhost Database: iptoBASE_PROVINCECITYAREA # ------------------------------------------------------ # Server version 5.0.26 # # Source for table BASE_PROVINCECITYAREA # CREATE TABLE BASE_PROVINCECITYAREA ( id int(11) NOT NULL auto_increment, areaID varchar(50) default NULL, area varchar(60) default NULL, father varchar(6) default NULL, primary key(id) ) ENGINE=MyISAM AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8; # # Dumping data for table BASE_PROVINCECITYAREA # INSERT INTO BASE_PROVINCECITYAREA VALUES (1,'110101','东城区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (2,'110102','西城区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (3,'110103','崇文区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (4,'110104','宣武区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (5,'110105','朝阳区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (6,'110106','丰台区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (7,'110107','石景山区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (8,'110108','海淀区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (9,'110109','门头沟区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (10,'110111','房山区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (11,'110112','通州区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (12,'110113','顺义区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (13,'110114','昌平区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (14,'1101','大兴区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (,'110116','怀柔区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (16,'110117','平谷区','110100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (18,'110229','延庆县','110200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (19,'120101','和平区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (20,'120102','河东区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (21,'120103','河西区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (22,'120104','南开区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (23,'120105','河北区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (24,'120106','红桥区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (25,'120107','塘沽区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (26,'120108','汉沽区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (27,'120109','大港区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (28,'120110','东丽区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (29,'120111','西青区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (30,'120112','津南区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (31,'120113','北辰区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (32,'120114','武清区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (33,'1201','宝坻区','120100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (34,'120221','宁河县','120200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (35,'120223','静海县','120200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (36,'120225','蓟县','120200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (37,'130101','市辖区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (38,'130102','长安区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (39,'130103','桥东区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (40,'130104','桥西区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (41,'130105','新华区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (42,'130107','井陉矿区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (43,'130108','裕华区','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (44,'130121','井陉县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (45,'130123','正定县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (46,'130124','栾城县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (47,'130125','行唐县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (48,'130126','灵寿县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (49,'130127','高邑县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (50,'130128','深泽县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (51,'130129','赞皇县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (52,'130130','无极县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (53,'130131','平山县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (54,'130132','元氏县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (55,'130133','赵县','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (56,'130181','辛集市','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (57,'130182','藁城市','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (58,'130183','晋州市','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (59,'130184','新乐市','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (60,'130185','鹿泉市','130100',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (62,'130202','路南区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (63,'130203','路北区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (64,'130204','古冶区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (65,'130205','开平区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (66,'130207','丰南区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (67,'130208','丰润区','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (68,'130223','滦县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (69,'130224','滦南县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (70,'130225','乐亭县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (71,'130227','迁西县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (72,'130229','玉田县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (73,'130230','唐海县','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (74,'130281','遵化市','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (75,'130283','迁安市','130200',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (76,'130301','市辖区','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (77,'130302','海港区','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (78,'130303','山海关区','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (79,'130304','北戴河区','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (80,'130321','青龙满族自治县','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (81,'130322','昌黎县','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (82,'130323','抚宁县','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (83,'130324','卢龙县','130300',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (84,'130401','市辖区','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (85,'130402','邯山区','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (86,'130403','丛台区','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (87,'130404','复兴区','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (88,'130406','峰峰矿区','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (89,'130421','邯郸县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (90,'130423','临漳县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (91,'130424','成安县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (92,'130425','大名县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (93,'130426','涉县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (94,'130427','磁县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (95,'130428','肥乡县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (96,'130429','永年县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (97,'130430','邱县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (98,'130431','鸡泽县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (99,'130432','广平县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (100,'130433','馆陶县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (101,'130434','魏县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (102,'130435','曲周县','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (103,'130481','武安市','130400',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (104,'130501','市辖区','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (106,'130503','桥西区','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (107,'130521','邢台县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (108,'130522','临城县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (109,'130523','内丘县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (110,'130524','柏乡县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (111,'130525','隆尧县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (112,'130526','任县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (113,'130527','南和县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (114,'130528','宁晋县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (1,'130529','巨鹿县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (116,'130530','新河县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (117,'130531','广宗县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (118,'130532','平乡县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (119,'130533','威县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (120,'130534','清河县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (121,'130535','临西县','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (122,'130581','南宫市','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (123,'130582','沙河市','130500',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (124,'130601','市辖区','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (125,'130602','新市区','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (126,'130603','北市区','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (127,'130604','南市区','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (128,'130621','满城县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (129,'130622','清苑县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (130,'130623','涞水县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (131,'130624','阜平县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (132,'130625','徐水县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (133,'130626','定兴县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (134,'130627','唐县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (135,'130628','高阳县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (136,'130629','容城县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (137,'130630','涞源县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (138,'130631','望都县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (139,'130632','安新县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (140,'130633','易县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (141,'130634','曲阳县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (142,'130635','蠡县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (143,'130636','顺平县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (144,'130637','博野县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (145,'130638','雄县','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (146,'130681','涿州市','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (147,'130682','定州市','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (148,'130683','安国市','130600',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (0,'130701','市辖区','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (1,'130702','桥东区','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (2,'130703','桥西区','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (3,'130705','宣化区','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (4,'130706','下花园区','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (5,'130721','宣化县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (6,'130722','张北县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (7,'130723','康保县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (8,'130724','沽源县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (9,'130725','尚义县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (160,'130726','蔚县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (161,'130727','阳原县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (162,'130728','怀安县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (163,'130729','万全县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (164,'130730','怀来县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (165,'130731','涿鹿县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (166,'130732','赤城县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (167,'130733','崇礼县','130700',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (168,'130801','市辖区','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (169,'130802','双桥区','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (170,'130803','双滦区','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (171,'130804','鹰手营子矿区','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (172,'130821','承德县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (173,'130822','兴隆县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (174,'130823','平泉县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (175,'130824','滦平县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (176,'130825','隆化县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (177,'130826','丰宁满族自治县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (178,'130827','宽城满族自治县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (179,'130828','围场满族蒙古族自治县','130800',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (180,'130901','市辖区','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (181,'130902','新华区','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (182,'130903','运河区','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (183,'130921','沧县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (184,'130922','青县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (185,'130923','东光县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (186,'130924','海兴县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (187,'130925','盐山县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (188,'130926','肃宁县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (189,'130927','南皮县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (190,'130928','吴桥县','130900',0); INSERT INTO BASE_PROVINCECITYAREA VALUES (191,'130929','献县','130900',0); 继续阅读