全国省市县SQL数据库(大全)

全国省市区数据SQL-省市区

全国省市区数据SQL-省市区1 DROP TABLE IF EXISTS `provinces`;2 CREATE TABLE `provinces` (3 `id` int(11) NOT NULL auto_increment,4 `provinceid` varchar(20) NOT NULL,5 `province` varchar(50) NOT NULL,6 PRIMARY KEY (`id`)7 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='省份信息表';8910 insert into provinces(id,provinceid,province) values(1,'110000','北京市');11 insert into provinces(id,provinceid,province) values(2,'120000','天津市');12 insert into provinces(id,provinceid,province) values(3,'130000','河北省');13 insert into provinces(id,provinceid,province) values(4,'140000','⼭西省');14 insert into provinces(id,provinceid,province) values(5,'150000','内蒙古⾃治区');15 insert into provinces(id,provinceid,province) values(6,'210000','辽宁省');16 insert into provinces(id,provinceid,province) values(7,'220000','吉林省');17 insert into provinces(id,provinceid,province) values(8,'230000','⿊龙江省');18 insert into provinces(id,provinceid,province) values(9,'310000','上海市');19 insert into provinces(id,provinceid,province) values(10,'320000','江苏省');20 insert into provinces(id,provinceid,province) values(11,'330000','浙江省');21 insert into provinces(id,provinceid,province) values(12,'340000','安徽省');22 insert into provinces(id,provinceid,province) values(13,'350000','福建省');23 insert into provinces(id,provinceid,province) values(14,'360000','江西省');24 insert into provinces(id,provinceid,province) values(15,'370000','⼭东省');25 insert into provinces(id,provinceid,province) values(16,'410000','河南省');26 insert into provinces(id,provinceid,province) values(17,'420000','湖北省');27 insert into provinces(id,provinceid,province) values(18,'430000','湖南省');28 insert into provinces(id,provinceid,province) values(19,'440000','⼴东省');29 insert into provinces(id,provinceid,province) values(20,'450000','⼴西壮族⾃治区');30 insert into provinces(id,provinceid,province) values(21,'460000','海南省');31 insert into provinces(id,provinceid,province) values(22,'500000','重庆市');32 insert into provinces(id,provinceid,province) values(23,'510000','四川省');33 insert into provinces(id,provinceid,province) values(24,'520000','贵州省');34 insert into provinces(id,provinceid,province) values(25,'530000','云南省');35 insert into provinces(id,provinceid,province) values(26,'540000','西藏⾃治区');36 insert into provinces(id,provinceid,province) values(27,'610000','陕西省');37 insert into provinces(id,provinceid,province) values(28,'620000','⽢肃省');38 insert into provinces(id,provinceid,province) values(29,'630000','青海省');39 insert into provinces(id,provinceid,province) values(30,'640000','宁夏回族⾃治区');40 insert into provinces(id,provinceid,province) values(31,'650000','新疆维吾尔⾃治区');41 insert into provinces(id,provinceid,province) values(32,'710000','台湾省');42 insert into provinces(id,provinceid,province) values(33,'810000','⾹港特别⾏政区');43 insert into provinces(id,provinceid,province) values(34,'820000','澳门特别⾏政区');1 DROP TABLE IF EXISTS `cities`;2 CREATE TABLE `cities` (3 `id` int(11) NOT NULL auto_increment,4 `cityid` varchar(20) NOT NULL,5 `city` varchar(50) NOT NULL,6 `provinceid` varchar(20) NOT NULL,7 PRIMARY KEY (`id`)8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='⾏政区域地州市信息表';910 insert into cities(id,cityid,city,provinceid) values(1,'110100','市辖区','110000');11 insert into cities(id,cityid,city,provinceid) values(2,'110200','县','110000');12 insert into cities(id,cityid,city,provinceid) values(3,'120100','市辖区','120000');13 insert into cities(id,cityid,city,provinceid) values(4,'120200','县','120000');14 insert into cities(id,cityid,city,provinceid) values(5,'130100','⽯家庄市','130000');15 insert into cities(id,cityid,city,provinceid) values(6,'130200','唐⼭市','130000');16 insert into cities(id,cityid,city,provinceid) values(7,'130300','秦皇岛市','130000');17 insert into cities(id,cityid,city,provinceid) values(8,'130400','邯郸市','130000');18 insert into cities(id,cityid,city,provinceid) values(9,'130500','邢台市','130000');19 insert into cities(id,cityid,city,provinceid) values(10,'130600','保定市','130000');20 insert into cities(id,cityid,city,provinceid) values(11,'130700','张家⼝市','130000');21 insert into cities(id,cityid,city,provinceid) values(12,'130800','承德市','130000');22 insert into cities(id,cityid,city,provinceid) values(13,'130900','沧州市','130000');23 insert into cities(id,cityid,city,provinceid) values(14,'131000','廊坊市','130000');24 insert into cities(id,cityid,city,provinceid) values(15,'131100','衡⽔市','130000');25 insert into cities(id,cityid,city,provinceid) values(16,'140100','太原市','140000');26 insert into cities(id,cityid,city,provinceid) values(17,'140200','⼤同市','140000');27 insert into cities(id,cityid,city,provinceid) values(18,'140300','阳泉市','140000');28 insert into cities(id,cityid,city,provinceid) values(19,'140400','长治市','140000');29 insert into cities(id,cityid,city,provinceid) values(20,'140500','晋城市','140000');30 insert into cities(id,cityid,city,provinceid) values(21,'140600','朔州市','140000');39 insert into cities(id,cityid,city,provinceid) values(30,'150400','⾚峰市','150000');40 insert into cities(id,cityid,city,provinceid) values(31,'150500','通辽市','150000');41 insert into cities(id,cityid,city,provinceid) values(32,'150600','鄂尔多斯市','150000');42 insert into cities(id,cityid,city,provinceid) values(33,'150700','呼伦贝尔市','150000');43 insert into cities(id,cityid,city,provinceid) values(34,'150800','巴彦淖尔市','150000');44 insert into cities(id,cityid,city,provinceid) values(35,'150900','乌兰察布市','150000');45 insert into cities(id,cityid,city,provinceid) values(36,'152200','兴安盟','150000');46 insert into cities(id,cityid,city,provinceid) values(37,'152500','锡林郭勒盟','150000');47 insert into cities(id,cityid,city,provinceid) values(38,'152900','阿拉善盟','150000');48 insert into cities(id,cityid,city,provinceid) values(39,'210100','沈阳市','210000');49 insert into cities(id,cityid,city,provinceid) values(40,'210200','⼤连市','210000');50 insert into cities(id,cityid,city,provinceid) values(41,'210300','鞍⼭市','210000');51 insert into cities(id,cityid,city,provinceid) values(42,'210400','抚顺市','210000');52 insert into cities(id,cityid,city,provinceid) values(43,'210500','本溪市','210000');53 insert into cities(id,cityid,city,provinceid) values(44,'210600','丹东市','210000');54 insert into cities(id,cityid,city,provinceid) values(45,'210700','锦州市','210000');55 insert into cities(id,cityid,city,provinceid) values(46,'210800','营⼝市','210000');56 insert into cities(id,cityid,city,provinceid) values(47,'210900','⾩新市','210000');57 insert into cities(id,cityid,city,provinceid) values(48,'211000','辽阳市','210000');58 insert into cities(id,cityid,city,provinceid) values(49,'211100','盘锦市','210000');59 insert into cities(id,cityid,city,provinceid) values(50,'211200','铁岭市','210000');60 insert into cities(id,cityid,city,provinceid) values(51,'211300','朝阳市','210000');61 insert into cities(id,cityid,city,provinceid) values(52,'211400','葫芦岛市','210000');62 insert into cities(id,cityid,city,provinceid) values(53,'220100','长春市','220000');63 insert into cities(id,cityid,city,provinceid) values(54,'220200','吉林市','220000');64 insert into cities(id,cityid,city,provinceid) values(55,'220300','四平市','220000');65 insert into cities(id,cityid,city,provinceid) values(56,'220400','辽源市','220000');66 insert into cities(id,cityid,city,provinceid) values(57,'220500','通化市','220000');67 insert into cities(id,cityid,city,provinceid) values(58,'220600','⽩⼭市','220000');68 insert into cities(id,cityid,city,provinceid) values(59,'220700','松原市','220000');69 insert into cities(id,cityid,city,provinceid) values(60,'220800','⽩城市','220000');70 insert into cities(id,cityid,city,provinceid) values(61,'222400','延边朝鲜族⾃治州','220000');71 insert into cities(id,cityid,city,provinceid) values(62,'230100','哈尔滨市','230000');72 insert into cities(id,cityid,city,provinceid) values(63,'230200','齐齐哈尔市','230000');73 insert into cities(id,cityid,city,provinceid) values(64,'230300','鸡西市','230000');74 insert into cities(id,cityid,city,provinceid) values(65,'230400','鹤岗市','230000');75 insert into cities(id,cityid,city,provinceid) values(66,'230500','双鸭⼭市','230000');76 insert into cities(id,cityid,city,provinceid) values(67,'230600','⼤庆市','230000');77 insert into cities(id,cityid,city,provinceid) values(68,'230700','伊春市','230000');78 insert into cities(id,cityid,city,provinceid) values(69,'230800','佳⽊斯市','230000');79 insert into cities(id,cityid,city,provinceid) values(70,'230900','七台河市','230000');80 insert into cities(id,cityid,city,provinceid) values(71,'231000','牡丹江市','230000');81 insert into cities(id,cityid,city,provinceid) values(72,'231100','⿊河市','230000');82 insert into cities(id,cityid,city,provinceid) values(73,'231200','绥化市','230000');83 insert into cities(id,cityid,city,provinceid) values(74,'232700','⼤兴安岭地区','230000');84 insert into cities(id,cityid,city,provinceid) values(75,'310100','市辖区','310000');85 insert into cities(id,cityid,city,provinceid) values(76,'310200','县','310000');86 insert into cities(id,cityid,city,provinceid) values(77,'320100','南京市','320000');87 insert into cities(id,cityid,city,provinceid) values(78,'320200','⽆锡市','320000');88 insert into cities(id,cityid,city,provinceid) values(79,'320300','徐州市','320000');89 insert into cities(id,cityid,city,provinceid) values(80,'320400','常州市','320000');90 insert into cities(id,cityid,city,provinceid) values(81,'320500','苏州市','320000');91 insert into cities(id,cityid,city,provinceid) values(82,'320600','南通市','320000');92 insert into cities(id,cityid,city,provinceid) values(83,'320700','连云港市','320000');93 insert into cities(id,cityid,city,provinceid) values(84,'320800','淮安市','320000');94 insert into cities(id,cityid,city,provinceid) values(85,'320900','盐城市','320000');95 insert into cities(id,cityid,city,provinceid) values(86,'321000','扬州市','320000');96 insert into cities(id,cityid,city,provinceid) values(87,'321100','镇江市','320000');97 insert into cities(id,cityid,city,provinceid) values(88,'321200','泰州市','320000');98 insert into cities(id,cityid,city,provinceid) values(89,'321300','宿迁市','320000');99 insert into cities(id,cityid,city,provinceid) values(90,'330100','杭州市','330000');100 insert into cities(id,cityid,city,provinceid) values(91,'330200','宁波市','330000');101 insert into cities(id,cityid,city,provinceid) values(92,'330300','温州市','330000');102 insert into cities(id,cityid,city,provinceid) values(93,'330400','嘉兴市','330000');103 insert into cities(id,cityid,city,provinceid) values(94,'330500','湖州市','330000');104 insert into cities(id,cityid,city,provinceid) values(95,'330600','绍兴市','330000');105 insert into cities(id,cityid,city,provinceid) values(96,'330700','⾦华市','330000');106 insert into cities(id,cityid,city,provinceid) values(97,'330800','衢州市','330000');107 insert into cities(id,cityid,city,provinceid) values(98,'330900','⾈⼭市','330000');108 insert into cities(id,cityid,city,provinceid) values(99,'331000','台州市','330000');109 insert into cities(id,cityid,city,provinceid) values(100,'331100','丽⽔市','330000');110 insert into cities(id,cityid,city,provinceid) values(101,'340100','合肥市','340000');111 insert into cities(id,cityid,city,provinceid) values(102,'340200','芜湖市','340000');112 insert into cities(id,cityid,city,provinceid) values(103,'340300','蚌埠市','340000');113 insert into cities(id,cityid,city,provinceid) values(104,'340400','淮南市','340000');114 insert into cities(id,cityid,city,provinceid) values(105,'340500','马鞍⼭市','340000');123 insert into cities(id,cityid,city,provinceid) values(114,'341500','六安市','340000');124 insert into cities(id,cityid,city,provinceid) values(115,'341600','亳州市','340000');125 insert into cities(id,cityid,city,provinceid) values(116,'341700','池州市','340000');126 insert into cities(id,cityid,city,provinceid) values(117,'341800','宣城市','340000');127 insert into cities(id,cityid,city,provinceid) values(118,'350100','福州市','350000');128 insert into cities(id,cityid,city,provinceid) values(119,'350200','厦门市','350000');129 insert into cities(id,cityid,city,provinceid) values(120,'350300','莆⽥市','350000');130 insert into cities(id,cityid,city,provinceid) values(121,'350400','三明市','350000');131 insert into cities(id,cityid,city,provinceid) values(122,'350500','泉州市','350000');132 insert into cities(id,cityid,city,provinceid) values(123,'350600','漳州市','350000');133 insert into cities(id,cityid,city,provinceid) values(124,'350700','南平市','350000');134 insert into cities(id,cityid,city,provinceid) values(125,'350800','龙岩市','350000');135 insert into cities(id,cityid,city,provinceid) values(126,'350900','宁德市','350000');136 insert into cities(id,cityid,city,provinceid) values(127,'360100','南昌市','360000');137 insert into cities(id,cityid,city,provinceid) values(128,'360200','景德镇市','360000');138 insert into cities(id,cityid,city,provinceid) values(129,'360300','萍乡市','360000');139 insert into cities(id,cityid,city,provinceid) values(130,'360400','九江市','360000');140 insert into cities(id,cityid,city,provinceid) values(131,'360500','新余市','360000');141 insert into cities(id,cityid,city,provinceid) values(132,'360600','鹰潭市','360000');142 insert into cities(id,cityid,city,provinceid) values(133,'360700','赣州市','360000');143 insert into cities(id,cityid,city,provinceid) values(134,'360800','吉安市','360000');144 insert into cities(id,cityid,city,provinceid) values(135,'360900','宜春市','360000');145 insert into cities(id,cityid,city,provinceid) values(136,'361000','抚州市','360000');146 insert into cities(id,cityid,city,provinceid) values(137,'361100','上饶市','360000');147 insert into cities(id,cityid,city,provinceid) values(138,'370100','济南市','370000');148 insert into cities(id,cityid,city,provinceid) values(139,'370200','青岛市','370000');149 insert into cities(id,cityid,city,provinceid) values(140,'370300','淄博市','370000');150 insert into cities(id,cityid,city,provinceid) values(141,'370400','枣庄市','370000');151 insert into cities(id,cityid,city,provinceid) values(142,'370500','东营市','370000');152 insert into cities(id,cityid,city,provinceid) values(143,'370600','烟台市','370000');153 insert into cities(id,cityid,city,provinceid) values(144,'370700','潍坊市','370000');154 insert into cities(id,cityid,city,provinceid) values(145,'370800','济宁市','370000');155 insert into cities(id,cityid,city,provinceid) values(146,'370900','泰安市','370000');156 insert into cities(id,cityid,city,provinceid) values(147,'371000','威海市','370000');157 insert into cities(id,cityid,city,provinceid) values(148,'371100','⽇照市','370000');158 insert into cities(id,cityid,city,provinceid) values(149,'371200','莱芜市','370000');159 insert into cities(id,cityid,city,provinceid) values(150,'371300','临沂市','370000');160 insert into cities(id,cityid,city,provinceid) values(151,'371400','德州市','370000');161 insert into cities(id,cityid,city,provinceid) values(152,'371500','聊城市','370000');162 insert into cities(id,cityid,city,provinceid) values(153,'371600','滨州市','370000');163 insert into cities(id,cityid,city,provinceid) values(154,'371700','荷泽市','370000');164 insert into cities(id,cityid,city,provinceid) values(155,'410100','郑州市','410000');165 insert into cities(id,cityid,city,provinceid) values(156,'410200','开封市','410000');166 insert into cities(id,cityid,city,provinceid) values(157,'410300','洛阳市','410000');167 insert into cities(id,cityid,city,provinceid) values(158,'410400','平顶⼭市','410000');168 insert into cities(id,cityid,city,provinceid) values(159,'410500','安阳市','410000');169 insert into cities(id,cityid,city,provinceid) values(160,'410600','鹤壁市','410000');170 insert into cities(id,cityid,city,provinceid) values(161,'410700','新乡市','410000');171 insert into cities(id,cityid,city,provinceid) values(162,'410800','焦作市','410000');172 insert into cities(id,cityid,city,provinceid) values(163,'410900','濮阳市','410000');173 insert into cities(id,cityid,city,provinceid) values(164,'411000','许昌市','410000');174 insert into cities(id,cityid,city,provinceid) values(165,'411100','漯河市','410000');175 insert into cities(id,cityid,city,provinceid) values(166,'411200','三门峡市','410000');176 insert into cities(id,cityid,city,provinceid) values(167,'411300','南阳市','410000');177 insert into cities(id,cityid,city,provinceid) values(168,'411400','商丘市','410000');178 insert into cities(id,cityid,city,provinceid) values(169,'411500','信阳市','410000');179 insert into cities(id,cityid,city,provinceid) values(170,'411600','周⼝市','410000');180 insert into cities(id,cityid,city,provinceid) values(171,'411700','驻马店市','410000');181 insert into cities(id,cityid,city,provinceid) values(172,'420100','武汉市','420000');182 insert into cities(id,cityid,city,provinceid) values(173,'420200','黄⽯市','420000');183 insert into cities(id,cityid,city,provinceid) values(174,'420300','⼗堰市','420000');184 insert into cities(id,cityid,city,provinceid) values(175,'420500','宜昌市','420000');185 insert into cities(id,cityid,city,provinceid) values(176,'420600','襄樊市','420000');186 insert into cities(id,cityid,city,provinceid) values(177,'420700','鄂州市','420000');187 insert into cities(id,cityid,city,provinceid) values(178,'420800','荆门市','420000');188 insert into cities(id,cityid,city,provinceid) values(179,'420900','孝感市','420000');189 insert into cities(id,cityid,city,provinceid) values(180,'421000','荆州市','420000');190 insert into cities(id,cityid,city,provinceid) values(181,'421100','黄冈市','420000');191 insert into cities(id,cityid,city,provinceid) values(182,'421200','咸宁市','420000');192 insert into cities(id,cityid,city,provinceid) values(183,'421300','随州市','420000');193 insert into cities(id,cityid,city,provinceid) values(184,'422800','恩施⼟家族苗族⾃治州','420000'); 194 insert into cities(id,cityid,city,provinceid) values(185,'429000','省直辖⾏政单位','420000');195 insert into cities(id,cityid,city,provinceid) values(186,'430100','长沙市','430000');196 insert into cities(id,cityid,city,provinceid) values(187,'430200','株洲市','430000');197 insert into cities(id,cityid,city,provinceid) values(188,'430300','湘潭市','430000');198 insert into cities(id,cityid,city,provinceid) values(189,'430400','衡阳市','430000');207 insert into cities(id,cityid,city,provinceid) values(198,'431300','娄底市','430000');208 insert into cities(id,cityid,city,provinceid) values(199,'433100','湘西⼟家族苗族⾃治州','430000'); 209 insert into cities(id,cityid,city,provinceid) values(200,'440100','⼴州市','440000');210 insert into cities(id,cityid,city,provinceid) values(201,'440200','韶关市','440000');211 insert into cities(id,cityid,city,provinceid) values(202,'440300','深圳市','440000');212 insert into cities(id,cityid,city,provinceid) values(203,'440400','珠海市','440000');213 insert into cities(id,cityid,city,provinceid) values(204,'440500','汕头市','440000');214 insert into cities(id,cityid,city,provinceid) values(205,'440600','佛⼭市','440000');215 insert into cities(id,cityid,city,provinceid) values(206,'440700','江门市','440000');216 insert into cities(id,cityid,city,provinceid) values(207,'440800','湛江市','440000');217 insert into cities(id,cityid,city,provinceid) values(208,'440900','茂名市','440000');218 insert into cities(id,cityid,city,provinceid) values(209,'441200','肇庆市','440000');219 insert into cities(id,cityid,city,provinceid) values(210,'441300','惠州市','440000');220 insert into cities(id,cityid,city,provinceid) values(211,'441400','梅州市','440000');221 insert into cities(id,cityid,city,provinceid) values(212,'441500','汕尾市','440000');222 insert into cities(id,cityid,city,provinceid) values(213,'441600','河源市','440000');223 insert into cities(id,cityid,city,provinceid) values(214,'441700','阳江市','440000');224 insert into cities(id,cityid,city,provinceid) values(215,'441800','清远市','440000');225 insert into cities(id,cityid,city,provinceid) values(216,'441900','东莞市','440000');226 insert into cities(id,cityid,city,provinceid) values(217,'442000','中⼭市','440000');227 insert into cities(id,cityid,city,provinceid) values(218,'445100','潮州市','440000');228 insert into cities(id,cityid,city,provinceid) values(219,'445200','揭阳市','440000');229 insert into cities(id,cityid,city,provinceid) values(220,'445300','云浮市','440000');230 insert into cities(id,cityid,city,provinceid) values(221,'450100','南宁市','450000');231 insert into cities(id,cityid,city,provinceid) values(222,'450200','柳州市','450000');232 insert into cities(id,cityid,city,provinceid) values(223,'450300','桂林市','450000');233 insert into cities(id,cityid,city,provinceid) values(224,'450400','梧州市','450000');234 insert into cities(id,cityid,city,provinceid) values(225,'450500','北海市','450000');235 insert into cities(id,cityid,city,provinceid) values(226,'450600','防城港市','450000');236 insert into cities(id,cityid,city,provinceid) values(227,'450700','钦州市','450000');237 insert into cities(id,cityid,city,provinceid) values(228,'450800','贵港市','450000');238 insert into cities(id,cityid,city,provinceid) values(229,'450900','⽟林市','450000');239 insert into cities(id,cityid,city,provinceid) values(230,'451000','百⾊市','450000');240 insert into cities(id,cityid,city,provinceid) values(231,'451100','贺州市','450000');241 insert into cities(id,cityid,city,provinceid) values(232,'451200','河池市','450000');242 insert into cities(id,cityid,city,provinceid) values(233,'451300','来宾市','450000');243 insert into cities(id,cityid,city,provinceid) values(234,'451400','崇左市','450000');244 insert into cities(id,cityid,city,provinceid) values(235,'460100','海⼝市','460000');245 insert into cities(id,cityid,city,provinceid) values(236,'460200','三亚市','460000');246 insert into cities(id,cityid,city,provinceid) values(237,'469000','省直辖县级⾏政单位','460000'); 247 insert into cities(id,cityid,city,provinceid) values(238,'500100','市辖区','500000');248 insert into cities(id,cityid,city,provinceid) values(239,'500200','县','500000');249 insert into cities(id,cityid,city,provinceid) values(240,'500300','市','500000');250 insert into cities(id,cityid,city,provinceid) values(241,'510100','成都市','510000');251 insert into cities(id,cityid,city,provinceid) values(242,'510300','⾃贡市','510000');252 insert into cities(id,cityid,city,provinceid) values(243,'510400','攀枝花市','510000');253 insert into cities(id,cityid,city,provinceid) values(244,'510500','泸州市','510000');254 insert into cities(id,cityid,city,provinceid) values(245,'510600','德阳市','510000');255 insert into cities(id,cityid,city,provinceid) values(246,'510700','绵阳市','510000');256 insert into cities(id,cityid,city,provinceid) values(247,'510800','⼴元市','510000');257 insert into cities(id,cityid,city,provinceid) values(248,'510900','遂宁市','510000');258 insert into cities(id,cityid,city,provinceid) values(249,'511000','内江市','510000');259 insert into cities(id,cityid,city,provinceid) values(250,'511100','乐⼭市','510000');260 insert into cities(id,cityid,city,provinceid) values(251,'511300','南充市','510000');261 insert into cities(id,cityid,city,provinceid) values(252,'511400','眉⼭市','510000');262 insert into cities(id,cityid,city,provinceid) values(253,'511500','宜宾市','510000');263 insert into cities(id,cityid,city,provinceid) values(254,'511600','⼴安市','510000');264 insert into cities(id,cityid,city,provinceid) values(255,'511700','达州市','510000');265 insert into cities(id,cityid,city,provinceid) values(256,'511800','雅安市','510000');266 insert into cities(id,cityid,city,provinceid) values(257,'511900','巴中市','510000');267 insert into cities(id,cityid,city,provinceid) values(258,'512000','资阳市','510000');268 insert into cities(id,cityid,city,provinceid) values(259,'513200','阿坝藏族羌族⾃治州','510000'); 269 insert into cities(id,cityid,city,provinceid) values(260,'513300','⽢孜藏族⾃治州','510000');270 insert into cities(id,cityid,city,provinceid) values(261,'513400','凉⼭彝族⾃治州','510000');271 insert into cities(id,cityid,city,provinceid) values(262,'520100','贵阳市','520000');272 insert into cities(id,cityid,city,provinceid) values(263,'520200','六盘⽔市','520000');273 insert into cities(id,cityid,city,provinceid) values(264,'520300','遵义市','520000');274 insert into cities(id,cityid,city,provinceid) values(265,'520400','安顺市','520000');275 insert into cities(id,cityid,city,provinceid) values(266,'522200','铜仁地区','520000');276 insert into cities(id,cityid,city,provinceid) values(267,'522300','黔西南布依族苗族⾃治州','520000'); 277 insert into cities(id,cityid,city,provinceid) values(268,'522400','毕节地区','520000');278 insert into cities(id,cityid,city,provinceid) values(269,'522600','黔东南苗族侗族⾃治州','520000'); 279 insert into cities(id,cityid,city,provinceid) values(270,'522700','黔南布依族苗族⾃治州','520000'); 280 insert into cities(id,cityid,city,provinceid) values(271,'530100','昆明市','530000');281 insert into cities(id,cityid,city,provinceid) values(272,'530300','曲靖市','530000');282 insert into cities(id,cityid,city,provinceid) values(273,'530400','⽟溪市','530000');。

全国省份城市表（sql版）

全国省份城市表（sql版）
前段时间感觉现在正在⽤的全国省份/城市表不是太好，于是想换⼀个新的，没想到上⽹找了好久都没有找到合适的，于是上国家统计局⽹站上拷了⼀份最新的有关区域名称的本⽂回来，最后花半天时间整理了⼀下，终于改为⾃⼰想要的格式了，想到还有许多朋友想要⼀份这样的数据表，故现公布如下：
国家统计局的⽹址：
数据库表结构：
if exists (select*from dbo.sysobjects where id =object_id(N'[dbo].[Area]') and OBJECTPROPERTY(id, N'IsUserTable') =1)
drop table[dbo].[Area]
GO
CREATE TABLE[dbo].[Area] (
[AreaID][int]IDENTITY (1, 1) NOT NULL ,
[Name][nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ParentID][int]NULL
) ON[PRIMARY]
GO
ALTER TABLE[dbo].[Area]ADD
CONSTRAINT[PK_aa]PRIMARY KEY CLUSTERED
(
[AreaID]
) ON[PRIMARY]
GO
数据内容我已导出成txt格式，因为数据库⽂件太⼤了，默认的就有1M。

只要把下载的⽂件导⼊到前⾯建好的表中即可！
放⼀幅图出来look⼀look：。

MySQL中国省市区SQL表数据

MySQL中国省市区SQL表数据1.查省SELECT * FROM china WHERE china.Pid=02.查市SELECT * FROM chinaWHERE china.Pid=3300003.查区SELECT * FROM china WHERE china.Pid = 3301004.Mysql脚本DROP TABLE IF EXISTS `china`;CREATE TABLE `china` (`Id` INT(11) NOT NULL,`Name` VARCHAR(40) DEFAULT NULL,`Pid` INT(11) DEFAULT NULL,PRIMARY KEY (`Id`),KEY `FK_CHINA_REFERENCE_CHINA` (`Pid`),CONSTRAINT `FK_CHINA_REFERENCE_CHINA` FOREIGN KEY (`Pid`) REFERENCES `china` (`Id`)) ENGINE=INNODB DEFAULT CHARSET=utf8;-- ------------------------------ Records of china-- ----------------------------INSERT INTO `china` VALUES ('0', '中国', '0');INSERT INTO `china` VALUES ('110000', '北京市', '0');INSERT INTO `china` VALUES ('110100', '东城区', '110000');INSERT INTO `china` VALUES ('110200', '西城区', '110000');INSERT INTO `china` VALUES ('110500', '朝阳区', '110000');INSERT INTO `china` VALUES ('110600', '丰台区', '110000');INSERT INTO `china` VALUES ('110700', '⽯景⼭区', '110000');INSERT INTO `china` VALUES ('110800', '海淀区', '110000');INSERT INTO `china` VALUES ('110900', '门头沟区', '110000');INSERT INTO `china` VALUES ('111100', '房⼭区', '110000');INSERT INTO `china` VALUES ('111200', '通州区', '110000');INSERT INTO `china` VALUES ('111300', '顺义区', '110000');INSERT INTO `china` VALUES ('111400', '昌平区', '110000');INSERT INTO `china` VALUES ('111500', '⼤兴区', '110000');INSERT INTO `china` VALUES ('111600', '怀柔区', '110000');INSERT INTO `china` VALUES ('111700', '平⾕区', '110000');INSERT INTO `china` VALUES ('112800', '密云县', '110000');INSERT INTO `china` VALUES ('112900', '延庆县', '110000');INSERT INTO `china` VALUES ('120000', '天津市', '0');INSERT INTO `china` VALUES ('120100', '和平区', '120000');INSERT INTO `china` VALUES ('120200', '河东区', '120000');INSERT INTO `china` VALUES ('120300', '河西区', '120000');INSERT INTO `china` VALUES ('120400', '南开区', '120000');INSERT INTO `china` VALUES ('120500', '河北区', '120000');INSERT INTO `china` VALUES ('120600', '红桥区', '120000');INSERT INTO `china` VALUES ('120900', '滨海新区', '120000');INSERT INTO `china` VALUES ('121000', '东丽区', '120000');INSERT INTO `china` VALUES ('121100', '西青区', '120000');INSERT INTO `china` VALUES ('121200', '津南区', '120000');INSERT INTO `china` VALUES ('121300', '北⾠区', '120000');INSERT INTO `china` VALUES ('121400', '武清区', '120000');INSERT INTO `china` VALUES ('121500', '宝坻区', '120000');INSERT INTO `china` VALUES ('122100', '宁河县', '120000');INSERT INTO `china` VALUES ('122300', '静海县', '120000');INSERT INTO `china` VALUES ('122500', '蓟县', '120000');INSERT INTO `china` VALUES ('130000', '河北省', '0');INSERT INTO `china` VALUES ('130100', '⽯家庄市', '130000');INSERT INTO `china` VALUES ('130101', '市辖区', '130100');INSERT INTO `china` VALUES ('130102', '长安区', '130101');INSERT INTO `china` VALUES ('130126', '灵寿县', '130100'); INSERT INTO `china` VALUES ('130127', '⾼⾢县', '130100'); INSERT INTO `china` VALUES ('130128', '深泽县', '130100'); INSERT INTO `china` VALUES ('130129', '赞皇县', '130100'); INSERT INTO `china` VALUES ('130130', '⽆极县', '130100'); INSERT INTO `china` VALUES ('130131', '平⼭县', '130100'); INSERT INTO `china` VALUES ('130132', '元⽒县', '130100'); INSERT INTO `china` VALUES ('130133', '赵县', '130100'); INSERT INTO `china` VALUES ('130181', '⾟集市', '130100'); INSERT INTO `china` VALUES ('130182', '藁城市', '130100'); INSERT INTO `china` VALUES ('130183', '晋州市', '130100'); INSERT INTO `china` VALUES ('130184', '新乐市', '130100'); INSERT INTO `china` VALUES ('130185', '⿅泉市', '130100'); INSERT INTO `china` VALUES ('130200', '唐⼭市', '130000'); INSERT INTO `china` VALUES ('130201', '市辖区', '130200'); INSERT INTO `china` VALUES ('130202', '路南区', '130201'); INSERT INTO `china` VALUES ('130203', '路北区', '130201'); INSERT INTO `china` VALUES ('130204', '古冶区', '130201'); INSERT INTO `china` VALUES ('130205', '开平区', '130201'); INSERT INTO `china` VALUES ('130207', '丰南区', '130201'); INSERT INTO `china` VALUES ('130208', '丰润区', '130201'); INSERT INTO `china` VALUES ('130223', '滦县', '130200'); INSERT INTO `china` VALUES ('130224', '滦南县', '130200'); INSERT INTO `china` VALUES ('130225', '乐亭县', '130200'); INSERT INTO `china` VALUES ('130227', '迁西县', '130200'); INSERT INTO `china` VALUES ('130229', '⽟⽥县', '130200'); INSERT INTO `china` VALUES ('130230', '唐海县', '130200'); INSERT INTO `china` VALUES ('130281', '遵化市', '130200'); INSERT INTO `china` VALUES ('130283', '迁安市', '130200'); INSERT INTO `china` VALUES ('130300', '秦皇岛市', '130000'); INSERT INTO `china` VALUES ('130301', '海港区', '130300'); INSERT INTO `china` VALUES ('130303', '⼭海关区', '130300'); INSERT INTO `china` VALUES ('130304', '北戴河区', '130300'); INSERT INTO `china` VALUES ('130321', '青龙满族⾃治县', '130300'); INSERT INTO `china` VALUES ('130322', '昌黎县', '130300'); INSERT INTO `china` VALUES ('130323', '抚宁县', '130300'); INSERT INTO `china` VALUES ('130324', '卢龙县', '130300'); INSERT INTO `china` VALUES ('130400', '邯郸市', '130000'); INSERT INTO `china` VALUES ('130401', '市辖区', '130400'); INSERT INTO `china` VALUES ('130402', '邯⼭区', '130401'); INSERT INTO `china` VALUES ('130403', '丛台区', '130401'); INSERT INTO `china` VALUES ('130404', '复兴区', '130401'); INSERT INTO `china` VALUES ('130406', '峰峰矿区', '130401'); INSERT INTO `china` VALUES ('130421', '邯郸县', '130400'); INSERT INTO `china` VALUES ('130423', '临漳县', '130400'); INSERT INTO `china` VALUES ('130424', '成安县', '130400'); INSERT INTO `china` VALUES ('130425', '⼤名县', '130400'); INSERT INTO `china` VALUES ('130426', '涉县', '130400'); INSERT INTO `china` VALUES ('130427', '磁县', '130400'); INSERT INTO `china` VALUES ('130428', '肥乡县', '130400'); INSERT INTO `china` VALUES ('130429', '永年县', '130400'); INSERT INTO `china` VALUES ('130430', '邱县', '130400'); INSERT INTO `china` VALUES ('130431', '鸡泽县', '130400'); INSERT INTO `china` VALUES ('130432', '⼴平县', '130400'); INSERT INTO `china` VALUES ('130433', '馆陶县', '130400'); INSERT INTO `china` VALUES ('130434', '魏县', '130400'); INSERT INTO `china` VALUES ('130435', '曲周县', '130400'); INSERT INTO `china` VALUES ('130481', '武安市', '130400'); INSERT INTO `china` VALUES ('130500', '邢台市', '130000'); INSERT INTO `china` VALUES ('130501', '市辖区', '130500'); INSERT INTO `china` VALUES ('130502', '桥东区', '130501'); INSERT INTO `china` VALUES ('130503', '桥西区', '130501'); INSERT INTO `china` VALUES ('130521', '邢台县', '130500');INSERT INTO `china` VALUES ('130530', '新河县', '130500'); INSERT INTO `china` VALUES ('130531', '⼴宗县', '130500'); INSERT INTO `china` VALUES ('130532', '平乡县', '130500'); INSERT INTO `china` VALUES ('130533', '威县', '130500'); INSERT INTO `china` VALUES ('130534', '清河县', '130500'); INSERT INTO `china` VALUES ('130535', '临西县', '130500'); INSERT INTO `china` VALUES ('130581', '南宫市', '130500'); INSERT INTO `china` VALUES ('130582', '沙河市', '130500'); INSERT INTO `china` VALUES ('130600', '保定市', '130000'); INSERT INTO `china` VALUES ('130601', '新市区', '130600'); INSERT INTO `china` VALUES ('130603', '北市区', '130600'); INSERT INTO `china` VALUES ('130604', '南市区', '130600'); INSERT INTO `china` VALUES ('130621', '满城县', '130600'); INSERT INTO `china` VALUES ('130622', '清苑县', '130600'); INSERT INTO `china` VALUES ('130623', '涞⽔县', '130600'); INSERT INTO `china` VALUES ('130624', '⾩平县', '130600'); INSERT INTO `china` VALUES ('130625', '徐⽔县', '130600'); INSERT INTO `china` VALUES ('130626', '定兴县', '130600'); INSERT INTO `china` VALUES ('130627', '唐县', '130600'); INSERT INTO `china` VALUES ('130628', '⾼阳县', '130600'); INSERT INTO `china` VALUES ('130629', '容城县', '130600'); INSERT INTO `china` VALUES ('130630', '涞源县', '130600'); INSERT INTO `china` VALUES ('130631', '望都县', '130600'); INSERT INTO `china` VALUES ('130632', '安新县', '130600'); INSERT INTO `china` VALUES ('130633', '易县', '130600'); INSERT INTO `china` VALUES ('130634', '曲阳县', '130600'); INSERT INTO `china` VALUES ('130635', '蠡县', '130600'); INSERT INTO `china` VALUES ('130636', '顺平县', '130600'); INSERT INTO `china` VALUES ('130637', '博野县', '130600'); INSERT INTO `china` VALUES ('130638', '雄县', '130600'); INSERT INTO `china` VALUES ('130681', '涿州市', '130600'); INSERT INTO `china` VALUES ('130682', '定州市', '130600'); INSERT INTO `china` VALUES ('130683', '安国市', '130600'); INSERT INTO `china` VALUES ('130684', '⾼碑店市', '130600'); INSERT INTO `china` VALUES ('130685', '⽩沟新城县', '130600'); INSERT INTO `china` VALUES ('130700', '张家⼝市', '130000'); INSERT INTO `china` VALUES ('130701', '市辖区', '130700'); INSERT INTO `china` VALUES ('130702', '桥东区', '130701'); INSERT INTO `china` VALUES ('130703', '桥西区', '130701'); INSERT INTO `china` VALUES ('130705', '宣化区', '130701'); INSERT INTO `china` VALUES ('130706', '下花园区', '130701'); INSERT INTO `china` VALUES ('130721', '宣化县', '130700'); INSERT INTO `china` VALUES ('130722', '张北县', '130700'); INSERT INTO `china` VALUES ('130723', '康保县', '130700'); INSERT INTO `china` VALUES ('130724', '沽源县', '130700'); INSERT INTO `china` VALUES ('130725', '尚义县', '130700'); INSERT INTO `china` VALUES ('130726', '蔚县', '130700'); INSERT INTO `china` VALUES ('130727', '阳原县', '130700'); INSERT INTO `china` VALUES ('130728', '怀安县', '130700'); INSERT INTO `china` VALUES ('130729', '万全县', '130700'); INSERT INTO `china` VALUES ('130730', '怀来县', '130700'); INSERT INTO `china` VALUES ('130731', '涿⿅县', '130700'); INSERT INTO `china` VALUES ('130732', '⾚城县', '130700'); INSERT INTO `china` VALUES ('130733', '崇礼县', '130700'); INSERT INTO `china` VALUES ('130800', '承德市', '130000'); INSERT INTO `china` VALUES ('130801', '市辖区', '130800'); INSERT INTO `china` VALUES ('130802', '双桥区', '130801'); INSERT INTO `china` VALUES ('130803', '双滦区', '130801'); INSERT INTO `china` VALUES ('130804', '鹰⼿营⼦矿区', '130801'); INSERT INTO `china` VALUES ('130821', '承德县', '130800'); INSERT INTO `china` VALUES ('130822', '兴隆县', '130800'); INSERT INTO `china` VALUES ('130823', '平泉县', '130800'); INSERT INTO `china` VALUES ('130824', '滦平县', '130800');INSERT INTO `china` VALUES ('130921', '沧县', '130900'); INSERT INTO `china` VALUES ('130922', '青县', '130900'); INSERT INTO `china` VALUES ('130923', '东光县', '130900'); INSERT INTO `china` VALUES ('130924', '海兴县', '130900'); INSERT INTO `china` VALUES ('130925', '盐⼭县', '130900'); INSERT INTO `china` VALUES ('130926', '肃宁县', '130900'); INSERT INTO `china` VALUES ('130927', '南⽪县', '130900'); INSERT INTO `china` VALUES ('130928', '吴桥县', '130900'); INSERT INTO `china` VALUES ('130929', '献县', '130900'); INSERT INTO `china` VALUES ('130930', '孟村回族⾃治县', '130900'); INSERT INTO `china` VALUES ('130981', '泊头市', '130900'); INSERT INTO `china` VALUES ('130982', '任丘市', '130900'); INSERT INTO `china` VALUES ('130983', '黄骅市', '130900'); INSERT INTO `china` VALUES ('130984', '河间市', '130900'); INSERT INTO `china` VALUES ('131000', '廊坊市', '130000'); INSERT INTO `china` VALUES ('131001', '市辖区', '131000'); INSERT INTO `china` VALUES ('131002', '安次区', '131001'); INSERT INTO `china` VALUES ('131003', '⼴阳区', '131001'); INSERT INTO `china` VALUES ('131022', '固安县', '131000'); INSERT INTO `china` VALUES ('131023', '永清县', '131000'); INSERT INTO `china` VALUES ('131024', '⾹河县', '131000'); INSERT INTO `china` VALUES ('131025', '⼤城县', '131000'); INSERT INTO `china` VALUES ('131026', '⽂安县', '131000'); INSERT INTO `china` VALUES ('131028', '⼤⼚回族⾃治县', '131000'); INSERT INTO `china` VALUES ('131081', '霸州市', '131000'); INSERT INTO `china` VALUES ('131082', '三河市', '131000'); INSERT INTO `china` VALUES ('131100', '衡⽔市', '130000'); INSERT INTO `china` VALUES ('131101', '市辖区', '131100'); INSERT INTO `china` VALUES ('131102', '桃城区', '131101'); INSERT INTO `china` VALUES ('131121', '枣强县', '131100'); INSERT INTO `china` VALUES ('131122', '武⾢县', '131100'); INSERT INTO `china` VALUES ('131123', '武强县', '131100'); INSERT INTO `china` VALUES ('131124', '饶阳县', '131100'); INSERT INTO `china` VALUES ('131125', '安平县', '131100'); INSERT INTO `china` VALUES ('131126', '故城县', '131100'); INSERT INTO `china` VALUES ('131127', '景县', '131100'); INSERT INTO `china` VALUES ('131128', '⾩城县', '131100'); INSERT INTO `china` VALUES ('131181', '冀州市', '131100'); INSERT INTO `china` VALUES ('131182', '深州市', '131100'); INSERT INTO `china` VALUES ('140000', '⼭西省', '0');INSERT INTO `china` VALUES ('140100', '太原市', '140000'); INSERT INTO `china` VALUES ('140101', '市辖区', '140100'); INSERT INTO `china` VALUES ('140105', '⼩店区', '140101'); INSERT INTO `china` VALUES ('140106', '迎泽区', '140101'); INSERT INTO `china` VALUES ('140107', '杏花岭区', '140101'); INSERT INTO `china` VALUES ('140108', '尖草坪区', '140101'); INSERT INTO `china` VALUES ('140109', '万柏林区', '140101'); INSERT INTO `china` VALUES ('140110', '晋源区', '140101'); INSERT INTO `china` VALUES ('140121', '清徐县', '140100'); INSERT INTO `china` VALUES ('140122', '阳曲县', '140100'); INSERT INTO `china` VALUES ('140123', '娄烦县', '140100'); INSERT INTO `china` VALUES ('140181', '古交市', '140100'); INSERT INTO `china` VALUES ('140200', '⼤同市', '140000'); INSERT INTO `china` VALUES ('140201', '市辖区', '140200'); INSERT INTO `china` VALUES ('140202', '城区', '140201'); INSERT INTO `china` VALUES ('140203', '矿区', '140201'); INSERT INTO `china` VALUES ('140211', '南郊区', '140201'); INSERT INTO `china` VALUES ('140212', '新荣区', '140201'); INSERT INTO `china` VALUES ('140221', '阳⾼县', '140200'); INSERT INTO `china` VALUES ('140222', '天镇县', '140200'); INSERT INTO `china` VALUES ('140223', '⼴灵县', '140200'); INSERT INTO `china` VALUES ('140224', '灵丘县', '140200'); INSERT INTO `china` VALUES ('140225', '浑源县', '140200');INSERT INTO `china` VALUES ('140322', '盂县', '140300'); INSERT INTO `china` VALUES ('140400', '长治市', '140000'); INSERT INTO `china` VALUES ('140401', '市辖区', '140400'); INSERT INTO `china` VALUES ('140402', '城区', '140401'); INSERT INTO `china` VALUES ('140411', '郊区', '140401'); INSERT INTO `china` VALUES ('140421', '长治县', '140400'); INSERT INTO `china` VALUES ('140423', '襄垣县', '140400'); INSERT INTO `china` VALUES ('140424', '屯留县', '140400'); INSERT INTO `china` VALUES ('140425', '平顺县', '140400'); INSERT INTO `china` VALUES ('140426', '黎城县', '140400'); INSERT INTO `china` VALUES ('140427', '壶关县', '140400'); INSERT INTO `china` VALUES ('140428', '长⼦县', '140400'); INSERT INTO `china` VALUES ('140429', '武乡县', '140400'); INSERT INTO `china` VALUES ('140430', '沁县', '140400'); INSERT INTO `china` VALUES ('140431', '沁源县', '140400'); INSERT INTO `china` VALUES ('140481', '潞城市', '140400'); INSERT INTO `china` VALUES ('140500', '晋城市', '140000'); INSERT INTO `china` VALUES ('140501', '市辖区', '140500'); INSERT INTO `china` VALUES ('140502', '城区', '140501'); INSERT INTO `china` VALUES ('140521', '沁⽔县', '140500'); INSERT INTO `china` VALUES ('140522', '阳城县', '140500'); INSERT INTO `china` VALUES ('140524', '陵川县', '140500'); INSERT INTO `china` VALUES ('140525', '泽州县', '140500'); INSERT INTO `china` VALUES ('140581', '⾼平市', '140500'); INSERT INTO `china` VALUES ('140600', '朔州市', '140000'); INSERT INTO `china` VALUES ('140601', '市辖区', '140600'); INSERT INTO `china` VALUES ('140602', '朔城区', '140601'); INSERT INTO `china` VALUES ('140603', '平鲁区', '140601'); INSERT INTO `china` VALUES ('140621', '⼭阴县', '140600'); INSERT INTO `china` VALUES ('140622', '应县', '140600'); INSERT INTO `china` VALUES ('140623', '右⽟县', '140600'); INSERT INTO `china` VALUES ('140624', '怀仁县', '140600'); INSERT INTO `china` VALUES ('140700', '晋中市', '140000'); INSERT INTO `china` VALUES ('140701', '市辖区', '140700'); INSERT INTO `china` VALUES ('140702', '榆次区', '140701'); INSERT INTO `china` VALUES ('140721', '榆社县', '140700'); INSERT INTO `china` VALUES ('140722', '左权县', '140700'); INSERT INTO `china` VALUES ('140723', '和顺县', '140700'); INSERT INTO `china` VALUES ('140724', '昔阳县', '140700'); INSERT INTO `china` VALUES ('140725', '寿阳县', '140700'); INSERT INTO `china` VALUES ('140726', '太⾕县', '140700'); INSERT INTO `china` VALUES ('140727', '祁县', '140700'); INSERT INTO `china` VALUES ('140728', '平遥县', '140700'); INSERT INTO `china` VALUES ('140729', '灵⽯县', '140700'); INSERT INTO `china` VALUES ('140781', '介休市', '140700'); INSERT INTO `china` VALUES ('140800', '运城市', '140000'); INSERT INTO `china` VALUES ('140801', '市辖区', '140800'); INSERT INTO `china` VALUES ('140802', '盐湖区', '140801'); INSERT INTO `china` VALUES ('140821', '临猗县', '140800'); INSERT INTO `china` VALUES ('140822', '万荣县', '140800'); INSERT INTO `china` VALUES ('140823', '闻喜县', '140800'); INSERT INTO `china` VALUES ('140824', '稷⼭县', '140800'); INSERT INTO `china` VALUES ('140825', '新绛县', '140800'); INSERT INTO `china` VALUES ('140826', '绛县', '140800'); INSERT INTO `china` VALUES ('140827', '垣曲县', '140800'); INSERT INTO `china` VALUES ('140828', '夏县', '140800'); INSERT INTO `china` VALUES ('140829', '平陆县', '140800'); INSERT INTO `china` VALUES ('140830', '芮城县', '140800'); INSERT INTO `china` VALUES ('140881', '永济市', '140800'); INSERT INTO `china` VALUES ('140882', '河津市', '140800'); INSERT INTO `china` VALUES ('140900', '忻州市', '140000'); INSERT INTO `china` VALUES ('140901', '忻府区', '140900'); INSERT INTO `china` VALUES ('140921', '定襄县', '140900');INSERT INTO `china` VALUES ('140930', '河曲县', '140900');INSERT INTO `china` VALUES ('140931', '保德县', '140900');INSERT INTO `china` VALUES ('140932', '偏关县', '140900');INSERT INTO `china` VALUES ('140981', '原平市', '140900');INSERT INTO `china` VALUES ('141000', '临汾市', '140000');INSERT INTO `china` VALUES ('141001', '市辖区', '141000');INSERT INTO `china` VALUES ('141002', '尧都区', '141000');INSERT INTO `china` VALUES ('141021', '曲沃县', '141000');INSERT INTO `china` VALUES ('141022', '翼城县', '141000');INSERT INTO `china` VALUES ('141023', '襄汾县', '141000');INSERT INTO `china` VALUES ('141024', '洪洞县', '141000');INSERT INTO `china` VALUES ('141025', '古县', '141000');INSERT INTO `china` VALUES ('141026', '安泽县', '141000');INSERT INTO `china` VALUES ('141027', '浮⼭县', '141000');INSERT INTO `china` VALUES ('141028', '吉县', '141000');INSERT INTO `china` VALUES ('141029', '乡宁县', '141000');INSERT INTO `china` VALUES ('141030', '⼤宁县', '141000');INSERT INTO `china` VALUES ('141031', '隰县', '141000');INSERT INTO `china` VALUES ('141032', '永和县', '141000');INSERT INTO `china` VALUES ('141033', '蒲县', '141000');INSERT INTO `china` VALUES ('141034', '汾西县', '141000');INSERT INTO `china` VALUES ('141081', '侯马市', '141000');INSERT INTO `china` VALUES ('141082', '霍州市', '141000');INSERT INTO `china` VALUES ('141100', '吕梁市', '140000');INSERT INTO `china` VALUES ('141101', '市辖区', '141100');INSERT INTO `china` VALUES ('141102', '离⽯区', '141101');INSERT INTO `china` VALUES ('141121', '⽂⽔县', '141100');INSERT INTO `china` VALUES ('141122', '交城县', '141100');INSERT INTO `china` VALUES ('141123', '兴县', '141100');INSERT INTO `china` VALUES ('141124', '临县', '141100');INSERT INTO `china` VALUES ('141125', '柳林县', '141100');INSERT INTO `china` VALUES ('141126', '⽯楼县', '141100');INSERT INTO `china` VALUES ('141127', '岚县', '141100');INSERT INTO `china` VALUES ('141128', '⽅⼭县', '141100');INSERT INTO `china` VALUES ('141129', '中阳县', '141100');INSERT INTO `china` VALUES ('141130', '交⼝县', '141100');INSERT INTO `china` VALUES ('141181', '孝义市', '141100');INSERT INTO `china` VALUES ('141182', '汾阳市', '141100');INSERT INTO `china` VALUES ('150000', '内蒙古⾃治区', '0');INSERT INTO `china` VALUES ('150100', '呼和浩特市', '150000'); INSERT INTO `china` VALUES ('150101', '市辖区', '150100');INSERT INTO `china` VALUES ('150102', '新城区', '150101');INSERT INTO `china` VALUES ('150103', '回民区', '150101');INSERT INTO `china` VALUES ('150104', '⽟泉区', '150101');INSERT INTO `china` VALUES ('150105', '赛罕区', '150101');INSERT INTO `china` VALUES ('150121', '⼟默特左旗', '150100'); INSERT INTO `china` VALUES ('150122', '托克托县', '150100'); INSERT INTO `china` VALUES ('150123', '和林格尔县', '150100'); INSERT INTO `china` VALUES ('150124', '清⽔河县', '150100'); INSERT INTO `china` VALUES ('150125', '武川县', '150100');INSERT INTO `china` VALUES ('150200', '包头市', '150000');INSERT INTO `china` VALUES ('150201', '市辖区', '150200');INSERT INTO `china` VALUES ('150202', '东河区', '150201');INSERT INTO `china` VALUES ('150203', '昆都仑区', '150201'); INSERT INTO `china` VALUES ('150204', '青⼭区', '150201');INSERT INTO `china` VALUES ('150205', '⽯拐区', '150201');INSERT INTO `china` VALUES ('150206', '⽩云矿区', '150201'); INSERT INTO `china` VALUES ('150207', '九原区', '150201');INSERT INTO `china` VALUES ('150221', '⼟默特右旗', '150200'); INSERT INTO `china` VALUES ('150222', '固阳县', '150200');INSERT INTO `china` VALUES ('150223', '达尔罕茂明安联合旗', '150200'); INSERT INTO `china` VALUES ('150300', '乌海市', '150000');INSERT INTO `china` VALUES ('150301', '市辖区', '150300');。

全国-省-地级市-县级市数据库

常州市无锡市苏州市南昌市景德镇市萍乡市九江市
新余市鹰潭市赣州地区
宜春地区
上饶地区
吉安地区
抚州地区
西宁市海东地区行政公署
海北藏族自治州海南藏族自治州黄南藏族自治州
果洛藏族自治州玉树藏族自治州海西蒙古族藏族自治州呼和浩特市包头市乌海市赤峰市
呼伦贝尔盟
兴安盟
哲里木盟
锡林郭勒盟
乌兰察布盟
伊克昭盟
宁夏回族自治区
巴彦淖尔盟阿拉善盟银川市石嘴山市银南地区
山东省
山西省
陕西省上海市天津市
固原地区济南市青岛市淄博市枣庄市东营市烟台市潍坊市济宁市
泰安市威海市日照市莱芜市临沂市德州市
滨州地区聊城市荷泽地区太原市大同市阳泉市长治市
晋城市朔州市忻州行署
凉山彝族自治州
新疆维吾尔自治区乌鲁木齐市克拉玛依市石河子市吐鲁番地区哈密地区昌吉回族自治州奎屯市伊犁地区
塔城地区阿勒泰地区博尔塔拉州巴音郭楞蒙古自治州
阿克苏地区
克孜勒苏柯尔克孜自治州喀什地区
云南省
和田地区昆明市东川市昭通地区
曲靖地区楚雄州玉溪地区红河州
浙江省台湾省
安徽省
北京市重庆市福建省甘肃省
广东省
合肥市芜湖市蚌埠市淮南市马鞍山市淮北市铜陵市安庆市黄山市滁州市阜阳市宿县地区六安地区宣城地区巢湖地区池州地区北京市重庆市万县区涪陵区黔江地区福州市厦门市莆田市三明市泉州市漳州市南平市龙岩地区宁德地区兰州市金昌市白银市天水市嘉峪关市定西地区平凉地区庆阳地区陇南地区武威地区张掖地区酒泉地区甘南藏族自治州临夏回族自治州广州市深圳市珠海市汕头市韶关市河源市梅州市惠州市汕尾市东莞市

quan中国省市区三级数据库表.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: iptohat_area# ------------------------------------------------------# Server version 5.0.26## Source for table hat_area#CREATE TABLE hat_area (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 hat_area#INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');INSERT INTO hat_area VALUES (18,'110229','延庆县','110200'); INSERT INTO hat_area VALUES (19,'120101','和平区','120100'); INSERT INTO hat_area VALUES (20,'120102','河东区','120100'); INSERT INTO hat_area VALUES (21,'120103','河西区','120100'); INSERT INTO hat_area VALUES (22,'120104','南开区','120100'); INSERT INTO hat_area VALUES (23,'120105','河北区','120100'); INSERT INTO hat_area VALUES (24,'120106','红桥区','120100'); INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100'); INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100'); INSERT INTO hat_area VALUES (27,'120109','大港区','120100'); INSERT INTO hat_area VALUES (28,'120110','东丽区','120100'); INSERT INTO hat_area VALUES (29,'120111','西青区','120100'); INSERT INTO hat_area VALUES (30,'120112','津南区','120100'); INSERT INTO hat_area VALUES (31,'120113','北辰区','120100'); INSERT INTO hat_area VALUES (32,'120114','武清区','120100'); INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100'); INSERT INTO hat_area VALUES (34,'120221','宁河县','120200'); INSERT INTO hat_area VALUES (35,'120223','静海县','120200'); INSERT INTO hat_area VALUES (36,'120225','蓟县','120200'); INSERT INTO hat_area VALUES (37,'130101','市辖区','130100'); INSERT INTO hat_area VALUES (38,'130102','长安区','130100'); INSERT INTO hat_area VALUES (39,'130103','桥东区','130100'); INSERT INTO hat_area VALUES (40,'130104','桥西区','130100'); INSERT INTO hat_area VALUES (41,'130105','新华区','130100'); INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100'); INSERT INTO hat_area VALUES (43,'130108','裕华区','130100'); INSERT INTO hat_area VALUES (44,'130121','井陉县','130100'); INSERT INTO hat_area VALUES (45,'130123','正定县','130100'); INSERT INTO hat_area VALUES (46,'130124','栾城县','130100'); INSERT INTO hat_area VALUES (47,'130125','行唐县','130100'); INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100'); INSERT INTO hat_area VALUES (49,'130127','高邑县','130100'); INSERT INTO hat_area VALUES (50,'130128','深泽县','130100'); INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100'); INSERT INTO hat_area VALUES (52,'130130','无极县','130100'); INSERT INTO hat_area VALUES (53,'130131','平山县','130100'); INSERT INTO hat_area VALUES (54,'130132','元氏县','130100'); INSERT INTO hat_area VALUES (55,'130133','赵县','130100'); INSERT INTO hat_area VALUES (56,'130181','辛集市','130100'); INSERT INTO hat_area VALUES (57,'130182','藁城市','130100'); INSERT INTO hat_area VALUES (58,'130183','晋州市','130100'); INSERT INTO hat_area VALUES (59,'130184','新乐市','130100'); INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');INSERT INTO hat_area VALUES (62,'130202','路南区','130200'); INSERT INTO hat_area VALUES (63,'130203','路北区','130200'); INSERT INTO hat_area VALUES (64,'130204','古冶区','130200'); INSERT INTO hat_area VALUES (65,'130205','开平区','130200'); INSERT INTO hat_area VALUES (66,'130207','丰南区','130200'); INSERT INTO hat_area VALUES (67,'130208','丰润区','130200'); INSERT INTO hat_area VALUES (68,'130223','滦县','130200'); INSERT INTO hat_area VALUES (69,'130224','滦南县','130200'); INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200'); INSERT INTO hat_area VALUES (71,'130227','迁西县','130200'); INSERT INTO hat_area VALUES (72,'130229','玉田县','130200'); INSERT INTO hat_area VALUES (73,'130230','唐海县','130200'); INSERT INTO hat_area VALUES (74,'130281','遵化市','130200'); INSERT INTO hat_area VALUES (75,'130283','迁安市','130200'); INSERT INTO hat_area VALUES (76,'130301','市辖区','130300'); INSERT INTO hat_area VALUES (77,'130302','海港区','130300'); INSERT INTO hat_area VALUES (78,'130303','山海关区','130300'); INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300'); INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300'); INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300'); INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300'); INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300'); INSERT INTO hat_area VALUES (84,'130401','市辖区','130400'); INSERT INTO hat_area VALUES (85,'130402','邯山区','130400'); INSERT INTO hat_area VALUES (86,'130403','丛台区','130400'); INSERT INTO hat_area VALUES (87,'130404','复兴区','130400'); INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400'); INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400'); INSERT INTO hat_area VALUES (90,'130423','临漳县','130400'); INSERT INTO hat_area VALUES (91,'130424','成安县','130400'); INSERT INTO hat_area VALUES (92,'130425','大名县','130400'); INSERT INTO hat_area VALUES (93,'130426','涉县','130400'); INSERT INTO hat_area VALUES (94,'130427','磁县','130400'); INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400'); INSERT INTO hat_area VALUES (96,'130429','永年县','130400'); INSERT INTO hat_area VALUES (97,'130430','邱县','130400'); INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400'); INSERT INTO hat_area VALUES (99,'130432','广平县','130400'); INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400'); INSERT INTO hat_area VALUES (101,'130434','魏县','130400'); INSERT INTO hat_area VALUES (102,'130435','曲周县','130400'); INSERT INTO hat_area VALUES (103,'130481','武安市','130400'); INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');INSERT INTO hat_area VALUES (106,'130503','桥西区','130500'); INSERT INTO hat_area VALUES (107,'130521','邢台县','130500'); INSERT INTO hat_area VALUES (108,'130522','临城县','130500'); INSERT INTO hat_area VALUES (109,'130523','内丘县','130500'); INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500'); INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500'); INSERT INTO hat_area VALUES (112,'130526','任县','130500'); INSERT INTO hat_area VALUES (113,'130527','南和县','130500'); INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500'); INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500'); INSERT INTO hat_area VALUES (116,'130530','新河县','130500'); INSERT INTO hat_area VALUES (117,'130531','广宗县','130500'); INSERT INTO hat_area VALUES (118,'130532','平乡县','130500'); INSERT INTO hat_area VALUES (119,'130533','威县','130500'); INSERT INTO hat_area VALUES (120,'130534','清河县','130500'); INSERT INTO hat_area VALUES (121,'130535','临西县','130500'); INSERT INTO hat_area VALUES (122,'130581','南宫市','130500'); INSERT INTO hat_area VALUES (123,'130582','沙河市','130500'); INSERT INTO hat_area VALUES (124,'130601','市辖区','130600'); INSERT INTO hat_area VALUES (125,'130602','新市区','130600'); INSERT INTO hat_area VALUES (126,'130603','北市区','130600'); INSERT INTO hat_area VALUES (127,'130604','南市区','130600'); INSERT INTO hat_area VALUES (128,'130621','满城县','130600'); INSERT INTO hat_area VALUES (129,'130622','清苑县','130600'); INSERT INTO hat_area VALUES (130,'130623','涞水县','130600'); INSERT INTO hat_area VALUES (131,'130624','阜平县','130600'); INSERT INTO hat_area VALUES (132,'130625','徐水县','130600'); INSERT INTO hat_area VALUES (133,'130626','定兴县','130600'); INSERT INTO hat_area VALUES (134,'130627','唐县','130600'); INSERT INTO hat_area VALUES (135,'130628','高阳县','130600'); INSERT INTO hat_area VALUES (136,'130629','容城县','130600'); INSERT INTO hat_area VALUES (137,'130630','涞源县','130600'); INSERT INTO hat_area VALUES (138,'130631','望都县','130600'); INSERT INTO hat_area VALUES (139,'130632','安新县','130600'); INSERT INTO hat_area VALUES (140,'130633','易县','130600'); INSERT INTO hat_area VALUES (141,'130634','曲阳县','130600'); INSERT INTO hat_area VALUES (142,'130635','蠡县','130600'); INSERT INTO hat_area VALUES (143,'130636','顺平县','130600'); INSERT INTO hat_area VALUES (144,'130637','博野县','130600'); INSERT INTO hat_area VALUES (145,'130638','雄县','130600'); INSERT INTO hat_area VALUES (146,'130681','涿州市','130600'); INSERT INTO hat_area VALUES (147,'130682','定州市','130600'); INSERT INTO hat_area VALUES (148,'130683','安国市','130600');INSERT INTO hat_area VALUES (150,'130701','市辖区','130700');INSERT INTO hat_area VALUES (151,'130702','桥东区','130700');INSERT INTO hat_area VALUES (152,'130703','桥西区','130700');INSERT INTO hat_area VALUES (153,'130705','宣化区','130700');INSERT INTO hat_area VALUES (154,'130706','下花园区','130700');INSERT INTO hat_area VALUES (155,'130721','宣化县','130700');INSERT INTO hat_area VALUES (156,'130722','张北县','130700');INSERT INTO hat_area VALUES (157,'130723','康保县','130700');INSERT INTO hat_area VALUES (158,'130724','沽源县','130700');INSERT INTO hat_area VALUES (159,'130725','尚义县','130700');INSERT INTO hat_area VALUES (160,'130726','蔚县','130700');INSERT INTO hat_area VALUES (161,'130727','阳原县','130700');INSERT INTO hat_area VALUES (162,'130728','怀安县','130700');INSERT INTO hat_area VALUES (163,'130729','万全县','130700');INSERT INTO hat_area VALUES (164,'130730','怀来县','130700');INSERT INTO hat_area VALUES (165,'130731','涿鹿县','130700');INSERT INTO hat_area VALUES (166,'130732','赤城县','130700');INSERT INTO hat_area VALUES (167,'130733','崇礼县','130700');INSERT INTO hat_area VALUES (168,'130801','市辖区','130800');INSERT INTO hat_area VALUES (169,'130802','双桥区','130800');INSERT INTO hat_area VALUES (170,'130803','双滦区','130800');INSERT INTO hat_area VALUES (171,'130804','鹰手营子矿区','130800'); INSERT INTO hat_area VALUES (172,'130821','承德县','130800');INSERT INTO hat_area VALUES (173,'130822','兴隆县','130800');INSERT INTO hat_area VALUES (174,'130823','平泉县','130800');INSERT INTO hat_area VALUES (175,'130824','滦平县','130800');INSERT INTO hat_area VALUES (176,'130825','隆化县','130800');INSERT INTO hat_area VALUES (177,'130826','丰宁满族自治县','130800'); INSERT INTO hat_area VALUES (178,'130827','宽城满族自治县','130800'); INSERT INTO hat_area VALUES (179,'130828','围场满族蒙古族自治县','130800'); INSERT INTO hat_area VALUES (180,'130901','市辖区','130900');INSERT INTO hat_area VALUES (181,'130902','新华区','130900');INSERT INTO hat_area VALUES (182,'130903','运河区','130900');INSERT INTO hat_area VALUES (183,'130921','沧县','130900');INSERT INTO hat_area VALUES (184,'130922','青县','130900');INSERT INTO hat_area VALUES (185,'130923','东光县','130900');INSERT INTO hat_area VALUES (186,'130924','海兴县','130900');INSERT INTO hat_area VALUES (187,'130925','盐山县','130900');INSERT INTO hat_area VALUES (188,'130926','肃宁县','130900');INSERT INTO hat_area VALUES (189,'130927','南皮县','130900');INSERT INTO hat_area VALUES (190,'130928','吴桥县','130900');INSERT INTO hat_area VALUES (191,'130929','献县','130900');INSERT INTO hat_area VALUES (192,'130930','孟村回族自治县','130900');INSERT INTO hat_area VALUES (194,'130982','任丘市','130900'); INSERT INTO hat_area VALUES (195,'130983','黄骅市','130900'); INSERT INTO hat_area VALUES (196,'130984','河间市','130900'); INSERT INTO hat_area VALUES (197,'131001','市辖区','131000'); INSERT INTO hat_area VALUES (198,'131002','安次区','131000'); INSERT INTO hat_area VALUES (199,'131003','广阳区','131000'); INSERT INTO hat_area VALUES (200,'131022','固安县','131000'); INSERT INTO hat_area VALUES (201,'131023','永清县','131000'); INSERT INTO hat_area VALUES (202,'131024','香河县','131000'); INSERT INTO hat_area VALUES (203,'131025','大城县','131000'); INSERT INTO hat_area VALUES (204,'131026','文安县','131000'); INSERT INTO hat_area VALUES (205,'131028','大厂回族自治县','131000'); INSERT INTO hat_area VALUES (206,'131081','霸州市','131000'); INSERT INTO hat_area VALUES (207,'131082','三河市','131000'); INSERT INTO hat_area VALUES (208,'131101','市辖区','131100'); INSERT INTO hat_area VALUES (209,'131102','桃城区','131100'); INSERT INTO hat_area VALUES (210,'131121','枣强县','131100'); INSERT INTO hat_area VALUES (211,'131122','武邑县','131100'); INSERT INTO hat_area VALUES (212,'131123','武强县','131100'); INSERT INTO hat_area VALUES (213,'131124','饶阳县','131100'); INSERT INTO hat_area VALUES (214,'131125','安平县','131100'); INSERT INTO hat_area VALUES (215,'131126','故城县','131100'); INSERT INTO hat_area VALUES (216,'131127','景县','131100'); INSERT INTO hat_area VALUES (217,'131128','阜城县','131100'); INSERT INTO hat_area VALUES (218,'131181','冀州市','131100'); INSERT INTO hat_area VALUES (219,'131182','深州市','131100'); INSERT INTO hat_area VALUES (220,'140101','市辖区','140100'); INSERT INTO hat_area VALUES (221,'140105','小店区','140100'); INSERT INTO hat_area VALUES (222,'140106','迎泽区','140100'); INSERT INTO hat_area VALUES (223,'140107','杏花岭区','140100'); INSERT INTO hat_area VALUES (224,'140108','尖草坪区','140100'); INSERT INTO hat_area VALUES (225,'140109','万柏林区','140100'); INSERT INTO hat_area VALUES (226,'140110','晋源区','140100'); INSERT INTO hat_area VALUES (227,'140121','清徐县','140100'); INSERT INTO hat_area VALUES (228,'140122','阳曲县','140100'); INSERT INTO hat_area VALUES (229,'140123','娄烦县','140100'); INSERT INTO hat_area VALUES (230,'140181','古交市','140100'); INSERT INTO hat_area VALUES (231,'140201','市辖区','140200'); INSERT INTO hat_area VALUES (232,'140202','城区','140200'); INSERT INTO hat_area VALUES (233,'140203','矿区','140200'); INSERT INTO hat_area VALUES (234,'140211','南郊区','140200'); INSERT INTO hat_area VALUES (235,'140212','新荣区','140200'); INSERT INTO hat_area VALUES (236,'140221','阳高县','140200');INSERT INTO hat_area VALUES (238,'140223','广灵县','140200'); INSERT INTO hat_area VALUES (239,'140224','灵丘县','140200'); INSERT INTO hat_area VALUES (240,'140225','浑源县','140200'); INSERT INTO hat_area VALUES (241,'140226','左云县','140200'); INSERT INTO hat_area VALUES (242,'140227','大同县','140200'); INSERT INTO hat_area VALUES (243,'140301','市辖区','140300'); INSERT INTO hat_area VALUES (244,'140302','城区','140300'); INSERT INTO hat_area VALUES (245,'140303','矿区','140300'); INSERT INTO hat_area VALUES (246,'140311','郊区','140300'); INSERT INTO hat_area VALUES (247,'140321','平定县','140300'); INSERT INTO hat_area VALUES (248,'140322','盂县','140300'); INSERT INTO hat_area VALUES (249,'140401','市辖区','140400'); INSERT INTO hat_area VALUES (250,'140402','城区','140400'); INSERT INTO hat_area VALUES (251,'140411','郊区','140400'); INSERT INTO hat_area VALUES (252,'140421','长治县','140400'); INSERT INTO hat_area VALUES (253,'140423','襄垣县','140400'); INSERT INTO hat_area VALUES (254,'140424','屯留县','140400'); INSERT INTO hat_area VALUES (255,'140425','平顺县','140400'); INSERT INTO hat_area VALUES (256,'140426','黎城县','140400'); INSERT INTO hat_area VALUES (257,'140427','壶关县','140400'); INSERT INTO hat_area VALUES (258,'140428','长子县','140400'); INSERT INTO hat_area VALUES (259,'140429','武乡县','140400'); INSERT INTO hat_area VALUES (260,'140430','沁县','140400'); INSERT INTO hat_area VALUES (261,'140431','沁源县','140400'); INSERT INTO hat_area VALUES (262,'140481','潞城市','140400'); INSERT INTO hat_area VALUES (263,'140501','市辖区','140500'); INSERT INTO hat_area VALUES (264,'140502','城区','140500'); INSERT INTO hat_area VALUES (265,'140521','沁水县','140500'); INSERT INTO hat_area VALUES (266,'140522','阳城县','140500'); INSERT INTO hat_area VALUES (267,'140524','陵川县','140500'); INSERT INTO hat_area VALUES (268,'140525','泽州县','140500'); INSERT INTO hat_area VALUES (269,'140581','高平市','140500'); INSERT INTO hat_area VALUES (270,'140601','市辖区','140600'); INSERT INTO hat_area VALUES (271,'140602','朔城区','140600'); INSERT INTO hat_area VALUES (272,'140603','平鲁区','140600'); INSERT INTO hat_area VALUES (273,'140621','山阴县','140600'); INSERT INTO hat_area VALUES (274,'140622','应县','140600'); INSERT INTO hat_area VALUES (275,'140623','右玉县','140600'); INSERT INTO hat_area VALUES (276,'140624','怀仁县','140600'); INSERT INTO hat_area VALUES (277,'140701','市辖区','140700'); INSERT INTO hat_area VALUES (278,'140702','榆次区','140700'); INSERT INTO hat_area VALUES (279,'140721','榆社县','140700'); INSERT INTO hat_area VALUES (280,'140722','左权县','140700');INSERT INTO hat_area VALUES (282,'140724','昔阳县','140700'); INSERT INTO hat_area VALUES (283,'140725','寿阳县','140700'); INSERT INTO hat_area VALUES (284,'140726','太谷县','140700'); INSERT INTO hat_area VALUES (285,'140727','祁县','140700'); INSERT INTO hat_area VALUES (286,'140728','平遥县','140700'); INSERT INTO hat_area VALUES (287,'140729','灵石县','140700'); INSERT INTO hat_area VALUES (288,'140781','介休市','140700'); INSERT INTO hat_area VALUES (289,'140801','市辖区','140800'); INSERT INTO hat_area VALUES (290,'140802','盐湖区','140800'); INSERT INTO hat_area VALUES (291,'140821','临猗县','140800'); INSERT INTO hat_area VALUES (292,'140822','万荣县','140800'); INSERT INTO hat_area VALUES (293,'140823','闻喜县','140800'); INSERT INTO hat_area VALUES (294,'140824','稷山县','140800'); INSERT INTO hat_area VALUES (295,'140825','新绛县','140800'); INSERT INTO hat_area VALUES (296,'140826','绛县','140800'); INSERT INTO hat_area VALUES (297,'140827','垣曲县','140800'); INSERT INTO hat_area VALUES (298,'140828','夏县','140800'); INSERT INTO hat_area VALUES (299,'140829','平陆县','140800'); INSERT INTO hat_area VALUES (300,'140830','芮城县','140800'); INSERT INTO hat_area VALUES (301,'140881','永济市','140800'); INSERT INTO hat_area VALUES (302,'140882','河津市','140800'); INSERT INTO hat_area VALUES (303,'140901','市辖区','140900'); INSERT INTO hat_area VALUES (304,'140902','忻府区','140900'); INSERT INTO hat_area VALUES (305,'140921','定襄县','140900'); INSERT INTO hat_area VALUES (306,'140922','五台县','140900'); INSERT INTO hat_area VALUES (307,'140923','代县','140900'); INSERT INTO hat_area VALUES (308,'140924','繁峙县','140900'); INSERT INTO hat_area VALUES (309,'140925','宁武县','140900'); INSERT INTO hat_area VALUES (310,'140926','静乐县','140900'); INSERT INTO hat_area VALUES (311,'140927','神池县','140900'); INSERT INTO hat_area VALUES (312,'140928','五寨县','140900'); INSERT INTO hat_area VALUES (313,'140929','岢岚县','140900'); INSERT INTO hat_area VALUES (314,'140930','河曲县','140900'); INSERT INTO hat_area VALUES (315,'140931','保德县','140900'); INSERT INTO hat_area VALUES (316,'140932','偏关县','140900'); INSERT INTO hat_area VALUES (317,'140981','原平市','140900'); INSERT INTO hat_area VALUES (318,'141001','市辖区','141000'); INSERT INTO hat_area VALUES (319,'141002','尧都区','141000'); INSERT INTO hat_area VALUES (320,'141021','曲沃县','141000'); INSERT INTO hat_area VALUES (321,'141022','翼城县','141000'); INSERT INTO hat_area VALUES (322,'141023','襄汾县','141000'); INSERT INTO hat_area VALUES (323,'141024','洪洞县','141000'); INSERT INTO hat_area VALUES (324,'141025','古县','141000');INSERT INTO hat_area VALUES (326,'141027','浮山县','141000'); INSERT INTO hat_area VALUES (327,'141028','吉县','141000'); INSERT INTO hat_area VALUES (328,'141029','乡宁县','141000'); INSERT INTO hat_area VALUES (329,'141030','大宁县','141000'); INSERT INTO hat_area VALUES (330,'141031','隰县','141000'); INSERT INTO hat_area VALUES (331,'141032','永和县','141000'); INSERT INTO hat_area VALUES (332,'141033','蒲县','141000'); INSERT INTO hat_area VALUES (333,'141034','汾西县','141000'); INSERT INTO hat_area VALUES (334,'141081','侯马市','141000'); INSERT INTO hat_area VALUES (335,'141082','霍州市','141000'); INSERT INTO hat_area VALUES (336,'141101','市辖区','141100'); INSERT INTO hat_area VALUES (337,'141102','离石区','141100'); INSERT INTO hat_area VALUES (338,'141121','文水县','141100'); INSERT INTO hat_area VALUES (339,'141122','交城县','141100'); INSERT INTO hat_area VALUES (340,'141123','兴县','141100'); INSERT INTO hat_area VALUES (341,'141124','临县','141100'); INSERT INTO hat_area VALUES (342,'141125','柳林县','141100'); INSERT INTO hat_area VALUES (343,'141126','石楼县','141100'); INSERT INTO hat_area VALUES (344,'141127','岚县','141100'); INSERT INTO hat_area VALUES (345,'141128','方山县','141100'); INSERT INTO hat_area VALUES (346,'141129','中阳县','141100'); INSERT INTO hat_area VALUES (347,'141130','交口县','141100'); INSERT INTO hat_area VALUES (348,'141181','孝义市','141100'); INSERT INTO hat_area VALUES (349,'141182','汾阳市','141100'); INSERT INTO hat_area VALUES (350,'150101','市辖区','150100'); INSERT INTO hat_area VALUES (351,'150102','新城区','150100'); INSERT INTO hat_area VALUES (352,'150103','回民区','150100'); INSERT INTO hat_area VALUES (353,'150104','玉泉区','150100'); INSERT INTO hat_area VALUES (354,'150105','赛罕区','150100'); INSERT INTO hat_area VALUES (355,'150121','土默特左旗','150100'); INSERT INTO hat_area VALUES (356,'150122','托克托县','150100'); INSERT INTO hat_area VALUES (357,'150123','和林格尔县','150100'); INSERT INTO hat_area VALUES (358,'150124','清水河县','150100'); INSERT INTO hat_area VALUES (359,'150125','武川县','150100'); INSERT INTO hat_area VALUES (360,'150201','市辖区','150200'); INSERT INTO hat_area VALUES (361,'150202','东河区','150200'); INSERT INTO hat_area VALUES (362,'150203','昆都仑区','150200'); INSERT INTO hat_area VALUES (363,'150204','青山区','150200'); INSERT INTO hat_area VALUES (364,'150205','石拐区','150200'); INSERT INTO hat_area VALUES (365,'150206','白云矿区','150200'); INSERT INTO hat_area VALUES (366,'150207','九原区','150200'); INSERT INTO hat_area VALUES (367,'150221','土默特右旗','150200'); INSERT INTO hat_area VALUES (368,'150222','固阳县','150200');。

sql_数据库__省市区_数据建表和数据

sql_数据库__省市区_数据建表和数据预览说明:预览图片所展示的格式为文档的源格式展示,下载源文件没有水印,内容可编辑和复制-- 表的结构areaDROP TABLE Area;CREATE TABLE Area(ID int NOT NULL,AreaID int NOT NULL,AreaName varchar(200)NOT NULL,FatherID int NOT NULL,PRIMARY KEY (ID))DROP TABLE City;CREATE TABLE City(ID int NOT NULL,CityID int NOT NULL,CityName varchar(200)NOT NULL,FatherID int NOT NULL,PRIMARY KEY (ID))---- 导出表中的数据city---- ------------------------------------------------------------ 表的结构province--DROP TABLE Province;CREATE TABLE Province(ID int NOT NULL,ProvinceID int NOT NULL,ProvinceName varchar(200)NOT NULL,PRIMARY KEY (ID))insert Province(ID,ProvinceID,ProvinceName)select 1,110000,'北京市'unionselect 2,120000,'天津市'unionselect 3,130000,'河北省'unionselect 4,140000,'山西省'unionselect 5,150000,'内蒙古自治区'unionselect 6,210000,'辽宁省'unionselect 7,220000,'吉林省'unionselect 8,230000,'黑龙江省'unionselect 9,310000,'上海市'unionselect 10,320000,'江苏省'unionselect 11,330000,'浙江省'unionselect 12,340000,'安徽省'unionselect 13,350000,'福建省'unionselect 14,360000,'江西省'unionselect 15,370000,'山东省'unionselect 16,410000,'河南省'unionselect 17,420000,'湖北省'unionselect 18,430000,'湖南省'unionselect 19,440000,'广东省'unionselect 20,450000,'广西壮族自治区'union select 21,460000,'海南省'unionselect 22,500000,'重庆市'unionselect 23,510000,'四川省'unionselect 24,520000,'贵州省'unionselect 25,530000,'云南省'unionselect 26,540000,'西藏自治区'unionselect 27,610000,'陕西省'unionselect 28,620000,'甘肃省'unionselect 29,630000,'青海省'unionselect 30,640000,'宁夏回族自治区'union select 31,650000,'新疆维吾尔自治区'union select 32,710000,'台湾省'unionselect 33,810000,'香港特别行政区'union select 34,820000,'澳门特别行政区'INSERT City(ID,CityID,CityName,FatherID) select 1,110100,'市辖区',110000 union select 2,110200,'县',110000 union select 3,120100,'市辖区',120000 union select 4,120200,'县',120000 unionselect 5,130100,'石家庄市',130000 union select 6,130200,'唐山市',130000 union select 7,130300,'秦皇岛市',130000 union select 8,130400,'邯郸市',130000 union select 9,130500,'邢台市',130000 union select 10,130600,'保定市',130000 unionselect 12,130800,'承德市',130000 union select 13,130900,'沧州市',130000 union select 14,131000,'廊坊市',130000 union select 15,131100,'衡水市',130000 union select 16,140100,'太原市',140000 union select 17,140200,'大同市',140000 union select 18,140300,'阳泉市',140000 union select 19,140400,'长治市',140000 union select 20,140500,'晋城市',140000 union select 21,140600,'朔州市',140000 union select 22,140700,'晋中市',140000 union select 23,140800,'运城市',140000 union select 24,140900,'忻州市',140000 union select 25,141000,'临汾市',140000 union select 26,141100,'吕梁市',140000INSERT City (ID,CityID,CityName,FatherID) select 27,150100,'呼和浩特市',150000 union select 28,150200,'包头市',150000 union select 29,150300,'乌海市',150000 union select 30,150400,'赤峰市',150000 union select 31,150500,'通辽市',150000 union select 32,150600,'鄂尔多斯市',150000 union select 33,150700,'呼伦贝尔市',150000 union select 34,150800,'巴彦淖尔市',150000 union select 35,150900,'乌兰察布市',150000 union select 36,152200,'兴安盟',150000 union select 37,152500,'锡林郭勒盟',150000 union select 38,152900,'阿拉善盟',150000 union select 39,210100,'沈阳市',210000 union select 40,210200,'大连市',210000 union select 41,210300,'鞍山市',210000 union select 42,210400,'抚顺市',210000 union select 43,210500,'本溪市',210000 union select 44,210600,'丹东市',210000 union select 45,210700,'锦州市',210000 union select 46,210800,'营口市',210000 union select 47,210900,'阜新市',210000 union select 48,211000,'辽阳市',210000 union select 49,211100,'盘锦市',210000 union select 50,211200,'铁岭市',210000 union select 51,211300,'朝阳市',210000 unionselect 53,220100,'长春市',220000 unionselect 54,220200,'吉林市',220000 unionselect 55,220300,'四平市',220000 unionselect 56,220400,'辽源市',220000 unionselect 57,220500,'通化市',220000 unionselect 58,220600,'白山市',220000 unionselect 59,220700,'松原市',220000 unionselect 60,220800,'白城市',220000 unionselect 61,222400,'延边朝鲜族自治州',220000 union select 62,230100,'哈尔滨市',230000 unionselect 63,230200,'齐齐哈尔市',230000 union select 64,230300,'鸡西市',230000 unionselect 65,230400,'鹤岗市',230000 unionselect 66,230500,'双鸭山市',230000 unionselect 67,230600,'大庆市',230000 unionselect 68,230700,'伊春市',230000 unionselect 69,230800,'佳木斯市',230000 unionselect 70,230900,'七台河市',230000 unionselect 71,231000,'牡丹江市',230000 unionselect 72,231100,'黑河市',230000 unionselect 73,231200,'绥化市',230000 unionselect 74,232700,'大兴安岭地区',230000 union select 75,310100,'市辖区',310000 unionselect 76,310200,'县',310000 unionselect 77,320100,'南京市',320000 unionselect 78,320200,'无锡市',320000 unionselect 79,320300,'徐州市',320000 unionselect 80,320400,'常州市',320000 unionselect 81,320500,'苏州市',320000 unionselect 82,320600,'南通市',320000 unionselect 83,320700,'连云港市',320000 unionselect 84,320800,'淮安市',320000 unionselect 85,320900,'盐城市',320000 unionselect 86,321000,'扬州市',320000 unionselect 87,321100,'镇江市',320000 unionselect 88,321200,'泰州市',320000 unionselect 89,321300,'宿迁市',320000 unionselect 90,330100,'杭州市',330000 unionselect 91,330200,'宁波市',330000 unionselect 92,330300,'温州市',330000 unionselect 93,330400,'嘉兴市',330000 unionselect 94,330500,'湖州市',330000 unionselect 95,330600,'绍兴市',330000 unionselect 97,330800,'衢州市',330000 union select 98,330900,'舟山市',330000 union select 99,331000,'台州市',330000 union select 100,331100,'丽水市',330000 union select 101,340100,'合肥市',340000 union select 102,340200,'芜湖市',340000 union select 103,340300,'蚌埠市',340000 union select 104,340400,'淮南市',340000 union select 105,340500,'马鞍山市',340000 union select 106,340600,'淮北市',340000 union select 107,340700,'铜陵市',340000 union select 108,340800,'安庆市',340000 union select 109,341000,'黄山市',340000 union select 110,341100,'滁州市',340000 union select 111,341200,'阜阳市',340000 union select 112,341300,'宿州市',340000 union select 113,341400,'巢湖市',340000 union select 114,341500,'六安市',340000 union select 115,341600,'亳州市',340000 union select 116,341700,'池州市',340000 union select 117,341800,'宣城市',340000 union select 118,350100,'福州市',350000 union select 119,350200,'厦门市',350000 union select 120,350300,'莆田市',350000 union select 121,350400,'三明市',350000 union select 122,350500,'泉州市',350000 union select 123,350600,'漳州市',350000 union select 124,350700,'南平市',350000 union select 125,350800,'龙岩市',350000 union select 126,350900,'宁德市',350000INSERT City (ID,CityID,CityName,FatherID) select 127,360100,'南昌市',360000 union select 128,360200,'景德镇市',360000 union select 129,360300,'萍乡市',360000 union select 130,360400,'九江市',360000 union select 131,360500,'新余市',360000 union select 132,360600,'鹰潭市',360000 union select 133,360700,'赣州市',360000 union select 134,360800,'吉安市',360000 union select 135,360900,'宜春市',360000 union select 136,361000,'抚州市',360000 union select 137,361100,'上饶市',360000 unionselect 139,370200,'青岛市',370000 union select 140,370300,'淄博市',370000 union select 141,370400,'枣庄市',370000 union select 142,370500,'东营市',370000 union select 143,370600,'烟台市',370000 union select 144,370700,'潍坊市',370000 union select 145,370800,'济宁市',370000 union select 146,370900,'泰安市',370000 union select 147,371000,'威海市',370000 union select 148,371100,'日照市',370000 union select 149,371200,'莱芜市',370000 union select 150,371300,'临沂市',370000 union select 151,371400,'德州市',370000 union select 152,371500,'聊城市',370000 union select 153,371600,'滨州市',370000 union select 154,371700,'荷泽市',370000 union select 155,410100,'郑州市',410000 union select 156,410200,'开封市',410000 union select 157,410300,'洛阳市',410000 union select 158,410400,'平顶山市',410000 union select 159,410500,'安阳市',410000 union select 160,410600,'鹤壁市',410000 union select 161,410700,'新乡市',410000 union select 162,410800,'焦作市',410000 union select 163,410900,'濮阳市',410000 union select 164,411000,'许昌市',410000 union select 165,411100,'漯河市',410000 union select 166,411200,'三门峡市',410000 union select 167,411300,'南阳市',410000 union select 168,411400,'商丘市',410000 union select 169,411500,'信阳市',410000 union select 170,411600,'周口市',410000 union select 171,411700,'驻马店市',410000INSERT City (ID,CityID,CityName,FatherID) select 172,420100,'武汉市',420000 union select 173,420200,'黄石市',420000 union select 174,420300,'十堰市',420000 union select 175,420500,'宜昌市',420000 union select 176,420600,'襄樊市',420000 union select 177,420700,'鄂州市',420000 union select 178,420800,'荆门市',420000 unionselect 180,421000,'荆州市',420000 unionselect 181,421100,'黄冈市',420000 unionselect 182,421200,'咸宁市',420000 unionselect 183,421300,'随州市',420000 unionselect 184,422800,'恩施土家族苗族自治州',420000 union select 185,429000,'省直辖行政单位',420000 union select 186,430100,'长沙市',430000 unionselect 187,430200,'株洲市',430000 unionselect 188,430300,'湘潭市',430000 unionselect 189,430400,'衡阳市',430000 unionselect 190,430500,'邵阳市',430000 unionselect 191,430600,'岳阳市',430000 unionselect 192,430700,'常德市',430000 unionselect 193,430800,'张家界市',430000 unionselect 194,430900,'益阳市',430000 unionselect 195,431000,'郴州市',430000 unionselect 196,431100,'永州市',430000 unionselect 197,431200,'怀化市',430000 unionselect 198,431300,'娄底市',430000 unionselect 199,433100,'湘西土家族苗族自治州',430000 union select 200,440100,'广州市',440000 unionselect 201,440200,'韶关市',440000 unionselect 202,440300,'深圳市',440000 unionselect 203,440400,'珠海市',440000 unionselect 204,440500,'汕头市',440000 unionselect 205,440600,'佛山市',440000 unionselect 206,440700,'江门市',440000 unionselect 207,440800,'湛江市',440000 unionselect 208,440900,'茂名市',440000 unionselect 209,441200,'肇庆市',440000 unionselect 210,441300,'惠州市',440000 unionselect 211,441400,'梅州市',440000 unionselect 212,441500,'汕尾市',440000 unionselect 213,441600,'河源市',440000 unionselect 214,441700,'阳江市',440000 unionselect 215,441800,'清远市',440000 unionselect 216,441900,'东莞市',440000 unionselect 217,442000,'中山市',440000 unionselect 218,445100,'潮州市',440000 unionselect 219,445200,'揭阳市',440000 unionselect 220,445300,'云浮市',440000 unionselect 221,450100,'南宁市',450000 unionselect 222,450200,'柳州市',450000 unionselect 224,450400,'梧州市',450000 unionselect 225,450500,'北海市',450000INSERT City (ID,CityID,CityName,FatherID)select 226,450600,'防城港市',450000 unionselect 227,450700,'钦州市',450000 unionselect 228,450800,'贵港市',450000 unionselect 229,450900,'玉林市',450000 unionselect 230,451000,'百色市',450000 unionselect 231,451100,'贺州市',450000 unionselect 232,451200,'河池市',450000 unionselect 233,451300,'来宾市',450000 unionselect 234,451400,'崇左市',450000 unionselect 235,460100,'海口市',460000 unionselect 236,460200,'三亚市',460000 unionselect 237,469000,'省直辖县级行政单位',460000 union select 238,500100,'市辖区',500000 unionselect 239,500200,'县',500000 unionselect 240,500300,'市',500000 unionselect 241,510100,'成都市',510000 unionselect 242,510300,'自贡市',510000 unionselect 243,510400,'攀枝花市',510000 unionselect 244,510500,'泸州市',510000 unionselect 245,510600,'德阳市',510000 unionselect 246,510700,'绵阳市',510000 unionselect 247,510800,'广元市',510000 unionselect 248,510900,'遂宁市',510000 unionselect 249,511000,'内江市',510000 unionselect 250,511100,'乐山市',510000 unionselect 251,511300,'南充市',510000 unionselect 252,511400,'眉山市',510000 unionselect 253,511500,'宜宾市',510000 unionselect 254,511600,'广安市',510000 unionselect 255,511700,'达州市',510000 unionselect 256,511800,'雅安市',510000 unionselect 257,511900,'巴中市',510000 unionselect 258,512000,'资阳市',510000 unionselect 259,513200,'阿坝藏族羌族自治州',510000 union select 260,513300,'甘孜藏族自治州',510000 union select 261,513400,'凉山彝族自治州',510000 union select 262,520100,'贵阳市',520000 unionselect 263,520200,'六盘水市',520000INSERT City (ID,CityID,CityName,FatherID)select 264,520300,'遵义市',520000 unionselect 265,520400,'安顺市',520000 unionselect 266,522200,'铜仁地区',520000 unionselect 267,522300,'黔西南布依族苗族自治州',520000 union select 268,522400,'毕节地区',520000 unionselect 269,522600,'黔东南苗族侗族自治州',520000 union select 270,522700,'黔南布依族苗族自治州',520000 union select 271,530100,'昆明市',530000 unionselect 272,530300,'曲靖市',530000 unionselect 273,530400,'玉溪市',530000 unionselect 274,530500,'保山市',530000 unionselect 275,530600,'昭通市',530000 unionselect 276,530700,'丽江市',530000 unionselect 277,530800,'思茅市',530000 unionselect 278,530900,'临沧市',530000 unionselect 279,532300,'楚雄彝族自治州',530000 unionselect 280,532500,'红河哈尼族彝族自治州',530000 union select 281,532600,'文山壮族苗族自治州',530000 union select 282,532800,'西双版纳傣族自治州',530000 union select 283,532900,'大理白族自治州',530000 unionselect 284,533100,'德宏傣族景颇族自治州',530000 union select 285,533300,'怒江傈僳族自治州',530000 union select 286,533400,'迪庆藏族自治州',530000 unionselect 287,540100,'拉萨市',540000 unionselect 288,542100,'昌都地区',540000 unionselect 289,542200,'山南地区',540000 unionselect 290,542300,'日喀则地区',540000 unionselect 291,542400,'那曲地区',540000 unionselect 292,542500,'阿里地区',540000 unionselect 293,542600,'林芝地区',540000INSERT City (ID,CityID,CityName,FatherID)select 294,610100,'西安市',610000 unionselect 295,610200,'铜川市',610000 unionselect 296,610300,'宝鸡市',610000 unionselect 297,610400,'咸阳市',610000 unionselect 298,610500,'渭南市',610000 unionselect 299,610600,'延安市',610000 unionselect 300,610700,'汉中市',610000 unionselect 301,610800,'榆林市',610000 unionselect 302,610900,'安康市',610000 unionselect 303,611000,'商洛市',610000 unionselect 304,620100,'兰州市',620000 unionselect 305,620200,'嘉峪关市',620000 unionselect 306,620300,'金昌市',620000 unionselect 307,620400,'白银市',620000 unionselect 308,620500,'天水市',620000 unionselect 309,620600,'武威市',620000 unionselect 310,620700,'张掖市',620000 unionselect 311,620800,'平凉市',620000 unionselect 312,620900,'酒泉市',620000 unionselect 313,621000,'庆阳市',620000 unionselect 314,621100,'定西市',620000 unionselect 315,621200,'陇南市',620000 unionselect 316,622900,'临夏回族自治州',620000 unionselect 317,623000,'甘南藏族自治州',620000 unionselect 318,630100,'西宁市',630000 unionselect 319,632100,'海东地区',630000 unionselect 320,632200,'海北藏族自治州',630000 unionselect 321,632300,'黄南藏族自治州',630000 unionselect 322,632500,'海南藏族自治州',630000 unionselect 323,632600,'果洛藏族自治州',630000 unionselect 324,632700,'玉树藏族自治州',630000INSERT City (ID,CityID,CityName,FatherID)select 325,632800,'海西蒙古族藏族自治州',630000 union select 326,640100,'银川市',640000 unionselect 327,640200,'石嘴山市',640000 unionselect 328,640300,'吴忠市',640000 unionselect 329,640400,'固原市',640000 unionselect 330,640500,'中卫市',640000 unionselect 331,650100,'乌鲁木齐市',650000 unionselect 332,650200,'克拉玛依市',650000 unionselect 333,652100,'吐鲁番地区',650000 unionselect 334,652200,'哈密地区',650000 unionselect 335,652300,'昌吉回族自治州',650000 unionselect 336,652700,'博尔塔拉蒙古自治州',650000 union select 337,652800,'巴音郭楞蒙古自治州',650000 union select 338,652900,'阿克苏地区',650000INSERT City (ID,CityID,CityName,FatherID)select 339,653000,'克孜勒苏柯尔克孜自治州',650000 union select 340,653100,'喀什地区',650000 unionselect 341,653200,'和田地区',650000 unionselect 342,654000,'伊犁哈萨克自治州',650000 union select 343,654200,'塔城地区',650000 unionselect 344,654300,'阿勒泰地区',650000 union select 345,659000,'省直辖行政单位',650000INSERT INTO Area (ID,AreaID,AreaName,FatherID) select 1,110101,'东城区',110100 unionselect 2,110102,'西城区',110100 unionselect 3,110103,'崇文区',110100 unionselect 4,110104,'宣武区',110100 unionselect 5,110105,'朝阳区',110100 unionselect 6,110106,'丰台区',110100 unionselect 7,110107,'石景山区',110100 unionselect 8,110108,'海淀区',110100 unionselect 9,110109,'门头沟区',110100 unionselect 10,110111,'房山区',110100 unionselect 11,110112,'通州区',110100 unionselect 12,110113,'顺义区',110100 unionselect 13,110114,'昌平区',110100 unionselect 14,110115,'大兴区',110100 unionselect 15,110116,'怀柔区',110100 unionselect 16,110117,'平谷区',110100 unionselect 17,110228,'密云县',110200 unionselect 18,110229,'延庆县',110200 unionselect 19,120101,'和平区',120100 unionselect 20,120102,'河东区',120100 unionselect 21,120103,'河西区',120100 unionselect 22,120104,'南开区',120100 unionselect 23,120105,'河北区',120100 unionselect 24,120106,'红桥区',120100 unionselect 25,120107,'塘沽区',120100 unionselect 26,120108,'汉沽区',120100 unionselect 27,120109,'大港区',120100 unionselect 28,120110,'东丽区',120100 unionselect 29,120111,'西青区',120100 unionselect 30,120112,'津南区',120100 unionselect 31,120113,'北辰区',120100 unionselect 32,120114,'武清区',120100 unionselect 33,120115,'宝坻区',120100 unionselect 34,120221,'宁河县',120200 unionselect 35,120223,'静海县',120200 unionselect 36,120225,'蓟县',120200 unionselect 37,130101,'市辖区',130100 unionselect 39,130103,'桥东区',130100 unionselect 40,130104,'桥西区',130100 unionselect 41,130105,'新华区',130100 unionselect 42,130107,'井陉矿区',130100 union select 43,130108,'裕华区',130100 unionselect 44,130121,'井陉县',130100 union select 45,130123,'正定县',130100 union select 46,130124,'栾城县',130100 union select 47,130125,'行唐县',130100 union select 48,130126,'灵寿县',130100 union select 49,130127,'高邑县',130100 union select 50,130128,'深泽县',130100 union select 51,130129,'赞皇县',130100 union select 52,130130,'无极县',130100 union select 53,130131,'平山县',130100 union select 54,130132,'元氏县',130100 union select 55,130133,'赵县',130100 union select 56,130181,'辛集市',130100 union select 57,130182,'藁城市',130100 union select 58,130183,'晋州市',130100 union select 59,130184,'新乐市',130100 union select 60,130185,'鹿泉市',130100 union select 61,130201,'市辖区',130200 union select 62,130202,'路南区',130200 union select 63,130203,'路北区',130200 union select 64,130204,'古冶区',130200 union select 65,130205,'开平区',130200 union select 66,130207,'丰南区',130200 union select 67,130208,'丰润区',130200 union select 68,130223,'滦县',130200 union select 69,130224,'滦南县',130200 union select 70,130225,'乐亭县',130200 union select 71,130227,'迁西县',130200 union select 72,130229,'玉田县',130200 union select 73,130230,'唐海县',130200 unionselect 74,130281,'遵化市',130200 unionselect 75,130283,'迁安市',130200 unionselect 76,130301,'市辖区',130300 unionselect 77,130302,'海港区',130300 unionselect 78,130303,'山海关区',130300 union select 79,130304,'北戴河区',130300 union select 80,130321,'青龙满族自治县',130300 union select 81,130322,'昌黎县',130300 unionselect 83,130324,'卢龙县',130300 union select 84,130401,'市辖区',130400 union select 85,130402,'邯山区',130400 union select 86,130403,'丛台区',130400 union select 87,130404,'复兴区',130400 union select 88,130406,'峰峰矿区',130400 union select 89,130421,'邯郸县',130400 union select 90,130423,'临漳县',130400 union select 91,130424,'成安县',130400 union select 92,130425,'大名县',130400 union select 93,130426,'涉县',130400 union select 94,130427,'磁县',130400 union select 95,130428,'肥乡县',130400 union select 96,130429,'永年县',130400 union select 97,130430,'邱县',130400 union select 98,130431,'鸡泽县',130400 union select 99,130432,'广平县',130400 union select 100,130433,'馆陶县',130400 union select 101,130434,'魏县',130400 union select 102,130435,'曲周县',130400 union select 103,130481,'武安市',130400 union select 104,130501,'市辖区',130500 union select 105,130502,'桥东区',130500 union select 106,130503,'桥西区',130500 union select 107,130521,'邢台县',130500 union select 108,130522,'临城县',130500 union select 109,130523,'内丘县',130500 union select 110,130524,'柏乡县',130500 union select 111,130525,'隆尧县',130500 union select 112,130526,'任县',130500 union select 113,130527,'南和县',130500 union select 114,130528,'宁晋县',130500 union select 115,130529,'巨鹿县',130500 union select 116,130530,'新河县',130500 union select 117,130531,'广宗县',130500 union select 118,130532,'平乡县120,130534,'清河县',130500 union select 121,130535,'临西县',130500 union select 122,130581,'南宫市',130500 union select 123,130582,'沙河市',130500 union select 124,130601,'市辖区',130600 union select 125,130602,'新市区',130600 union select 127,130604,'南市区',130600 union select 128,130621,'满城县',130600 union select 129,130622,'清苑县',130600 union select 130,130623,'涞水县',130600 union select 131,130624,'阜平县',130600 union select 132,130625,'徐水县',130600 union select 133,130626,'定兴县',130600 union select 134,130627,'唐县',130600 union select 135,130628,'高阳县',130600 union select 136,130629,'容城县',130600 union select 137,130630,'涞源县',130600 union select 138,130631,'望都县',130600 union select 139,130632,'安新县',130600 union select 140,130633,'易县',130600 union select 141,130634,'曲阳县',130600 union select 142,130635,'蠡县',130600 union select 143,130636,'顺平县',130600 union select 144,130637,'博野县',130600 union select 145,130638,'雄县',130600 union select 146,130681,'涿州市',130600 union select 147,130682,'定州市',130600 union select 148,130683,'安国市',130600 union select 149,130684,'高碑店市',130600 union select 150,130701,'市辖区',130700 union select 151,130702,'桥东区',130700 union select 152,130703,'桥西区',130700 union select 153,130705,'宣化区',130700 union select 154,130706,'下花园区',130700 union select 155,130721,'宣化县',130700 union select 156,130722,'张北县',130700 union select 157,130723,'康保县',130700 union select 158,130724,'沽源县',130700 union select 159,130725,'尚义县',130700 union select 160,130726,'蔚县',130700 union select 161,130727,'阳原县',130700 union select 162,130728,'怀安县',130700 union select 163,130729,'万全县',130700 union select 164,130730,'怀来县166,130732,'赤城县',130700 union select 167,130733,'崇礼县',130700 union select 168,130801,'市辖区',130800 union select 169,130802,'双桥区',130800 unionselect 171,130804,'鹰手营子矿区',130800 unionselect 172,130821,'承德县',130800 unionselect 173,130822,'兴隆县',130800 unionselect 174,130823,'平泉县',130800 unionselect 175,130824,'滦平县',130800 unionselect 176,130825,'隆化县',130800 unionselect 177,130826,'丰宁满族自治县',130800 union select 178,130827,'宽城满族自治县',130800 union select 179,130828,'围场满族蒙古族自治县',130800 union select 180,130901,'市辖区',130900 unionselect 181,130902,'新华区',130900 unionselect 182,130903,'运河区',130900 unionselect 183,130921,'沧县',130900 unionselect 184,130922,'青县',130900 unionselect 185,130923,'东光县',130900 unionselect 186,130924,'海兴县',130900 unionselect 187,130925,'盐山县',130900 unionselect 188,130926,'肃宁县',130900 unionselect 189,130927,'南皮县',130900 unionselect 190,130928,'吴桥县',130900 unionselect 191,130929,'献县',130900 unionselect 192,130930,'孟村回族自治县',130900 union select 193,130981,'泊头市',130900 unionselect 194,130982,'任丘市',130900 unionselect 195,130983,'黄骅市',130900 unionselect 196,130984,'河间市',130900 unionselect 197,131001,'市辖区',131000 unionselect 198,131002,'安次区',131000 unionselect 199,131003,'广阳区',131000 unionselect 200,131022,'固安县',131000 unionselect 201,131023,'永清县',131000 unionselect 202,131024,'香河县',131000 unionselect 203,131025,'大城县',131000 unionselect 204,131026,'文安县',131000 unionselect 205,131028,'大厂回族自治县',131000 union select 206,131081,'霸州市',131000 unionselect 207,131082,'三河市',131000 unionselect 208,131101,'市辖区',131100 unionselect 209,131102,'桃城区',131100 unionselect 210,131121,'枣强县',131100 unionselect 211,131122,'武邑县',131100 unionselect 212,131123,'武强县',131100 unionselect 213,131124,'饶阳县',131100 unionselect 215,131126,'故城县',131100 union select 216,131127,'景县',131100 union select 217,131128,'阜城县',131100 union select 218,131181,'冀州市',131100 union select 219,131182,'深州市',131100 union select 220,140101,'市辖区',140100 union select 221,140105,'小店区',140100 union select 222,140106,'迎泽区',140100 union select 223,140107,'杏花岭区',140100 union select 224,140108,'尖草坪区',140100 union select 225,140109,'万柏林区',140100 union select 226,140110,'晋源区',140100 union select 227,140121,'清徐县',140100 union select 228,140122,'阳曲县',140100 union select 229,140123,'娄烦县',140100 union select 230,140181,'古交市',140100 union select 231,140201,'市辖区',140200 union select 232,140202,'城区',140200 union select 233,140203,'矿区',140200 union select 234,140211,'南郊区。

全国省市县SQL数据库(大全)

全国省市县SQL数据库（大全）创建表reate table city(id int(11) primary key not null default 0pid int(11) default nullcityname varchar(255) default nulltype int(11) default null);插入数据INSERT INTO `city` VALUES ('1' '0' '中国' '0'); INSERT INTO `city` VALUES ('2' '1' '北京' '1'); INSERT INTO `city` VALUES ('3' '1' '安徽' '1'); INSERT INTO `city` VALUES ('4' '1' '福建' '1'); INSERT INTO `city` VALUES ('5' '1' '甘肃' '1'); INSERT INTO `city` VALUES ('6' '1' '广东' '1'); INSERT INTO `city` VALUES ('7' '1' '广西' '1'); INSERT INTO `city` VALUES ('8' '1' '贵州' '1'); INSERT INTO `city` VALUES ('9' '1' '海南' '1'); INSERT INTO `city` VALUES ('10' '1' '河北' '1'); INSERT INTO `city` VALUES ('11' '1' '河南' '1'); INSERT INTO `city` VALUES ('12' '1' '黑龙江' '1'); INSERT INTO `city` VALUES ('13' '1' '湖北' '1'); INSERT INTO `city` VALUES ('14' '1' '湖南' '1'); INSERT INTO `city` VALUES ('15' '1' '吉林' '1'); INSERT INTO `city` VALUES ('16' '1' '江苏' '1'); INSERT INTO `city` VALUES ('17' '1' '江西' '1'); INSERT INTO `city` VALUES ('18' '1' '辽宁' '1'); INSERT INTO `city` VALUES ('19' '1' '内蒙古' '1'); INSERT INTO `city` VALUES ('20' '1' '宁夏' '1'); INSERT INTO `city` VALUES ('21' '1' '青海' '1'); INSERT INTO `city` VALUES ('22' '1' '山东' '1'); INSERT INTO `city` VALUES ('23' '1' '山西' '1'); INSERT INTO `city` VALUES ('24' '1' '陕西' '1'); INSERT INTO `city` VALUES ('25' '1' '上海' '1'); INSERT INTO `city` VALUES ('26' '1' '四川' '1'); INSERT INTO `city` VALUES ('27' '1' '天津' '1'); INSERT INTO `city` VALUES ('28' '1' '西藏' '1'); INSERT INTO `city` VALUES ('29' '1' '新疆' '1'); INSERT INTO `city` VALUES ('30' '1' '云南' '1'); INSERT INTO `city` VALUES ('31' '1' '浙江' '1'); INSERT INTO `city` VALUES ('32' '1' '重庆' '1');INSERT INTO `city` VALUES ('34' '1' '澳门' '1'); INSERT INTO `city` VALUES ('35' '1' '台湾' '1'); INSERT INTO `city` VALUES ('36' '3' '安庆' '2'); INSERT INTO `city` VALUES ('37' '3' '蚌埠' '2'); INSERT INTO `city` VALUES ('38' '3' '巢湖' '2'); INSERT INTO `city` VALUES ('39' '3' '池州' '2'); INSERT INTO `city` VALUES ('40' '3' '滁州' '2'); INSERT INTO `city` VALUES ('41' '3' '阜阳' '2'); INSERT INTO `city` VALUES ('42' '3' '淮北' '2'); INSERT INTO `city` VALUES ('43' '3' '淮南' '2'); INSERT INTO `city` VALUES ('44' '3' '黄山' '2'); INSERT INTO `city` VALUES ('45' '3' '六安' '2'); INSERT INTO `city` VALUES ('46' '3' '马鞍山' '2'); INSERT INTO `city` VALUES ('47' '3' '宿州' '2'); INSERT INTO `city` VALUES ('48' '3' '铜陵' '2'); INSERT INTO `city` VALUES ('49' '3' '芜湖' '2'); INSERT INTO `city` VALUES ('50' '3' '宣城' '2'); INSERT INTO `city` VALUES ('51' '3' '亳州' '2'); INSERT INTO `city` VALUES ('52' '2' '市辖区' '2'); INSERT INTO `city` VALUES ('53' '4' '福州' '2'); INSERT INTO `city` VALUES ('54' '4' '龙岩' '2'); INSERT INTO `city` VALUES ('55' '4' '南平' '2'); INSERT INTO `city` VALUES ('56' '4' '宁德' '2'); INSERT INTO `city` VALUES ('57' '4' '莆田' '2'); INSERT INTO `city` VALUES ('58' '4' '泉州' '2'); INSERT INTO `city` VALUES ('59' '4' '三明' '2'); INSERT INTO `city` VALUES ('60' '4' '厦门' '2'); INSERT INTO `city` VALUES ('61' '4' '漳州' '2'); INSERT INTO `city` VALUES ('62' '5' '兰州' '2'); INSERT INTO `city` VALUES ('63' '5' '白银' '2'); INSERT INTO `city` VALUES ('64' '5' '定西' '2'); INSERT INTO `city` VALUES ('65' '5' '甘南' '2'); INSERT INTO `city` VALUES ('66' '5' '嘉峪关' '2'); INSERT INTO `city` VALUES ('67' '5' '金昌' '2'); INSERT INTO `city` VALUES ('68' '5' '酒泉' '2'); INSERT INTO `city` VALUES ('69' '5' '临夏' '2'); INSERT INTO `city` VALUES ('70' '5' '陇南' '2'); INSERT INTO `city` VALUES ('71' '5' '平凉' '2'); INSERT INTO `city` VALUES ('72' '5' '庆阳' '2');INSERT INTO `city` VALUES ('74' '5' '武威' '2'); INSERT INTO `city` VALUES ('75' '5' '张掖' '2'); INSERT INTO `city` VALUES ('76' '6' '广州' '2'); INSERT INTO `city` VALUES ('77' '6' '深圳' '2'); INSERT INTO `city` VALUES ('78' '6' '潮州' '2'); INSERT INTO `city` VALUES ('79' '6' '东莞' '2'); INSERT INTO `city` VALUES ('80' '6' '佛山' '2'); INSERT INTO `city` VALUES ('81' '6' '河源' '2'); INSERT INTO `city` VALUES ('82' '6' '惠州' '2'); INSERT INTO `city` VALUES ('83' '6' '江门' '2'); INSERT INTO `city` VALUES ('84' '6' '揭阳' '2'); INSERT INTO `city` VALUES ('85' '6' '茂名' '2'); INSERT INTO `city` VALUES ('86' '6' '梅州' '2'); INSERT INTO `city` VALUES ('87' '6' '清远' '2'); INSERT INTO `city` VALUES ('88' '6' '汕头' '2'); INSERT INTO `city` VALUES ('89' '6' '汕尾' '2'); INSERT INTO `city` VALUES ('90' '6' '韶关' '2'); INSERT INTO `city` VALUES ('91' '6' '阳江' '2'); INSERT INTO `city` VALUES ('92' '6' '云浮' '2'); INSERT INTO `city` VALUES ('93' '6' '湛江' '2'); INSERT INTO `city` VALUES ('94' '6' '肇庆' '2'); INSERT INTO `city` VALUES ('95' '6' '中山' '2'); INSERT INTO `city` VALUES ('96' '6' '珠海' '2'); INSERT INTO `city` VALUES ('97' '7' '南宁' '2'); INSERT INTO `city` VALUES ('98' '7' '桂林' '2'); INSERT INTO `city` VALUES ('99' '7' '百色' '2'); INSERT INTO `city` VALUES ('100' '7' '北海' '2'); INSERT INTO `city` VALUES ('101' '7' '崇左' '2'); INSERT INTO `city` VALUES ('102' '7' '防城港' '2'); INSERT INTO `city` VALUES ('103' '7' '贵港' '2'); INSERT INTO `city` VALUES ('104' '7' '河池' '2'); INSERT INTO `city` VALUES ('105' '7' '贺州' '2'); INSERT INTO `city` VALUES ('106' '7' '来宾' '2'); INSERT INTO `city` VALUES ('107' '7' '柳州' '2'); INSERT INTO `city` VALUES ('108' '7' '钦州' '2'); INSERT INTO `city` VALUES ('109' '7' '梧州' '2'); INSERT INTO `city` VALUES ('110' '7' '玉林' '2'); INSERT INTO `city` VALUES ('111' '8' '贵阳' '2'); INSERT INTO `city` VALUES ('112' '8' '安顺' '2');INSERT INTO `city` VALUES ('114' '8' '六盘水' '2'); INSERT INTO `city` VALUES ('115' '8' '黔东南' '2'); INSERT INTO `city` VALUES ('116' '8' '黔南' '2'); INSERT INTO `city` VALUES ('117' '8' '黔西南' '2'); INSERT INTO `city` VALUES ('118' '8' '铜仁' '2'); INSERT INTO `city` VALUES ('119' '8' '遵义' '2'); INSERT INTO `city` VALUES ('120' '9' '海口' '2'); INSERT INTO `city` VALUES ('121' '9' '三亚' '2'); INSERT INTO `city` VALUES ('122' '9' '白沙' '2'); INSERT INTO `city` VALUES ('123' '9' '保亭' '2'); INSERT INTO `city` VALUES ('124' '9' '昌江' '2'); INSERT INTO `city` VALUES ('125' '9' '澄迈县' '2'); INSERT INTO `city` VALUES ('126' '9' '定安县' '2'); INSERT INTO `city` VALUES ('127' '9' '东方' '2'); INSERT INTO `city` VALUES ('128' '9' '乐东' '2'); INSERT INTO `city` VALUES ('129' '9' '临高县' '2'); INSERT INTO `city` VALUES ('130' '9' '陵水' '2'); INSERT INTO `city` VALUES ('131' '9' '琼海' '2'); INSERT INTO `city` VALUES ('132' '9' '琼中' '2'); INSERT INTO `city` VALUES ('133' '9' '屯昌县' '2'); INSERT INTO `city` VALUES ('134' '9' '万宁' '2'); INSERT INTO `city` VALUES ('135' '9' '文昌' '2'); INSERT INTO `city` VALUES ('136' '9' '五指山' '2'); INSERT INTO `city` VALUES ('137' '9' '儋州' '2'); INSERT INTO `city` VALUES ('138' '10' '石家庄' '2'); INSERT INTO `city` VALUES ('139' '10' '保定' '2'); INSERT INTO `city` VALUES ('140' '10' '沧州' '2'); INSERT INTO `city` VALUES ('141' '10' '承德' '2'); INSERT INTO `city` VALUES ('142' '10' '邯郸' '2'); INSERT INTO `city` VALUES ('143' '10' '衡水' '2'); INSERT INTO `city` VALUES ('144' '10' '廊坊' '2'); INSERT INTO `city` VALUES ('145' '10' '秦皇岛' '2'); INSERT INTO `city` VALUES ('146' '10' '唐山' '2'); INSERT INTO `city` VALUES ('147' '10' '邢台' '2'); INSERT INTO `city` VALUES ('148' '10' '张家口' '2'); INSERT INTO `city` VALUES ('149' '11' '郑州' '2'); INSERT INTO `city` VALUES ('150' '11' '洛阳' '2'); INSERT INTO `city` VALUES ('151' '11' '开封' '2'); INSERT INTO `city` VALUES ('152' '11' '安阳' '2');INSERT INTO `city` VALUES ('154' '11' '济源' '2'); INSERT INTO `city` VALUES ('155' '11' '焦作' '2'); INSERT INTO `city` VALUES ('156' '11' '南阳' '2'); INSERT INTO `city` VALUES ('157' '11' '平顶山' '2'); INSERT INTO `city` VALUES ('158' '11' '三门峡' '2'); INSERT INTO `city` VALUES ('159' '11' '商丘' '2'); INSERT INTO `city` VALUES ('160' '11' '新乡' '2'); INSERT INTO `city` VALUES ('161' '11' '信阳' '2'); INSERT INTO `city` VALUES ('162' '11' '许昌' '2'); INSERT INTO `city` VALUES ('163' '11' '周口' '2'); INSERT INTO `city` VALUES ('164' '11' '驻马店' '2'); INSERT INTO `city` VALUES ('165' '11' '漯河' '2'); INSERT INTO `city` VALUES ('166' '11' '濮阳' '2'); INSERT INTO `city` VALUES ('167' '12' '哈尔滨' '2'); INSERT INTO `city` VALUES ('168' '12' '大庆' '2'); INSERT INTO `city` VALUES ('169' '12' '大兴安岭' '2'); INSERT INTO `city` VALUES ('170' '12' '鹤岗' '2'); INSERT INTO `city` VALUES ('171' '12' '黑河' '2'); INSERT INTO `city` VALUES ('172' '12' '鸡西' '2'); INSERT INTO `city` VALUES ('173' '12' '佳木斯' '2'); INSERT INTO `city` VALUES ('174' '12' '牡丹江' '2'); INSERT INTO `city` VALUES ('175' '12' '七台河' '2'); INSERT INTO `city` VALUES ('176' '12' '齐齐哈尔' '2'); INSERT INTO `city` VALUES ('177' '12' '双鸭山' '2'); INSERT INTO `city` VALUES ('178' '12' '绥化' '2'); INSERT INTO `city` VALUES ('179' '12' '伊春' '2'); INSERT INTO `city` VALUES ('180' '13' '武汉' '2'); INSERT INTO `city` VALUES ('181' '13' '仙桃' '2'); INSERT INTO `city` VALUES ('182' '13' '鄂州' '2'); INSERT INTO `city` VALUES ('183' '13' '黄冈' '2'); INSERT INTO `city` VALUES ('184' '13' '黄石' '2'); INSERT INTO `city` VALUES ('185' '13' '荆门' '2'); INSERT INTO `city` VALUES ('186' '13' '荆州' '2'); INSERT INTO `city` VALUES ('187' '13' '潜江' '2'); INSERT INTO `city` VALUES ('188' '13' '神农架林区' '2'); INSERT INTO `city` VALUES ('189' '13' '十堰' '2'); INSERT INTO `city` VALUES ('190' '13' '随州' '2'); INSERT INTO `city` VALUES ('191' '13' '天门' '2'); INSERT INTO `city` VALUES ('192' '13' '咸宁' '2');INSERT INTO `city` VALUES ('194' '13' '孝感' '2'); INSERT INTO `city` VALUES ('195' '13' '宜昌' '2'); INSERT INTO `city` VALUES ('196' '13' '恩施' '2'); INSERT INTO `city` VALUES ('197' '14' '长沙' '2'); INSERT INTO `city` VALUES ('198' '14' '张家界' '2'); INSERT INTO `city` VALUES ('199' '14' '常德' '2'); INSERT INTO `city` VALUES ('200' '14' '郴州' '2'); INSERT INTO `city` VALUES ('201' '14' '衡阳' '2'); INSERT INTO `city` VALUES ('202' '14' '怀化' '2'); INSERT INTO `city` VALUES ('203' '14' '娄底' '2'); INSERT INTO `city` VALUES ('204' '14' '邵阳' '2'); INSERT INTO `city` VALUES ('205' '14' '湘潭' '2'); INSERT INTO `city` VALUES ('206' '14' '湘西' '2'); INSERT INTO `city` VALUES ('207' '14' '益阳' '2'); INSERT INTO `city` VALUES ('208' '14' '永州' '2'); INSERT INTO `city` VALUES ('209' '14' '岳阳' '2'); INSERT INTO `city` VALUES ('210' '14' '株洲' '2'); INSERT INTO `city` VALUES ('211' '15' '长春' '2'); INSERT INTO `city` VALUES ('212' '15' '吉林' '2'); INSERT INTO `city` VALUES ('213' '15' '白城' '2'); INSERT INTO `city` VALUES ('214' '15' '白山' '2'); INSERT INTO `city` VALUES ('215' '15' '辽源' '2'); INSERT INTO `city` VALUES ('216' '15' '四平' '2'); INSERT INTO `city` VALUES ('217' '15' '松原' '2'); INSERT INTO `city` VALUES ('218' '15' '通化' '2'); INSERT INTO `city` VALUES ('219' '15' '延边' '2'); INSERT INTO `city` VALUES ('220' '16' '南京' '2'); INSERT INTO `city` VALUES ('221' '16' '苏州' '2'); INSERT INTO `city` VALUES ('222' '16' '无锡' '2'); INSERT INTO `city` VALUES ('223' '16' '常州' '2'); INSERT INTO `city` VALUES ('224' '16' '淮安' '2'); INSERT INTO `city` VALUES ('225' '16' '连云港' '2'); INSERT INTO `city` VALUES ('226' '16' '南通' '2'); INSERT INTO `city` VALUES ('227' '16' '宿迁' '2'); INSERT INTO `city` VALUES ('228' '16' '泰州' '2'); INSERT INTO `city` VALUES ('229' '16' '徐州' '2'); INSERT INTO `city` VALUES ('230' '16' '盐城' '2'); INSERT INTO `city` VALUES ('231' '16' '扬州' '2'); INSERT INTO `city` VALUES ('232' '16' '镇江' '2');INSERT INTO `city` VALUES ('234' '17' '抚州' '2'); INSERT INTO `city` VALUES ('235' '17' '赣州' '2'); INSERT INTO `city` VALUES ('236' '17' '吉安' '2'); INSERT INTO `city` VALUES ('237' '17' '景德镇' '2'); INSERT INTO `city` VALUES ('238' '17' '九江' '2'); INSERT INTO `city` VALUES ('239' '17' '萍乡' '2'); INSERT INTO `city` VALUES ('240' '17' '上饶' '2'); INSERT INTO `city` VALUES ('241' '17' '新余' '2'); INSERT INTO `city` VALUES ('242' '17' '宜春' '2'); INSERT INTO `city` VALUES ('243' '17' '鹰潭' '2'); INSERT INTO `city` VALUES ('244' '18' '沈阳' '2'); INSERT INTO `city` VALUES ('245' '18' '大连' '2'); INSERT INTO `city` VALUES ('246' '18' '鞍山' '2'); INSERT INTO `city` VALUES ('247' '18' '本溪' '2'); INSERT INTO `city` VALUES ('248' '18' '朝阳' '2'); INSERT INTO `city` VALUES ('249' '18' '丹东' '2'); INSERT INTO `city` VALUES ('250' '18' '抚顺' '2'); INSERT INTO `city` VALUES ('251' '18' '阜新' '2'); INSERT INTO `city` VALUES ('252' '18' '葫芦岛' '2'); INSERT INTO `city` VALUES ('253' '18' '锦州' '2'); INSERT INTO `city` VALUES ('254' '18' '辽阳' '2'); INSERT INTO `city` VALUES ('255' '18' '盘锦' '2'); INSERT INTO `city` VALUES ('256' '18' '铁岭' '2'); INSERT INTO `city` VALUES ('257' '18' '营口' '2'); INSERT INTO `city` VALUES ('258' '19' '呼和浩特' '2'); INSERT INTO `city` VALUES ('259' '19' '阿拉善盟' '2'); INSERT INTO `city` VALUES ('260' '19' '巴彦淖尔盟' '2'); INSERT INTO `city` VALUES ('261' '19' '包头' '2'); INSERT INTO `city` VALUES ('262' '19' '赤峰' '2'); INSERT INTO `city` VALUES ('263' '19' '鄂尔多斯' '2'); INSERT INTO `city` VALUES ('264' '19' '呼伦贝尔' '2'); INSERT INTO `city` VALUES ('265' '19' '通辽' '2'); INSERT INTO `city` VALUES ('266' '19' '乌海' '2'); INSERT INTO `city` VALUES ('267' '19' '乌兰察布市' '2'); INSERT INTO `city` VALUES ('268' '19' '锡林郭勒盟' '2'); INSERT INTO `city` VALUES ('269' '19' '兴安盟' '2'); INSERT INTO `city` VALUES ('270' '20' '银川' '2'); INSERT INTO `city` VALUES ('271' '20' '固原' '2'); INSERT INTO `city` VALUES ('272' '20' '石嘴山' '2');INSERT INTO `city` VALUES ('274' '20' '中卫' '2'); INSERT INTO `city` VALUES ('275' '21' '西宁' '2'); INSERT INTO `city` VALUES ('276' '21' '果洛' '2'); INSERT INTO `city` VALUES ('277' '21' '海北' '2'); INSERT INTO `city` VALUES ('278' '21' '海东' '2'); INSERT INTO `city` VALUES ('279' '21' '海南' '2'); INSERT INTO `city` VALUES ('280' '21' '海西' '2'); INSERT INTO `city` VALUES ('281' '21' '黄南' '2'); INSERT INTO `city` VALUES ('282' '21' '玉树' '2'); INSERT INTO `city` VALUES ('283' '22' '济南' '2'); INSERT INTO `city` VALUES ('284' '22' '青岛' '2'); INSERT INTO `city` VALUES ('285' '22' '滨州' '2'); INSERT INTO `city` VALUES ('286' '22' '德州' '2'); INSERT INTO `city` VALUES ('287' '22' '东营' '2'); INSERT INTO `city` VALUES ('288' '22' '菏泽' '2'); INSERT INTO `city` VALUES ('289' '22' '济宁' '2'); INSERT INTO `city` VALUES ('290' '22' '莱芜' '2'); INSERT INTO `city` VALUES ('291' '22' '聊城' '2'); INSERT INTO `city` VALUES ('292' '22' '临沂' '2'); INSERT INTO `city` VALUES ('293' '22' '日照' '2'); INSERT INTO `city` VALUES ('294' '22' '泰安' '2'); INSERT INTO `city` VALUES ('295' '22' '威海' '2'); INSERT INTO `city` VALUES ('296' '22' '潍坊' '2'); INSERT INTO `city` VALUES ('297' '22' '烟台' '2'); INSERT INTO `city` VALUES ('298' '22' '枣庄' '2'); INSERT INTO `city` VALUES ('299' '22' '淄博' '2'); INSERT INTO `city` VALUES ('300' '23' '太原' '2'); INSERT INTO `city` VALUES ('301' '23' '长治' '2'); INSERT INTO `city` VALUES ('302' '23' '大同' '2'); INSERT INTO `city` VALUES ('303' '23' '晋城' '2'); INSERT INTO `city` VALUES ('304' '23' '晋中' '2'); INSERT INTO `city` VALUES ('305' '23' '临汾' '2'); INSERT INTO `city` VALUES ('306' '23' '吕梁' '2'); INSERT INTO `city` VALUES ('307' '23' '朔州' '2'); INSERT INTO `city` VALUES ('308' '23' '忻州' '2'); INSERT INTO `city` VALUES ('309' '23' '阳泉' '2'); INSERT INTO `city` VALUES ('310' '23' '运城' '2'); INSERT INTO `city` VALUES ('311' '24' '西安' '2'); INSERT INTO `city` VALUES ('312' '24' '安康' '2');INSERT INTO `city` VALUES ('314' '24' '汉中' '2'); INSERT INTO `city` VALUES ('315' '24' '商洛' '2'); INSERT INTO `city` VALUES ('316' '24' '铜川' '2'); INSERT INTO `city` VALUES ('317' '24' '渭南' '2'); INSERT INTO `city` VALUES ('318' '24' '咸阳' '2'); INSERT INTO `city` VALUES ('319' '24' '延安' '2'); INSERT INTO `city` VALUES ('320' '24' '榆林' '2'); INSERT INTO `city` VALUES ('321' '25' '上海' '2'); INSERT INTO `city` VALUES ('322' '26' '成都' '2'); INSERT INTO `city` VALUES ('323' '26' '绵阳' '2'); INSERT INTO `city` VALUES ('324' '26' '阿坝' '2'); INSERT INTO `city` VALUES ('325' '26' '巴中' '2'); INSERT INTO `city` VALUES ('326' '26' '达州' '2'); INSERT INTO `city` VALUES ('327' '26' '德阳' '2'); INSERT INTO `city` VALUES ('328' '26' '甘孜' '2'); INSERT INTO `city` VALUES ('329' '26' '广安' '2'); INSERT INTO `city` VALUES ('330' '26' '广元' '2'); INSERT INTO `city` VALUES ('331' '26' '乐山' '2'); INSERT INTO `city` VALUES ('332' '26' '凉山' '2'); INSERT INTO `city` VALUES ('333' '26' '眉山' '2'); INSERT INTO `city` VALUES ('334' '26' '南充' '2'); INSERT INTO `city` VALUES ('335' '26' '内江' '2'); INSERT INTO `city` VALUES ('336' '26' '攀枝花' '2'); INSERT INTO `city` VALUES ('337' '26' '遂宁' '2'); INSERT INTO `city` VALUES ('338' '26' '雅安' '2'); INSERT INTO `city` VALUES ('339' '26' '宜宾' '2'); INSERT INTO `city` VALUES ('340' '26' '资阳' '2'); INSERT INTO `city` VALUES ('341' '26' '自贡' '2'); INSERT INTO `city` VALUES ('342' '26' '泸州' '2'); INSERT INTO `city` VALUES ('343' '27' '天津' '2'); INSERT INTO `city` VALUES ('344' '28' '拉萨' '2'); INSERT INTO `city` VALUES ('345' '28' '阿里' '2'); INSERT INTO `city` VALUES ('346' '28' '昌都' '2'); INSERT INTO `city` VALUES ('347' '28' '林芝' '2'); INSERT INTO `city` VALUES ('348' '28' '那曲' '2'); INSERT INTO `city` VALUES ('349' '28' '日喀则' '2'); INSERT INTO `city` VALUES ('350' '28' '山南' '2'); INSERT INTO `city` VALUES ('351' '29' '乌鲁木齐' '2'); INSERT INTO `city` VALUES ('352' '29' '阿克苏' '2');INSERT INTO `city` VALUES ('354' '29' '巴音郭楞' '2'); INSERT INTO `city` VALUES ('355' '29' '博尔塔拉' '2'); INSERT INTO `city` VALUES ('356' '29' '昌吉' '2'); INSERT INTO `city` VALUES ('357' '29' '哈密' '2'); INSERT INTO `city` VALUES ('358' '29' '和田' '2'); INSERT INTO `city` VALUES ('359' '29' '喀什' '2'); INSERT INTO `city` VALUES ('360' '29' '克拉玛依' '2'); INSERT INTO `city` VALUES ('361' '29' '克孜勒苏' '2'); INSERT INTO `city` VALUES ('362' '29' '石河子' '2'); INSERT INTO `city` VALUES ('363' '29' '图木舒克' '2'); INSERT INTO `city` VALUES ('364' '29' '吐鲁番' '2'); INSERT INTO `city` VALUES ('365' '29' '五家渠' '2'); INSERT INTO `city` VALUES ('366' '29' '伊犁' '2'); INSERT INTO `city` VALUES ('367' '30' '昆明' '2'); INSERT INTO `city` VALUES ('368' '30' '怒江' '2'); INSERT INTO `city` VALUES ('369' '30' '普洱' '2'); INSERT INTO `city` VALUES ('370' '30' '丽江' '2'); INSERT INTO `city` VALUES ('371' '30' '保山' '2'); INSERT INTO `city` VALUES ('372' '30' '楚雄' '2'); INSERT INTO `city` VALUES ('373' '30' '大理' '2'); INSERT INTO `city` VALUES ('374' '30' '德宏' '2'); INSERT INTO `city` VALUES ('375' '30' '迪庆' '2'); INSERT INTO `city` VALUES ('376' '30' '红河' '2'); INSERT INTO `city` VALUES ('377' '30' '临沧' '2'); INSERT INTO `city` VALUES ('378' '30' '曲靖' '2'); INSERT INTO `city` VALUES ('379' '30' '文山' '2'); INSERT INTO `city` VALUES ('380' '30' '西双版纳' '2'); INSERT INTO `city` VALUES ('381' '30' '玉溪' '2'); INSERT INTO `city` VALUES ('382' '30' '昭通' '2'); INSERT INTO `city` VALUES ('383' '31' '杭州' '2'); INSERT INTO `city` VALUES ('384' '31' '湖州' '2'); INSERT INTO `city` VALUES ('385' '31' '嘉兴' '2'); INSERT INTO `city` VALUES ('386' '31' '金华' '2'); INSERT INTO `city` VALUES ('387' '31' '丽水' '2'); INSERT INTO `city` VALUES ('388' '31' '宁波' '2'); INSERT INTO `city` VALUES ('389' '31' '绍兴' '2'); INSERT INTO `city` VALUES ('390' '31' '台州' '2'); INSERT INTO `city` VALUES ('391' '31' '温州' '2'); INSERT INTO `city` VALUES ('392' '31' '舟山' '2');。

(word完整版)中国省市区(地区MySql数据表)

(word 完整版)中国省市区(地区 MySql 数据表)
1. SET FOREIGN_KEY_CHECKS=0；
2.

3. —— -—--———-—-—-—-—-----——-—-——4. —— Table structure for district
5. —— -—---—--——--————-———------—-
20insertdistrictvalues21insertdistrictvalues22insertdistrictvalues23insertdistrictvalues24insertdistrictvalues25insertdistrictvalues26insertdistrictvalues27insertdistrictvalues28insertdistrictvalues29insertdistrictvalues1030insertdistrictvalues1131insertdistrictvalues1232insertdistrictvalues1333insertdistrictvalues1434insertdistrictvalues1535insertdistrictvalues1636insertdistrictvalues1737insertdistrictvalues1838insertdistrictvalues1939insertdistrictvalues2040insertdistrictvalues2141insertdistrictvalues2242insertdistrictvalues2343insertdistrictvalues2444insertdistrictvalues2545insertdistrictvalues2646insertdistrictvalues2747insertdistrictvalues2848insertdistrictvalues2949insertdistrictvalues3050insertdistrictvalues3151insertdistrictvalues3252insertdistrictvalues3353insertdistrictvalues3454insertdistrictvalues3555insertdistrictvalues3656insertdistrictvalues3757insertdistrictvalues3858insertdistrictvalues3959insertdistrictvalues4060insertdistrictvalues4161insertdistrictvalues4262insertdistrictvalues4363insertdi

省市县级联查询sql详解

2、字段说明 1 F_IS_USE(是否启用:1-->启用；0-->禁用) 2 F_JB(所属级别:省会:1、市:2、县区:3) 3 F_MJ(是否还有末级城市) 4 F_JBBM(代表城市的唯一编码)
3、查询所有的省会城市 1 SELECT F_REGION_NUM, F_REGION_NAME, F_IS_USE, F_JBBM, F_JB, F_MJ 2 FROM TB_DA_AREA T 3 WHERE 1 = 1 4 AND T.F_IS_USE = 1 5 AND T.F_JB = 1 6 AND T.F_MJ = 0
4、业务场景:查询江苏省下的省会城市(主要利用的是江苏省的F_JBBM:32、级别变为:2) 1 SELECT F_REGION_NUM, F_REGION_NAME, F_IS_USE, F_JBBM, F_JB, F_MJ 2 FROM TB_DA_AREA T 3 WHERE 1 = 1 4 AND T.F_IS_USE = 1 5 AND T.F_JB = 2 6 AND T.F_MJ = 0 7 AND T.F_JBBM LIKE '32%'
5、查询南京市下的辖区信息(最后一级了所以末级数据为1传递南京市的级别编码) 1 SELECT F_REGION_NUM, F_REGION_NAME, F_IS_USE, F_JBBM, F_JB, F_MJ 2 FROM TB_DA_AREA T 3 WHERE 1 = 1 4 AND T.F_IS_USE = 1 5 AND T.F_JB = 3 6 AND T.F_MJ = 1 7 AND T.F_JBBM LIKE '3201%'
其他市区查询一致,只是传递的参数值不同而已,具来自在代码中的应用后期有时间在发布

中国三级省市区sql

--请复制以下语句到mysql数据库，F9一键运行就可以了！-- 导出表db_menu.hat_area 结构CREATE TABLE IF NOT EXISTS `hat_area` (`ID` int(11) NOT NULL AUTO_INCREMENT,`AREA_ID` varchar(6) DEFAULT NULL,`AREA` varchar(50) DEFAULT NULL,`FATHER` varchar(6) DEFAULT NULL,PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8;-- 正在导出表db_menu.hat_area 的数据：~2,957 rows (大约) /*!40000 ALTER TABLE `hat_area` DISABLE KEYS */;INSERT INTO `hat_area` (`ID`, `AREA_ID`, `AREA`, `FATHER`) VALUES (1, '110101', '东城区', '110100'),(2, '110102', '西城区', '110100'),(3, '110103', '崇文区', '110100'),(4, '110104', '宣武区', '110100'),(5, '110105', '朝阳区', '110100'),(6, '110106', '丰台区', '110100'),(7, '110107', '石景山区', '110100'),(8, '110108', '海淀区', '110100'),(9, '110109', '门头沟区', '110100'),(10, '110111', '房山区', '110100'),(11, '110112', '通州区', '110100'),(12, '110113', '顺义区', '110100'),(13, '110114', '昌平区', '110100'),(14, '110115', '大兴区', '110100'),(15, '110116', '怀柔区', '110100'),(16, '110117', '平谷区', '110100'),(17, '110228', '密云县', '110200'),(18, '110229', '延庆县', '110200'),(19, '120101', '和平区', '120100'),(20, '120102', '河东区', '120100'),(21, '120103', '河西区', '120100'),(22, '120104', '南开区', '120100'),(23, '120105', '河北区', '120100'),(24, '120106', '红桥区', '120100'),(25, '120107', '塘沽区', '120100'),(26, '120108', '汉沽区', '120100'),(27, '120109', '大港区', '120100'),(28, '120110', '东丽区', '120100'),(29, '120111', '西青区', '120100'),(30, '120112', '津南区', '120100'),(32, '120114', '武清区', '120100'), (33, '120115', '宝坻区', '120100'), (34, '120221', '宁河县', '120200'), (35, '120223', '静海县', '120200'), (36, '120225', '蓟县', '120200'), (38, '130102', '长安区', '130100'), (39, '130103', '桥东区', '130100'), (40, '130104', '桥西区', '130100'), (41, '130105', '新华区', '130100'), (42, '130107', '井陉矿区', '130100'), (43, '130108', '裕华区', '130100'), (44, '130121', '井陉县', '130100'), (45, '130123', '正定县', '130100'), (46, '130124', '栾城县', '130100'), (47, '130125', '行唐县', '130100'), (48, '130126', '灵寿县', '130100'), (49, '130127', '高邑县', '130100'), (50, '130128', '深泽县', '130100'), (51, '130129', '赞皇县', '130100'), (52, '130130', '无极县', '130100'), (53, '130131', '平山县', '130100'), (54, '130132', '元氏县', '130100'), (55, '130133', '赵县', '130100'), (56, '130181', '辛集市', '130100'), (57, '130182', '藁城市', '130100'), (58, '130183', '晋州市', '130100'), (59, '130184', '新乐市', '130100'), (60, '130185', '鹿泉市', '130100'), (62, '130202', '路南区', '130200'), (63, '130203', '路北区', '130200'), (64, '130204', '古冶区', '130200'), (65, '130205', '开平区', '130200'), (66, '130207', '丰南区', '130200'), (67, '130208', '丰润区', '130200'), (68, '130223', '滦县', '130200'), (69, '130224', '滦南县', '130200'), (70, '130225', '乐亭县', '130200'), (71, '130227', '迁西县', '130200'), (72, '130229', '玉田县', '130200'), (73, '130230', '唐海县', '130200'), (74, '130281', '遵化市', '130200'), (75, '130283', '迁安市', '130200'), (77, '130302', '海港区', '130300'),(79, '130304', '北戴河区', '130300'), (80, '130321', '青龙满族自治县', '130300'), (81, '130322', '昌黎县', '130300'),(82, '130323', '抚宁县', '130300'),(83, '130324', '卢龙县', '130300'),(85, '130402', '邯山区', '130400'),(86, '130403', '丛台区', '130400'),(87, '130404', '复兴区', '130400'),(88, '130406', '峰峰矿区', '130400'), (89, '130421', '邯郸县', '130400'),(90, '130423', '临漳县', '130400'),(91, '130424', '成安县', '130400'),(92, '130425', '大名县', '130400'),(93, '130426', '涉县', '130400'),(94, '130427', '磁县', '130400'),(95, '130428', '肥乡县', '130400'),(96, '130429', '永年县', '130400'),(97, '130430', '邱县', '130400'),(98, '130431', '鸡泽县', '130400'),(99, '130432', '广平县', '130400'), (100, '130433', '馆陶县', '130400'), (101, '130434', '魏县', '130400'), (102, '130435', '曲周县', '130400'), (103, '130481', '武安市', '130400'), (105, '130502', '桥东区', '130500'), (106, '130503', '桥西区', '130500'), (107, '130521', '邢台县', '130500'), (108, '130522', '临城县', '130500'), (109, '130523', '内丘县', '130500'), (110, '130524', '柏乡县', '130500'), (111, '130525', '隆尧县', '130500'), (112, '130526', '任县', '130500'), (113, '130527', '南和县', '130500'), (114, '130528', '宁晋县', '130500'), (115, '130529', '巨鹿县', '130500'), (116, '130530', '新河县', '130500'), (117, '130531', '广宗县', '130500'), (118, '130532', '平乡县', '130500'), (119, '130533', '威县', '130500'), (120, '130534', '清河县', '130500'), (121, '130535', '临西县', '130500'), (122, '130581', '南宫市', '130500'), (123, '130582', '沙河市', '130500'),(126, '130603', '北市区', '130600'), (127, '130604', '南市区', '130600'), (128, '130621', '满城县', '130600'), (129, '130622', '清苑县', '130600'), (130, '130623', '涞水县', '130600'), (131, '130624', '阜平县', '130600'), (132, '130625', '徐水县', '130600'), (133, '130626', '定兴县', '130600'), (134, '130627', '唐县', '130600'), (135, '130628', '高阳县', '130600'), (136, '130629', '容城县', '130600'), (137, '130630', '涞源县', '130600'), (138, '130631', '望都县', '130600'), (139, '130632', '安新县', '130600'), (140, '130633', '易县', '130600'), (141, '130634', '曲阳县', '130600'), (142, '130635', '蠡县', '130600'), (143, '130636', '顺平县', '130600'), (144, '130637', '博野县', '130600'), (145, '130638', '雄县', '130600'), (146, '130681', '涿州市', '130600'), (147, '130682', '定州市', '130600'), (148, '130683', '安国市', '130600'), (149, '130684', '高碑店市', '130600'), (151, '130702', '桥东区', '130700'), (152, '130703', '桥西区', '130700'), (153, '130705', '宣化区', '130700'), (154, '130706', '下花园区', '130700'), (155, '130721', '宣化县', '130700'), (156, '130722', '张北县', '130700'), (157, '130723', '康保县', '130700'), (158, '130724', '沽源县', '130700'), (159, '130725', '尚义县', '130700'), (160, '130726', '蔚县', '130700'), (161, '130727', '阳原县', '130700'), (162, '130728', '怀安县', '130700'), (163, '130729', '万全县', '130700'), (164, '130730', '怀来县', '130700'), (165, '130731', '涿鹿县', '130700'), (166, '130732', '赤城县', '130700'), (167, '130733', '崇礼县', '130700'), (169, '130802', '双桥区', '130800'), (170, '130803', '双滦区', '130800'),(171, '130804', '鹰手营子矿区', '130800'), (172, '130821', '承德县', '130800'),(173, '130822', '兴隆县', '130800'),(174, '130823', '平泉县', '130800'),(175, '130824', '滦平县', '130800'),(176, '130825', '隆化县', '130800'),(177, '130826', '丰宁满族自治县', '130800'), (178, '130827', '宽城满族自治县', '130800'), (179, '130828', '围场满族蒙古族自治县', '130800'), (181, '130902', '新华区', '130900'),(182, '130903', '运河区', '130900'),(183, '130921', '沧县', '130900'),(184, '130922', '青县', '130900'),(185, '130923', '东光县', '130900'),(186, '130924', '海兴县', '130900'),(187, '130925', '盐山县', '130900'),(188, '130926', '肃宁县', '130900'),(189, '130927', '南皮县', '130900'),(190, '130928', '吴桥县', '130900'),(191, '130929', '献县', '130900'),(192, '130930', '孟村回族自治县', '130900'), (193, '130981', '泊头市', '130900'),(194, '130982', '任丘市', '130900'),(195, '130983', '黄骅市', '130900'),(196, '130984', '河间市', '130900'),(198, '131002', '安次区', '131000'),(199, '131003', '广阳区', '131000'),(200, '131022', '固安县', '131000'),(201, '131023', '永清县', '131000'),(202, '131024', '香河县', '131000'),(203, '131025', '大城县', '131000'),(204, '131026', '文安县', '131000'),(205, '131028', '大厂回族自治县', '131000'), (206, '131081', '霸州市', '131000'),(207, '131082', '三河市', '131000'),(209, '131102', '桃城区', '131100'),(210, '131121', '枣强县', '131100'),(211, '131122', '武邑县', '131100'),(212, '131123', '武强县', '131100'),(213, '131124', '饶阳县', '131100'),(214, '131125', '安平县', '131100'),(215, '131126', '故城县', '131100'),(216, '131127', '景县', '131100'),(217, '131128', '阜城县', '131100'),(219, '131182', '深州市', '131100'), (221, '140105', '小店区', '140100'), (222, '140106', '迎泽区', '140100'), (223, '140107', '杏花岭区', '140100'), (224, '140108', '尖草坪区', '140100'), (225, '140109', '万柏林区', '140100'), (226, '140110', '晋源区', '140100'), (227, '140121', '清徐县', '140100'), (228, '140122', '阳曲县', '140100'), (229, '140123', '娄烦县', '140100'), (230, '140181', '古交市', '140100'), (232, '140202', '城区', '140200'), (233, '140203', '矿区', '140200'), (234, '140211', '南郊区', '140200'), (235, '140212', '新荣区', '140200'), (236, '140221', '阳高县', '140200'), (237, '140222', '天镇县', '140200'), (238, '140223', '广灵县', '140200'), (239, '140224', '灵丘县', '140200'), (240, '140225', '浑源县', '140200'), (241, '140226', '左云县', '140200'), (242, '140227', '大同县', '140200'), (244, '140302', '城区', '140300'), (245, '140303', '矿区', '140300'), (246, '140311', '郊区', '140300'), (247, '140321', '平定县', '140300'), (248, '140322', '盂县', '140300'), (250, '140402', '城区', '140400'), (251, '140411', '郊区', '140400'), (252, '140421', '长治县', '140400'), (253, '140423', '襄垣县', '140400'), (254, '140424', '屯留县', '140400'), (255, '140425', '平顺县', '140400'), (256, '140426', '黎城县', '140400'), (257, '140427', '壶关县', '140400'), (258, '140428', '长子县', '140400'), (259, '140429', '武乡县', '140400'), (260, '140430', '沁县', '140400'), (261, '140431', '沁源县', '140400'), (262, '140481', '潞城市', '140400'), (264, '140502', '城区', '140500'), (265, '140521', '沁水县', '140500'), (266, '140522', '阳城县', '140500'),(268, '140525', '泽州县', '140500'), (269, '140581', '高平市', '140500'), (271, '140602', '朔城区', '140600'), (272, '140603', '平鲁区', '140600'), (273, '140621', '山阴县', '140600'), (274, '140622', '应县', '140600'), (275, '140623', '右玉县', '140600'), (276, '140624', '怀仁县', '140600'), (278, '140702', '榆次区', '140700'), (279, '140721', '榆社县', '140700'), (280, '140722', '左权县', '140700'), (281, '140723', '和顺县', '140700'), (282, '140724', '昔阳县', '140700'), (283, '140725', '寿阳县', '140700'), (284, '140726', '太谷县', '140700'), (285, '140727', '祁县', '140700'), (286, '140728', '平遥县', '140700'), (287, '140729', '灵石县', '140700'), (288, '140781', '介休市', '140700'), (290, '140802', '盐湖区', '140800'), (291, '140821', '临猗县', '140800'), (292, '140822', '万荣县', '140800'), (293, '140823', '闻喜县', '140800'), (294, '140824', '稷山县', '140800'), (295, '140825', '新绛县', '140800'), (296, '140826', '绛县', '140800'), (297, '140827', '垣曲县', '140800'), (298, '140828', '夏县', '140800'), (299, '140829', '平陆县', '140800'), (300, '140830', '芮城县', '140800'), (301, '140881', '永济市', '140800'), (302, '140882', '河津市', '140800'), (304, '140902', '忻府区', '140900'), (305, '140921', '定襄县', '140900'), (306, '140922', '五台县', '140900'), (307, '140923', '代县', '140900'), (308, '140924', '繁峙县', '140900'), (309, '140925', '宁武县', '140900'), (310, '140926', '静乐县', '140900'), (311, '140927', '神池县', '140900'), (312, '140928', '五寨县', '140900'), (313, '140929', '岢岚县', '140900'), (314, '140930', '河曲县', '140900'),(316, '140932', '偏关县', '140900'), (317, '140981', '原平市', '140900'), (319, '141002', '尧都区', '141000'), (320, '141021', '曲沃县', '141000'), (321, '141022', '翼城县', '141000'), (322, '141023', '襄汾县', '141000'), (323, '141024', '洪洞县', '141000'), (324, '141025', '古县', '141000'), (325, '141026', '安泽县', '141000'), (326, '141027', '浮山县', '141000'), (327, '141028', '吉县', '141000'), (328, '141029', '乡宁县', '141000'), (329, '141030', '大宁县', '141000'), (330, '141031', '隰县', '141000'), (331, '141032', '永和县', '141000'), (332, '141033', '蒲县', '141000'), (333, '141034', '汾西县', '141000'), (334, '141081', '侯马市', '141000'), (335, '141082', '霍州市', '141000'), (337, '141102', '离石区', '141100'), (338, '141121', '文水县', '141100'), (339, '141122', '交城县', '141100'), (340, '141123', '兴县', '141100'), (341, '141124', '临县', '141100'), (342, '141125', '柳林县', '141100'), (343, '141126', '石楼县', '141100'), (344, '141127', '岚县', '141100'), (345, '141128', '方山县', '141100'), (346, '141129', '中阳县', '141100'), (347, '141130', '交口县', '141100'), (348, '141181', '孝义市', '141100'), (349, '141182', '汾阳市', '141100'), (351, '150102', '新城区', '150100'), (352, '150103', '回民区', '150100'), (353, '150104', '玉泉区', '150100'), (354, '150105', '赛罕区', '150100'), (355, '150121', '土默特左旗', '150100'), (356, '150122', '托克托县', '150100'), (357, '150123', '和林格尔县', '150100'), (358, '150124', '清水河县', '150100'), (359, '150125', '武川县', '150100'), (361, '150202', '东河区', '150200'), (362, '150203', '昆都仑区', '150200'),(364, '150205', '石拐区', '150200'),(365, '150206', '白云矿区', '150200'),(366, '150207', '九原区', '150200'),(367, '150221', '土默特右旗', '150200'),(368, '150222', '固阳县', '150200'),(369, '150223', '达尔罕茂明安联合旗', '150200'), (371, '150302', '海勃湾区', '150300'),(372, '150303', '海南区', '150300'),(373, '150304', '乌达区', '150300'),(375, '150402', '红山区', '150400'),(376, '150403', '元宝山区', '150400'),(377, '150404', '松山区', '150400'),(378, '150421', '阿鲁科尔沁旗', '150400'),(379, '150422', '巴林左旗', '150400'),(380, '150423', '巴林右旗', '150400'),(381, '150424', '林西县', '150400'),(382, '150425', '克什克腾旗', '150400'),(383, '150426', '翁牛特旗', '150400'),(384, '150428', '喀喇沁旗', '150400'),(385, '150429', '宁城县', '150400'),(386, '150430', '敖汉旗', '150400'),(388, '150502', '科尔沁区', '150500'),(389, '150521', '科尔沁左翼中旗', '150500'), (390, '150522', '科尔沁左翼后旗', '150500'), (391, '150523', '开鲁县', '150500'),(392, '150524', '库伦旗', '150500'),(393, '150525', '奈曼旗', '150500'),(394, '150526', '扎鲁特旗', '150500'),(395, '150581', '霍林郭勒市', '150500'),(396, '150602', '东胜区', '150600'),(397, '150621', '达拉特旗', '150600'),(398, '150622', '准格尔旗', '150600'),(399, '150623', '鄂托克前旗', '150600'),(400, '150624', '鄂托克旗', '150600'),(401, '150625', '杭锦旗', '150600'),(402, '150626', '乌审旗', '150600'),(403, '150627', '伊金霍洛旗', '150600'),(405, '150702', '海拉尔区', '150700'),(406, '150721', '阿荣旗', '150700'),(407, '150722', '莫力达瓦达斡尔族自治旗', '150700'), (408, '150723', '鄂伦春自治旗', '150700'),(409, '150724', '鄂温克族自治旗', '150700'), (410, '150725', '陈巴尔虎旗', '150700'),(411, '150726', '新巴尔虎左旗', '150700'), (412, '150727', '新巴尔虎右旗', '150700'), (413, '150781', '满洲里市', '150700'), (414, '150782', '牙克石市', '150700'), (415, '150783', '扎兰屯市', '150700'), (416, '150784', '额尔古纳市', '150700'), (417, '150785', '根河市', '150700'), (419, '150802', '临河区', '150800'), (420, '150821', '五原县', '150800'), (421, '150822', '磴口县', '150800'), (422, '150823', '乌拉特前旗', '150800'), (423, '150824', '乌拉特中旗', '150800'), (424, '150825', '乌拉特后旗', '150800'), (425, '150826', '杭锦后旗', '150800'), (427, '150902', '集宁区', '150900'), (428, '150921', '卓资县', '150900'), (429, '150922', '化德县', '150900'), (430, '150923', '商都县', '150900'), (431, '150924', '兴和县', '150900'), (432, '150925', '凉城县', '150900'), (433, '150926', '察哈尔右翼前旗', '150900'), (434, '150927', '察哈尔右翼中旗', '150900'), (435, '150928', '察哈尔右翼后旗', '150900'), (436, '150929', '四子王旗', '150900'), (437, '150981', '丰镇市', '150900'), (438, '152201', '乌兰浩特市', '152200'), (439, '152202', '阿尔山市', '152200'), (440, '152221', '科尔沁右翼前旗', '152200'), (441, '152222', '科尔沁右翼中旗', '152200'), (442, '152223', '扎赉特旗', '152200'), (443, '152224', '突泉县', '152200'), (444, '152501', '二连浩特市', '152500'), (445, '152502', '锡林浩特市', '152500'), (446, '152522', '阿巴嘎旗', '152500'), (447, '152523', '苏尼特左旗', '152500'), (448, '152524', '苏尼特右旗', '152500'), (449, '152525', '东乌珠穆沁旗', '152500'), (450, '152526', '西乌珠穆沁旗', '152500'), (451, '152527', '太仆寺旗', '152500'), (452, '152528', '镶黄旗', '152500'), (453, '152529', '正镶白旗', '152500'), (454, '152530', '正蓝旗', '152500'), (455, '152531', '多伦县', '152500'), (456, '152921', '阿拉善左旗', '152900'),(457, '152922', '阿拉善右旗', '152900'), (458, '152923', '额济纳旗', '152900'), (460, '210102', '和平区', '210100'), (461, '210103', '沈河区', '210100'), (462, '210104', '大东区', '210100'), (463, '210105', '皇姑区', '210100'), (464, '210106', '铁西区', '210100'), (465, '210111', '苏家屯区', '210100'), (466, '210112', '东陵区', '210100'), (467, '210113', '新城子区', '210100'), (468, '210114', '于洪区', '210100'), (469, '210122', '辽中县', '210100'), (470, '210123', '康平县', '210100'), (471, '210124', '法库县', '210100'), (472, '210181', '新民市', '210100'), (474, '210202', '中山区', '210200'), (475, '210203', '西岗区', '210200'), (476, '210204', '沙河口区', '210200'), (477, '210211', '甘井子区', '210200'), (478, '210212', '旅顺口区', '210200'), (479, '210213', '金州区', '210200'), (480, '210224', '长海县', '210200'), (481, '210281', '瓦房店市', '210200'), (482, '210282', '普兰店市', '210200'), (483, '210283', '庄河市', '210200'), (485, '210302', '铁东区', '210300'), (486, '210303', '铁西区', '210300'), (487, '210304', '立山区', '210300'), (488, '210311', '千山区', '210300'), (489, '210321', '台安县', '210300'), (490, '210323', '岫岩满族自治县', '210300'), (491, '210381', '海城市', '210300'), (493, '210402', '新抚区', '210400'), (494, '210403', '东洲区', '210400'), (495, '210404', '望花区', '210400'), (496, '210411', '顺城区', '210400'), (497, '210421', '抚顺县', '210400'), (498, '210422', '新宾满族自治县', '210400'), (499, '210423', '清原满族自治县', '210400'), (501, '210502', '平山区', '210500'), (502, '210503', '溪湖区', '210500'), (503, '210504', '明山区', '210500'), (504, '210505', '南芬区', '210500'), (505, '210521', '本溪满族自治县', '210500'),(506, '210522', '桓仁满族自治县', '210500'), (508, '210602', '元宝区', '210600'),(509, '210603', '振兴区', '210600'),(510, '210604', '振安区', '210600'),(511, '210624', '宽甸满族自治县', '210600'), (512, '210681', '东港市', '210600'),(513, '210682', '凤城市', '210600'),(515, '210702', '古塔区', '210700'),(516, '210703', '凌河区', '210700'),(517, '210711', '太和区', '210700'),(518, '210726', '黑山县', '210700'),(519, '210727', '义县', '210700'),(520, '210781', '凌海市', '210700'),(521, '210782', '北宁市', '210700'),(523, '210802', '站前区', '210800'),(524, '210803', '西市区', '210800'),(525, '210804', '鲅鱼圈区', '210800'), (526, '210811', '老边区', '210800'),(527, '210881', '盖州市', '210800'),(528, '210882', '大石桥市', '210800'), (530, '210902', '海州区', '210900'),(531, '210903', '新邱区', '210900'),(532, '210904', '太平区', '210900'),(533, '210905', '清河门区', '210900'), (534, '210911', '细河区', '210900'),(535, '210921', '阜新蒙古族自治县', '210900'), (536, '210922', '彰武县', '210900'),(538, '211002', '白塔区', '211000'),(539, '211003', '文圣区', '211000'),(540, '211004', '宏伟区', '211000'),(541, '211005', '弓长岭区', '211000'), (542, '211011', '太子河区', '211000'), (543, '211021', '辽阳县', '211000'),(544, '211081', '灯塔市', '211000'),(546, '211102', '双台子区', '211100'), (547, '211103', '兴隆台区', '211100'), (548, '211121', '大洼县', '211100'),(549, '211122', '盘山县', '211100'),(551, '211202', '银州区', '211200'),(552, '211204', '清河区', '211200'),(553, '211221', '铁岭县', '211200'),(554, '211223', '西丰县', '211200'),(555, '211224', '昌图县', '211200'),(556, '211281', '调兵山市', '211200'),。

全国省市县SQL数据库(大全)

全国省市县SQL数据库（大全）创建表reate table city(id int(11) primary key not null default 0pid int(11) default nullcityname varchar(255) default nulltype int(11) default null);插入数据INSERT INTO `city` VALUES ('1' '0' '中国' '0'); INSERT INTO `city` VALUES ('2' '1' '北京' '1'); INSERT INTO `city` VALUES ('3' '1' '安徽' '1'); INSERT INTO `city` VALUES ('4' '1' '福建' '1'); INSERT INTO `city` VALUES ('5' '1' '甘肃' '1'); INSERT INTO `city` VALUES ('6' '1' '广东' '1'); INSERT INTO `city` VALUES ('7' '1' '广西' '1'); INSERT INTO `city` VALUES ('8' '1' '贵州' '1'); INSERT INTO `city` VALUES ('9' '1' '海南' '1'); INSERT INTO `city` VALUES ('10' '1' '河北' '1'); INSERT INTO `city` VALUES ('11' '1' '河南' '1'); INSERT INTO `city` VALUES ('12' '1' '黑龙江' '1'); INSERT INTO `city` VALUES ('13' '1' '湖北' '1'); INSERT INTO `city` VALUES ('14' '1' '湖南' '1'); INSERT INTO `city` VALUES ('15' '1' '吉林' '1'); INSERT INTO `city` VALUES ('16' '1' '江苏' '1'); INSERT INTO `city` VALUES ('17' '1' '江西' '1'); INSERT INTO `city` VALUES ('18' '1' '辽宁' '1'); INSERT INTO `city` VALUES ('19' '1' '内蒙古' '1'); INSERT INTO `city` VALUES ('20' '1' '宁夏' '1'); INSERT INTO `city` VALUES ('21' '1' '青海' '1'); INSERT INTO `city` VALUES ('22' '1' '山东' '1'); INSERT INTO `city` VALUES ('23' '1' '山西' '1'); INSERT INTO `city` VALUES ('24' '1' '陕西' '1'); INSERT INTO `city` VALUES ('25' '1' '上海' '1'); INSERT INTO `city` VALUES ('26' '1' '四川' '1'); INSERT INTO `city` VALUES ('27' '1' '天津' '1'); INSERT INTO `city` VALUES ('28' '1' '西藏' '1'); INSERT INTO `city` VALUES ('29' '1' '新疆' '1'); INSERT INTO `city` VALUES ('30' '1' '云南' '1'); INSERT INTO `city` VALUES ('31' '1' '浙江' '1'); INSERT INTO `city` VALUES ('32' '1' '重庆' '1');INSERT INTO `city` VALUES ('34' '1' '澳门' '1'); INSERT INTO `city` VALUES ('35' '1' '台湾' '1'); INSERT INTO `city` VALUES ('36' '3' '安庆' '2'); INSERT INTO `city` VALUES ('37' '3' '蚌埠' '2'); INSERT INTO `city` VALUES ('38' '3' '巢湖' '2'); INSERT INTO `city` VALUES ('39' '3' '池州' '2'); INSERT INTO `city` VALUES ('40' '3' '滁州' '2'); INSERT INTO `city` VALUES ('41' '3' '阜阳' '2'); INSERT INTO `city` VALUES ('42' '3' '淮北' '2'); INSERT INTO `city` VALUES ('43' '3' '淮南' '2'); INSERT INTO `city` VALUES ('44' '3' '黄山' '2'); INSERT INTO `city` VALUES ('45' '3' '六安' '2'); INSERT INTO `city` VALUES ('46' '3' '马鞍山' '2'); INSERT INTO `city` VALUES ('47' '3' '宿州' '2'); INSERT INTO `city` VALUES ('48' '3' '铜陵' '2'); INSERT INTO `city` VALUES ('49' '3' '芜湖' '2'); INSERT INTO `city` VALUES ('50' '3' '宣城' '2'); INSERT INTO `city` VALUES ('51' '3' '亳州' '2'); INSERT INTO `city` VALUES ('52' '2' '市辖区' '2'); INSERT INTO `city` VALUES ('53' '4' '福州' '2'); INSERT INTO `city` VALUES ('54' '4' '龙岩' '2'); INSERT INTO `city` VALUES ('55' '4' '南平' '2'); INSERT INTO `city` VALUES ('56' '4' '宁德' '2'); INSERT INTO `city` VALUES ('57' '4' '莆田' '2'); INSERT INTO `city` VALUES ('58' '4' '泉州' '2'); INSERT INTO `city` VALUES ('59' '4' '三明' '2'); INSERT INTO `city` VALUES ('60' '4' '厦门' '2'); INSERT INTO `city` VALUES ('61' '4' '漳州' '2'); INSERT INTO `city` VALUES ('62' '5' '兰州' '2'); INSERT INTO `city` VALUES ('63' '5' '白银' '2'); INSERT INTO `city` VALUES ('64' '5' '定西' '2'); INSERT INTO `city` VALUES ('65' '5' '甘南' '2'); INSERT INTO `city` VALUES ('66' '5' '嘉峪关' '2'); INSERT INTO `city` VALUES ('67' '5' '金昌' '2'); INSERT INTO `city` VALUES ('68' '5' '酒泉' '2'); INSERT INTO `city` VALUES ('69' '5' '临夏' '2'); INSERT INTO `city` VALUES ('70' '5' '陇南' '2'); INSERT INTO `city` VALUES ('71' '5' '平凉' '2'); INSERT INTO `city` VALUES ('72' '5' '庆阳' '2');INSERT INTO `city` VALUES ('74' '5' '武威' '2'); INSERT INTO `city` VALUES ('75' '5' '张掖' '2'); INSERT INTO `city` VALUES ('76' '6' '广州' '2'); INSERT INTO `city` VALUES ('77' '6' '深圳' '2'); INSERT INTO `city` VALUES ('78' '6' '潮州' '2'); INSERT INTO `city` VALUES ('79' '6' '东莞' '2'); INSERT INTO `city` VALUES ('80' '6' '佛山' '2'); INSERT INTO `city` VALUES ('81' '6' '河源' '2'); INSERT INTO `city` VALUES ('82' '6' '惠州' '2'); INSERT INTO `city` VALUES ('83' '6' '江门' '2'); INSERT INTO `city` VALUES ('84' '6' '揭阳' '2'); INSERT INTO `city` VALUES ('85' '6' '茂名' '2'); INSERT INTO `city` VALUES ('86' '6' '梅州' '2'); INSERT INTO `city` VALUES ('87' '6' '清远' '2'); INSERT INTO `city` VALUES ('88' '6' '汕头' '2'); INSERT INTO `city` VALUES ('89' '6' '汕尾' '2'); INSERT INTO `city` VALUES ('90' '6' '韶关' '2'); INSERT INTO `city` VALUES ('91' '6' '阳江' '2'); INSERT INTO `city` VALUES ('92' '6' '云浮' '2'); INSERT INTO `city` VALUES ('93' '6' '湛江' '2'); INSERT INTO `city` VALUES ('94' '6' '肇庆' '2'); INSERT INTO `city` VALUES ('95' '6' '中山' '2'); INSERT INTO `city` VALUES ('96' '6' '珠海' '2'); INSERT INTO `city` VALUES ('97' '7' '南宁' '2'); INSERT INTO `city` VALUES ('98' '7' '桂林' '2'); INSERT INTO `city` VALUES ('99' '7' '百色' '2'); INSERT INTO `city` VALUES ('100' '7' '北海' '2'); INSERT INTO `city` VALUES ('101' '7' '崇左' '2'); INSERT INTO `city` VALUES ('102' '7' '防城港' '2'); INSERT INTO `city` VALUES ('103' '7' '贵港' '2'); INSERT INTO `city` VALUES ('104' '7' '河池' '2'); INSERT INTO `city` VALUES ('105' '7' '贺州' '2'); INSERT INTO `city` VALUES ('106' '7' '来宾' '2'); INSERT INTO `city` VALUES ('107' '7' '柳州' '2'); INSERT INTO `city` VALUES ('108' '7' '钦州' '2'); INSERT INTO `city` VALUES ('109' '7' '梧州' '2'); INSERT INTO `city` VALUES ('110' '7' '玉林' '2'); INSERT INTO `city` VALUES ('111' '8' '贵阳' '2'); INSERT INTO `city` VALUES ('112' '8' '安顺' '2');INSERT INTO `city` VALUES ('114' '8' '六盘水' '2'); INSERT INTO `city` VALUES ('115' '8' '黔东南' '2'); INSERT INTO `city` VALUES ('116' '8' '黔南' '2'); INSERT INTO `city` VALUES ('117' '8' '黔西南' '2'); INSERT INTO `city` VALUES ('118' '8' '铜仁' '2'); INSERT INTO `city` VALUES ('119' '8' '遵义' '2'); INSERT INTO `city` VALUES ('120' '9' '海口' '2'); INSERT INTO `city` VALUES ('121' '9' '三亚' '2'); INSERT INTO `city` VALUES ('122' '9' '白沙' '2'); INSERT INTO `city` VALUES ('123' '9' '保亭' '2'); INSERT INTO `city` VALUES ('124' '9' '昌江' '2'); INSERT INTO `city` VALUES ('125' '9' '澄迈县' '2'); INSERT INTO `city` VALUES ('126' '9' '定安县' '2'); INSERT INTO `city` VALUES ('127' '9' '东方' '2'); INSERT INTO `city` VALUES ('128' '9' '乐东' '2'); INSERT INTO `city` VALUES ('129' '9' '临高县' '2'); INSERT INTO `city` VALUES ('130' '9' '陵水' '2'); INSERT INTO `city` VALUES ('131' '9' '琼海' '2'); INSERT INTO `city` VALUES ('132' '9' '琼中' '2'); INSERT INTO `city` VALUES ('133' '9' '屯昌县' '2'); INSERT INTO `city` VALUES ('134' '9' '万宁' '2'); INSERT INTO `city` VALUES ('135' '9' '文昌' '2'); INSERT INTO `city` VALUES ('136' '9' '五指山' '2'); INSERT INTO `city` VALUES ('137' '9' '儋州' '2'); INSERT INTO `city` VALUES ('138' '10' '石家庄' '2'); INSERT INTO `city` VALUES ('139' '10' '保定' '2'); INSERT INTO `city` VALUES ('140' '10' '沧州' '2'); INSERT INTO `city` VALUES ('141' '10' '承德' '2'); INSERT INTO `city` VALUES ('142' '10' '邯郸' '2'); INSERT INTO `city` VALUES ('143' '10' '衡水' '2'); INSERT INTO `city` VALUES ('144' '10' '廊坊' '2'); INSERT INTO `city` VALUES ('145' '10' '秦皇岛' '2'); INSERT INTO `city` VALUES ('146' '10' '唐山' '2'); INSERT INTO `city` VALUES ('147' '10' '邢台' '2'); INSERT INTO `city` VALUES ('148' '10' '张家口' '2'); INSERT INTO `city` VALUES ('149' '11' '郑州' '2'); INSERT INTO `city` VALUES ('150' '11' '洛阳' '2'); INSERT INTO `city` VALUES ('151' '11' '开封' '2'); INSERT INTO `city` VALUES ('152' '11' '安阳' '2');INSERT INTO `city` VALUES ('154' '11' '济源' '2'); INSERT INTO `city` VALUES ('155' '11' '焦作' '2'); INSERT INTO `city` VALUES ('156' '11' '南阳' '2'); INSERT INTO `city` VALUES ('157' '11' '平顶山' '2'); INSERT INTO `city` VALUES ('158' '11' '三门峡' '2'); INSERT INTO `city` VALUES ('159' '11' '商丘' '2'); INSERT INTO `city` VALUES ('160' '11' '新乡' '2'); INSERT INTO `city` VALUES ('161' '11' '信阳' '2'); INSERT INTO `city` VALUES ('162' '11' '许昌' '2'); INSERT INTO `city` VALUES ('163' '11' '周口' '2'); INSERT INTO `city` VALUES ('164' '11' '驻马店' '2'); INSERT INTO `city` VALUES ('165' '11' '漯河' '2'); INSERT INTO `city` VALUES ('166' '11' '濮阳' '2'); INSERT INTO `city` VALUES ('167' '12' '哈尔滨' '2'); INSERT INTO `city` VALUES ('168' '12' '大庆' '2'); INSERT INTO `city` VALUES ('169' '12' '大兴安岭' '2'); INSERT INTO `city` VALUES ('170' '12' '鹤岗' '2'); INSERT INTO `city` VALUES ('171' '12' '黑河' '2'); INSERT INTO `city` VALUES ('172' '12' '鸡西' '2'); INSERT INTO `city` VALUES ('173' '12' '佳木斯' '2'); INSERT INTO `city` VALUES ('174' '12' '牡丹江' '2'); INSERT INTO `city` VALUES ('175' '12' '七台河' '2'); INSERT INTO `city` VALUES ('176' '12' '齐齐哈尔' '2'); INSERT INTO `city` VALUES ('177' '12' '双鸭山' '2'); INSERT INTO `city` VALUES ('178' '12' '绥化' '2'); INSERT INTO `city` VALUES ('179' '12' '伊春' '2'); INSERT INTO `city` VALUES ('180' '13' '武汉' '2'); INSERT INTO `city` VALUES ('181' '13' '仙桃' '2'); INSERT INTO `city` VALUES ('182' '13' '鄂州' '2'); INSERT INTO `city` VALUES ('183' '13' '黄冈' '2'); INSERT INTO `city` VALUES ('184' '13' '黄石' '2'); INSERT INTO `city` VALUES ('185' '13' '荆门' '2'); INSERT INTO `city` VALUES ('186' '13' '荆州' '2'); INSERT INTO `city` VALUES ('187' '13' '潜江' '2'); INSERT INTO `city` VALUES ('188' '13' '神农架林区' '2'); INSERT INTO `city` VALUES ('189' '13' '十堰' '2'); INSERT INTO `city` VALUES ('190' '13' '随州' '2'); INSERT INTO `city` VALUES ('191' '13' '天门' '2'); INSERT INTO `city` VALUES ('192' '13' '咸宁' '2');INSERT INTO `city` VALUES ('194' '13' '孝感' '2'); INSERT INTO `city` VALUES ('195' '13' '宜昌' '2'); INSERT INTO `city` VALUES ('196' '13' '恩施' '2'); INSERT INTO `city` VALUES ('197' '14' '长沙' '2'); INSERT INTO `city` VALUES ('198' '14' '张家界' '2'); INSERT INTO `city` VALUES ('199' '14' '常德' '2'); INSERT INTO `city` VALUES ('200' '14' '郴州' '2'); INSERT INTO `city` VALUES ('201' '14' '衡阳' '2'); INSERT INTO `city` VALUES ('202' '14' '怀化' '2'); INSERT INTO `city` VALUES ('203' '14' '娄底' '2'); INSERT INTO `city` VALUES ('204' '14' '邵阳' '2'); INSERT INTO `city` VALUES ('205' '14' '湘潭' '2'); INSERT INTO `city` VALUES ('206' '14' '湘西' '2'); INSERT INTO `city` VALUES ('207' '14' '益阳' '2'); INSERT INTO `city` VALUES ('208' '14' '永州' '2'); INSERT INTO `city` VALUES ('209' '14' '岳阳' '2'); INSERT INTO `city` VALUES ('210' '14' '株洲' '2'); INSERT INTO `city` VALUES ('211' '15' '长春' '2'); INSERT INTO `city` VALUES ('212' '15' '吉林' '2'); INSERT INTO `city` VALUES ('213' '15' '白城' '2'); INSERT INTO `city` VALUES ('214' '15' '白山' '2'); INSERT INTO `city` VALUES ('215' '15' '辽源' '2'); INSERT INTO `city` VALUES ('216' '15' '四平' '2'); INSERT INTO `city` VALUES ('217' '15' '松原' '2'); INSERT INTO `city` VALUES ('218' '15' '通化' '2'); INSERT INTO `city` VALUES ('219' '15' '延边' '2'); INSERT INTO `city` VALUES ('220' '16' '南京' '2'); INSERT INTO `city` VALUES ('221' '16' '苏州' '2'); INSERT INTO `city` VALUES ('222' '16' '无锡' '2'); INSERT INTO `city` VALUES ('223' '16' '常州' '2'); INSERT INTO `city` VALUES ('224' '16' '淮安' '2'); INSERT INTO `city` VALUES ('225' '16' '连云港' '2'); INSERT INTO `city` VALUES ('226' '16' '南通' '2'); INSERT INTO `city` VALUES ('227' '16' '宿迁' '2'); INSERT INTO `city` VALUES ('228' '16' '泰州' '2'); INSERT INTO `city` VALUES ('229' '16' '徐州' '2'); INSERT INTO `city` VALUES ('230' '16' '盐城' '2'); INSERT INTO `city` VALUES ('231' '16' '扬州' '2'); INSERT INTO `city` VALUES ('232' '16' '镇江' '2');INSERT INTO `city` VALUES ('234' '17' '抚州' '2'); INSERT INTO `city` VALUES ('235' '17' '赣州' '2'); INSERT INTO `city` VALUES ('236' '17' '吉安' '2'); INSERT INTO `city` VALUES ('237' '17' '景德镇' '2'); INSERT INTO `city` VALUES ('238' '17' '九江' '2'); INSERT INTO `city` VALUES ('239' '17' '萍乡' '2'); INSERT INTO `city` VALUES ('240' '17' '上饶' '2'); INSERT INTO `city` VALUES ('241' '17' '新余' '2'); INSERT INTO `city` VALUES ('242' '17' '宜春' '2'); INSERT INTO `city` VALUES ('243' '17' '鹰潭' '2'); INSERT INTO `city` VALUES ('244' '18' '沈阳' '2'); INSERT INTO `city` VALUES ('245' '18' '大连' '2'); INSERT INTO `city` VALUES ('246' '18' '鞍山' '2'); INSERT INTO `city` VALUES ('247' '18' '本溪' '2'); INSERT INTO `city` VALUES ('248' '18' '朝阳' '2'); INSERT INTO `city` VALUES ('249' '18' '丹东' '2'); INSERT INTO `city` VALUES ('250' '18' '抚顺' '2'); INSERT INTO `city` VALUES ('251' '18' '阜新' '2'); INSERT INTO `city` VALUES ('252' '18' '葫芦岛' '2'); INSERT INTO `city` VALUES ('253' '18' '锦州' '2'); INSERT INTO `city` VALUES ('254' '18' '辽阳' '2'); INSERT INTO `city` VALUES ('255' '18' '盘锦' '2'); INSERT INTO `city` VALUES ('256' '18' '铁岭' '2'); INSERT INTO `city` VALUES ('257' '18' '营口' '2'); INSERT INTO `city` VALUES ('258' '19' '呼和浩特' '2'); INSERT INTO `city` VALUES ('259' '19' '阿拉善盟' '2'); INSERT INTO `city` VALUES ('260' '19' '巴彦淖尔盟' '2'); INSERT INTO `city` VALUES ('261' '19' '包头' '2'); INSERT INTO `city` VALUES ('262' '19' '赤峰' '2'); INSERT INTO `city` VALUES ('263' '19' '鄂尔多斯' '2'); INSERT INTO `city` VALUES ('264' '19' '呼伦贝尔' '2'); INSERT INTO `city` VALUES ('265' '19' '通辽' '2'); INSERT INTO `city` VALUES ('266' '19' '乌海' '2'); INSERT INTO `city` VALUES ('267' '19' '乌兰察布市' '2'); INSERT INTO `city` VALUES ('268' '19' '锡林郭勒盟' '2'); INSERT INTO `city` VALUES ('269' '19' '兴安盟' '2'); INSERT INTO `city` VALUES ('270' '20' '银川' '2'); INSERT INTO `city` VALUES ('271' '20' '固原' '2'); INSERT INTO `city` VALUES ('272' '20' '石嘴山' '2');INSERT INTO `city` VALUES ('274' '20' '中卫' '2'); INSERT INTO `city` VALUES ('275' '21' '西宁' '2'); INSERT INTO `city` VALUES ('276' '21' '果洛' '2'); INSERT INTO `city` VALUES ('277' '21' '海北' '2'); INSERT INTO `city` VALUES ('278' '21' '海东' '2'); INSERT INTO `city` VALUES ('279' '21' '海南' '2'); INSERT INTO `city` VALUES ('280' '21' '海西' '2'); INSERT INTO `city` VALUES ('281' '21' '黄南' '2'); INSERT INTO `city` VALUES ('282' '21' '玉树' '2'); INSERT INTO `city` VALUES ('283' '22' '济南' '2'); INSERT INTO `city` VALUES ('284' '22' '青岛' '2'); INSERT INTO `city` VALUES ('285' '22' '滨州' '2'); INSERT INTO `city` VALUES ('286' '22' '德州' '2'); INSERT INTO `city` VALUES ('287' '22' '东营' '2'); INSERT INTO `city` VALUES ('288' '22' '菏泽' '2'); INSERT INTO `city` VALUES ('289' '22' '济宁' '2'); INSERT INTO `city` VALUES ('290' '22' '莱芜' '2'); INSERT INTO `city` VALUES ('291' '22' '聊城' '2'); INSERT INTO `city` VALUES ('292' '22' '临沂' '2'); INSERT INTO `city` VALUES ('293' '22' '日照' '2'); INSERT INTO `city` VALUES ('294' '22' '泰安' '2'); INSERT INTO `city` VALUES ('295' '22' '威海' '2'); INSERT INTO `city` VALUES ('296' '22' '潍坊' '2'); INSERT INTO `city` VALUES ('297' '22' '烟台' '2'); INSERT INTO `city` VALUES ('298' '22' '枣庄' '2'); INSERT INTO `city` VALUES ('299' '22' '淄博' '2'); INSERT INTO `city` VALUES ('300' '23' '太原' '2'); INSERT INTO `city` VALUES ('301' '23' '长治' '2'); INSERT INTO `city` VALUES ('302' '23' '大同' '2'); INSERT INTO `city` VALUES ('303' '23' '晋城' '2'); INSERT INTO `city` VALUES ('304' '23' '晋中' '2'); INSERT INTO `city` VALUES ('305' '23' '临汾' '2'); INSERT INTO `city` VALUES ('306' '23' '吕梁' '2'); INSERT INTO `city` VALUES ('307' '23' '朔州' '2'); INSERT INTO `city` VALUES ('308' '23' '忻州' '2'); INSERT INTO `city` VALUES ('309' '23' '阳泉' '2'); INSERT INTO `city` VALUES ('310' '23' '运城' '2'); INSERT INTO `city` VALUES ('311' '24' '西安' '2'); INSERT INTO `city` VALUES ('312' '24' '安康' '2');INSERT INTO `city` VALUES ('314' '24' '汉中' '2'); INSERT INTO `city` VALUES ('315' '24' '商洛' '2'); INSERT INTO `city` VALUES ('316' '24' '铜川' '2'); INSERT INTO `city` VALUES ('317' '24' '渭南' '2'); INSERT INTO `city` VALUES ('318' '24' '咸阳' '2'); INSERT INTO `city` VALUES ('319' '24' '延安' '2'); INSERT INTO `city` VALUES ('320' '24' '榆林' '2'); INSERT INTO `city` VALUES ('321' '25' '上海' '2'); INSERT INTO `city` VALUES ('322' '26' '成都' '2'); INSERT INTO `city` VALUES ('323' '26' '绵阳' '2'); INSERT INTO `city` VALUES ('324' '26' '阿坝' '2'); INSERT INTO `city` VALUES ('325' '26' '巴中' '2'); INSERT INTO `city` VALUES ('326' '26' '达州' '2'); INSERT INTO `city` VALUES ('327' '26' '德阳' '2'); INSERT INTO `city` VALUES ('328' '26' '甘孜' '2'); INSERT INTO `city` VALUES ('329' '26' '广安' '2'); INSERT INTO `city` VALUES ('330' '26' '广元' '2'); INSERT INTO `city` VALUES ('331' '26' '乐山' '2'); INSERT INTO `city` VALUES ('332' '26' '凉山' '2'); INSERT INTO `city` VALUES ('333' '26' '眉山' '2'); INSERT INTO `city` VALUES ('334' '26' '南充' '2'); INSERT INTO `city` VALUES ('335' '26' '内江' '2'); INSERT INTO `city` VALUES ('336' '26' '攀枝花' '2'); INSERT INTO `city` VALUES ('337' '26' '遂宁' '2'); INSERT INTO `city` VALUES ('338' '26' '雅安' '2'); INSERT INTO `city` VALUES ('339' '26' '宜宾' '2'); INSERT INTO `city` VALUES ('340' '26' '资阳' '2'); INSERT INTO `city` VALUES ('341' '26' '自贡' '2'); INSERT INTO `city` VALUES ('342' '26' '泸州' '2'); INSERT INTO `city` VALUES ('343' '27' '天津' '2'); INSERT INTO `city` VALUES ('344' '28' '拉萨' '2'); INSERT INTO `city` VALUES ('345' '28' '阿里' '2'); INSERT INTO `city` VALUES ('346' '28' '昌都' '2'); INSERT INTO `city` VALUES ('347' '28' '林芝' '2'); INSERT INTO `city` VALUES ('348' '28' '那曲' '2'); INSERT INTO `city` VALUES ('349' '28' '日喀则' '2'); INSERT INTO `city` VALUES ('350' '28' '山南' '2'); INSERT INTO `city` VALUES ('351' '29' '乌鲁木齐' '2'); INSERT INTO `city` VALUES ('352' '29' '阿克苏' '2');INSERT INTO `city` VALUES ('354' '29' '巴音郭楞' '2'); INSERT INTO `city` VALUES ('355' '29' '博尔塔拉' '2'); INSERT INTO `city` VALUES ('356' '29' '昌吉' '2'); INSERT INTO `city` VALUES ('357' '29' '哈密' '2'); INSERT INTO `city` VALUES ('358' '29' '和田' '2'); INSERT INTO `city` VALUES ('359' '29' '喀什' '2'); INSERT INTO `city` VALUES ('360' '29' '克拉玛依' '2'); INSERT INTO `city` VALUES ('361' '29' '克孜勒苏' '2'); INSERT INTO `city` VALUES ('362' '29' '石河子' '2'); INSERT INTO `city` VALUES ('363' '29' '图木舒克' '2'); INSERT INTO `city` VALUES ('364' '29' '吐鲁番' '2'); INSERT INTO `city` VALUES ('365' '29' '五家渠' '2'); INSERT INTO `city` VALUES ('366' '29' '伊犁' '2'); INSERT INTO `city` VALUES ('367' '30' '昆明' '2'); INSERT INTO `city` VALUES ('368' '30' '怒江' '2'); INSERT INTO `city` VALUES ('369' '30' '普洱' '2'); INSERT INTO `city` VALUES ('370' '30' '丽江' '2'); INSERT INTO `city` VALUES ('371' '30' '保山' '2'); INSERT INTO `city` VALUES ('372' '30' '楚雄' '2'); INSERT INTO `city` VALUES ('373' '30' '大理' '2'); INSERT INTO `city` VALUES ('374' '30' '德宏' '2'); INSERT INTO `city` VALUES ('375' '30' '迪庆' '2'); INSERT INTO `city` VALUES ('376' '30' '红河' '2'); INSERT INTO `city` VALUES ('377' '30' '临沧' '2'); INSERT INTO `city` VALUES ('378' '30' '曲靖' '2'); INSERT INTO `city` VALUES ('379' '30' '文山' '2'); INSERT INTO `city` VALUES ('380' '30' '西双版纳' '2'); INSERT INTO `city` VALUES ('381' '30' '玉溪' '2'); INSERT INTO `city` VALUES ('382' '30' '昭通' '2'); INSERT INTO `city` VALUES ('383' '31' '杭州' '2'); INSERT INTO `city` VALUES ('384' '31' '湖州' '2'); INSERT INTO `city` VALUES ('385' '31' '嘉兴' '2'); INSERT INTO `city` VALUES ('386' '31' '金华' '2'); INSERT INTO `city` VALUES ('387' '31' '丽水' '2'); INSERT INTO `city` VALUES ('388' '31' '宁波' '2'); INSERT INTO `city` VALUES ('389' '31' '绍兴' '2'); INSERT INTO `city` VALUES ('390' '31' '台州' '2'); INSERT INTO `city` VALUES ('391' '31' '温州' '2'); INSERT INTO `city` VALUES ('392' '31' '舟山' '2');。

全国省市数据库(修正后)

全国省市数据库--创建DBPromary数据库create database DBPromaryuse DBPromarygo--创建promary表create table promary(proID int primary key,proName nvarchar(50) not null //有中文的时候必须是nvarchar)------------------------------------------------------------------------------------------------------------------------------------------中国34个省级行政单位23个省5个自治区4个直辖市2特别行政区//在中文前面都要加Ninsert into promary values(1,N'北京市')insert into promary values(2,N'天津市')insert into promary values(3,N'上海市')insert into promary values(4,N'重庆市')insert into promary values(5,N'河北省')insert into promary values(6,N'山西省')insert into promary values(7,N'台湾省')insert into promary values(8,N'辽宁省')insert into promary values(9,N'吉林省')insert into promary values(10,N'黑龙江省')insert into promary values(11,N'江苏省')insert into promary values(12,N'浙江省')insert into promary values(13,N'安徽省')insert into promary values(14,N'福建省')insert into promary values(15,N'江西省')insert into promary values(16,N'山东省')insert into promary values(17,N'河南省')insert into promary values(18,N'湖北省')insert into promary values(19,N'湖南省')insert into promary values(20,N'广东省')insert into promary values(21,N'甘肃省')insert into promary values(22,N'四川省')insert into promary values(23,N'贵州省')insert into promary values(24,N'海南省')insert into promary values(25,N'云南省')insert into promary values(26,N'青海省')insert into promary values(27,N'陕西省')insert into promary values(28,N'广西壮族自治区')insert into promary values(29,N'西藏自治区')insert into promary values(30,N'宁夏回族自治区')insert into promary values(31,N'新疆维吾尔自治区')insert into promary values(32,N'内蒙古自治区')insert into promary values(33,N'澳门特别行政区')insert into promary values(34,N'香港特别行政区')--------------------------------------------------------------------------------------------------------------------------------- --创建city表create table city(cityID int not null,cityName varchar(50) primary key,proID int foreign key references promary(proID))--------------------------------------------------------------------------------------------------------------------------------- --插入各个省的城市数据--4个直辖市insert into city values(1,'北京市',1)insert into city values(1,'天津市',2)insert into city values(1,'上海市',3)insert into city values(1,'重庆市',4)--5河北省(2005年辖：个地级市，个市辖区、个县级市、个县、个自治县)insert into city values(1,'石家庄市',5)insert into city values(2,'唐山市',5)insert into city values(3,'秦皇岛市',5)insert into city values(4,'邯郸市',5)insert into city values(5,'邢台市',5)insert into city values(6,'保定市',5)insert into city values(7,'张家口市',5)insert into city values(8,'承德市',5)insert into city values(9,'沧州市',5)insert into city values(10,'廊坊市',5)insert into city values(11,'衡水市',5)--6山西省个城市insert into city values(1,'太原市',6)insert into city values(2,'大同市',6)insert into city values(3,'阳泉市',6)insert into city values(4,'长治市',6)insert into city values(5,'晋城市',6)insert into city values(6,'朔州市',6)insert into city values(7,'晋中市',6)insert into city values(8,'运城市',6)insert into city values(10,'临汾市',6)insert into city values(11,'吕梁市',6)--7台湾省(台湾本岛和澎湖共设市、县，其中台北市和高雄市为“院辖市”，直属“行政院”，其余属台湾省；市下设区，县下设市（县辖市）、镇、乡，合称区市镇乡。

中国省市区----SQL表

中国省市区----SQL表[sql] view plain copy print?在CODE上查看代码⽚派⽣到我的代码⽚SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for rc_district-- ----------------------------DROP TABLE IF EXISTS `rc_district`;CREATE TABLE `rc_district` (`district_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '⾃增id',`pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '⽗及关系',`district` varchar(120) NOT NULL DEFAULT '' COMMENT '地区名称',`level` tinyint(1) NOT NULL COMMENT '⼦属关系',PRIMARY KEY (`district_id`),KEY `parent_id` (`pid`),KEY `region_type` (`level`)) ENGINE=MyISAM AUTO_INCREMENT=3432 DEFAULT CHARSET=utf8 COMMENT='地区表';-- ------------------------------ Records of rc_district-- ----------------------------INSERT INTO `rc_district` VALUES ('1', '0', '中国', '0');INSERT INTO `rc_district` VALUES ('2', '1', '北京市', '1');INSERT INTO `rc_district` VALUES ('3', '1', '安徽省', '1');INSERT INTO `rc_district` VALUES ('4', '1', '福建省', '1');INSERT INTO `rc_district` VALUES ('5', '1', '⽢肃省', '1');INSERT INTO `rc_district` VALUES ('6', '1', '⼴东省', '1');INSERT INTO `rc_district` VALUES ('7', '1', '⼴西壮族⾃治区', '1');INSERT INTO `rc_district` VALUES ('8', '1', '贵州省', '1');INSERT INTO `rc_district` VALUES ('9', '1', '海南省', '1');INSERT INTO `rc_district` VALUES ('10', '1', '河北省', '1');INSERT INTO `rc_district` VALUES ('11', '1', '河南省', '1');INSERT INTO `rc_district` VALUES ('12', '1', '⿊龙江省', '1');INSERT INTO `rc_district` VALUES ('13', '1', '湖北省', '1');INSERT INTO `rc_district` VALUES ('14', '1', '湖南省', '1');INSERT INTO `rc_district` VALUES ('15', '1', '吉林省', '1');INSERT INTO `rc_district` VALUES ('16', '1', '江苏省', '1');INSERT INTO `rc_district` VALUES ('17', '1', '江西省', '1');INSERT INTO `rc_district` VALUES ('18', '1', '辽宁省', '1');INSERT INTO `rc_district` VALUES ('19', '1', '内蒙古⾃治区', '1');INSERT INTO `rc_district` VALUES ('20', '1', '宁夏回族⾃治区', '1');INSERT INTO `rc_district` VALUES ('21', '1', '青海省', '1');INSERT INTO `rc_district` VALUES ('22', '1', '⼭东省', '1');INSERT INTO `rc_district` VALUES ('23', '1', '⼭西省', '1');INSERT INTO `rc_district` VALUES ('24', '1', '陕西省', '1');INSERT INTO `rc_district` VALUES ('25', '1', '上海市', '1');INSERT INTO `rc_district` VALUES ('26', '1', '四川省', '1');INSERT INTO `rc_district` VALUES ('27', '1', '天津市', '1');INSERT INTO `rc_district` VALUES ('28', '1', '西藏⾃治区', '1');INSERT INTO `rc_district` VALUES ('29', '1', '新疆维吾尔⾃治区', '1');INSERT INTO `rc_district` VALUES ('30', '1', '云南省', '1');INSERT INTO `rc_district` VALUES ('31', '1', '浙江省', '1');INSERT INTO `rc_district` VALUES ('32', '1', '重庆市', '1');INSERT INTO `rc_district` VALUES ('33', '1', '⾹港特别⾏政区', '1');INSERT INTO `rc_district` VALUES ('34', '1', '澳门特别⾏政区', '1');INSERT INTO `rc_district` VALUES ('35', '1', '台湾省', '1');INSERT INTO `rc_district` VALUES ('36', '3', '安庆', '2');INSERT INTO `rc_district` VALUES ('37', '3', '蚌埠', '2');INSERT INTO `rc_district` VALUES ('38', '3', '巢湖', '2');INSERT INTO `rc_district` VALUES ('46', '3', '马鞍⼭', '2'); INSERT INTO `rc_district` VALUES ('47', '3', '宿州', '2'); INSERT INTO `rc_district` VALUES ('48', '3', '铜陵', '2'); INSERT INTO `rc_district` VALUES ('49', '3', '芜湖', '2'); INSERT INTO `rc_district` VALUES ('50', '3', '宣城', '2'); INSERT INTO `rc_district` VALUES ('51', '3', '亳州', '2'); INSERT INTO `rc_district` VALUES ('52', '2', '北京', '2'); INSERT INTO `rc_district` VALUES ('53', '4', '福州', '2'); INSERT INTO `rc_district` VALUES ('54', '4', '龙岩', '2'); INSERT INTO `rc_district` VALUES ('55', '4', '南平', '2'); INSERT INTO `rc_district` VALUES ('56', '4', '宁德', '2'); INSERT INTO `rc_district` VALUES ('57', '4', '莆⽥', '2'); INSERT INTO `rc_district` VALUES ('58', '4', '泉州', '2'); INSERT INTO `rc_district` VALUES ('59', '4', '三明', '2'); INSERT INTO `rc_district` VALUES ('60', '4', '厦门', '2'); INSERT INTO `rc_district` VALUES ('61', '4', '漳州', '2'); INSERT INTO `rc_district` VALUES ('62', '5', '兰州', '2'); INSERT INTO `rc_district` VALUES ('63', '5', '⽩银', '2'); INSERT INTO `rc_district` VALUES ('64', '5', '定西', '2'); INSERT INTO `rc_district` VALUES ('65', '5', '⽢南', '2'); INSERT INTO `rc_district` VALUES ('66', '5', '嘉峪关', '2'); INSERT INTO `rc_district` VALUES ('67', '5', '⾦昌', '2'); INSERT INTO `rc_district` VALUES ('68', '5', '酒泉', '2'); INSERT INTO `rc_district` VALUES ('69', '5', '临夏', '2'); INSERT INTO `rc_district` VALUES ('70', '5', '陇南', '2'); INSERT INTO `rc_district` VALUES ('71', '5', '平凉', '2'); INSERT INTO `rc_district` VALUES ('72', '5', '庆阳', '2'); INSERT INTO `rc_district` VALUES ('73', '5', '天⽔', '2'); INSERT INTO `rc_district` VALUES ('74', '5', '武威', '2'); INSERT INTO `rc_district` VALUES ('75', '5', '张掖', '2'); INSERT INTO `rc_district` VALUES ('76', '6', '⼴州', '2'); INSERT INTO `rc_district` VALUES ('77', '6', '深圳', '2'); INSERT INTO `rc_district` VALUES ('78', '6', '潮州', '2'); INSERT INTO `rc_district` VALUES ('79', '6', '东莞', '2'); INSERT INTO `rc_district` VALUES ('80', '6', '佛⼭', '2'); INSERT INTO `rc_district` VALUES ('81', '6', '河源', '2'); INSERT INTO `rc_district` VALUES ('82', '6', '惠州', '2'); INSERT INTO `rc_district` VALUES ('83', '6', '江门', '2'); INSERT INTO `rc_district` VALUES ('84', '6', '揭阳', '2'); INSERT INTO `rc_district` VALUES ('85', '6', '茂名', '2'); INSERT INTO `rc_district` VALUES ('86', '6', '梅州', '2'); INSERT INTO `rc_district` VALUES ('87', '6', '清远', '2'); INSERT INTO `rc_district` VALUES ('88', '6', '汕头', '2'); INSERT INTO `rc_district` VALUES ('89', '6', '汕尾', '2'); INSERT INTO `rc_district` VALUES ('90', '6', '韶关', '2'); INSERT INTO `rc_district` VALUES ('91', '6', '阳江', '2'); INSERT INTO `rc_district` VALUES ('92', '6', '云浮', '2'); INSERT INTO `rc_district` VALUES ('93', '6', '湛江', '2'); INSERT INTO `rc_district` VALUES ('94', '6', '肇庆', '2'); INSERT INTO `rc_district` VALUES ('95', '6', '中⼭', '2'); INSERT INTO `rc_district` VALUES ('96', '6', '珠海', '2'); INSERT INTO `rc_district` VALUES ('97', '7', '南宁', '2'); INSERT INTO `rc_district` VALUES ('98', '7', '桂林', '2'); INSERT INTO `rc_district` VALUES ('99', '7', '百⾊', '2'); INSERT INTO `rc_district` VALUES ('100', '7', '北海', '2'); INSERT INTO `rc_district` VALUES ('101', '7', '崇左', '2'); INSERT INTO `rc_district` VALUES ('102', '7', '防城港', '2'); INSERT INTO `rc_district` VALUES ('103', '7', '贵港', '2');INSERT INTO `rc_district` VALUES ('111', '8', '贵阳', '2'); INSERT INTO `rc_district` VALUES ('112', '8', '安顺', '2'); INSERT INTO `rc_district` VALUES ('113', '8', '毕节', '2'); INSERT INTO `rc_district` VALUES ('114', '8', '六盘⽔', '2'); INSERT INTO `rc_district` VALUES ('115', '8', '黔东南', '2'); INSERT INTO `rc_district` VALUES ('116', '8', '黔南', '2'); INSERT INTO `rc_district` VALUES ('117', '8', '黔西南', '2'); INSERT INTO `rc_district` VALUES ('118', '8', '铜仁', '2'); INSERT INTO `rc_district` VALUES ('119', '8', '遵义', '2'); INSERT INTO `rc_district` VALUES ('120', '9', '海⼝', '2'); INSERT INTO `rc_district` VALUES ('121', '9', '三亚', '2'); INSERT INTO `rc_district` VALUES ('122', '9', '⽩沙', '2'); INSERT INTO `rc_district` VALUES ('123', '9', '保亭', '2'); INSERT INTO `rc_district` VALUES ('124', '9', '昌江', '2'); INSERT INTO `rc_district` VALUES ('125', '9', '澄迈县', '2'); INSERT INTO `rc_district` VALUES ('126', '9', '定安县', '2'); INSERT INTO `rc_district` VALUES ('127', '9', '东⽅', '2'); INSERT INTO `rc_district` VALUES ('128', '9', '乐东', '2'); INSERT INTO `rc_district` VALUES ('129', '9', '临⾼县', '2'); INSERT INTO `rc_district` VALUES ('130', '9', '陵⽔', '2'); INSERT INTO `rc_district` VALUES ('131', '9', '琼海', '2'); INSERT INTO `rc_district` VALUES ('132', '9', '琼中', '2'); INSERT INTO `rc_district` VALUES ('133', '9', '屯昌县', '2'); INSERT INTO `rc_district` VALUES ('134', '9', '万宁', '2'); INSERT INTO `rc_district` VALUES ('135', '9', '⽂昌', '2'); INSERT INTO `rc_district` VALUES ('136', '9', '五指⼭', '2'); INSERT INTO `rc_district` VALUES ('137', '9', '儋州', '2'); INSERT INTO `rc_district` VALUES ('138', '10', '⽯家庄', '2'); INSERT INTO `rc_district` VALUES ('139', '10', '保定', '2'); INSERT INTO `rc_district` VALUES ('140', '10', '沧州', '2'); INSERT INTO `rc_district` VALUES ('141', '10', '承德', '2'); INSERT INTO `rc_district` VALUES ('142', '10', '邯郸', '2'); INSERT INTO `rc_district` VALUES ('143', '10', '衡⽔', '2'); INSERT INTO `rc_district` VALUES ('144', '10', '廊坊', '2'); INSERT INTO `rc_district` VALUES ('145', '10', '秦皇岛', '2'); INSERT INTO `rc_district` VALUES ('146', '10', '唐⼭', '2'); INSERT INTO `rc_district` VALUES ('147', '10', '邢台', '2'); INSERT INTO `rc_district` VALUES ('148', '10', '张家⼝', '2'); INSERT INTO `rc_district` VALUES ('149', '11', '郑州', '2'); INSERT INTO `rc_district` VALUES ('150', '11', '洛阳', '2'); INSERT INTO `rc_district` VALUES ('151', '11', '开封', '2'); INSERT INTO `rc_district` VALUES ('152', '11', '安阳', '2'); INSERT INTO `rc_district` VALUES ('153', '11', '鹤壁', '2'); INSERT INTO `rc_district` VALUES ('154', '11', '济源', '2'); INSERT INTO `rc_district` VALUES ('155', '11', '焦作', '2'); INSERT INTO `rc_district` VALUES ('156', '11', '南阳', '2'); INSERT INTO `rc_district` VALUES ('157', '11', '平顶⼭', '2'); INSERT INTO `rc_district` VALUES ('158', '11', '三门峡', '2'); INSERT INTO `rc_district` VALUES ('159', '11', '商丘', '2'); INSERT INTO `rc_district` VALUES ('160', '11', '新乡', '2'); INSERT INTO `rc_district` VALUES ('161', '11', '信阳', '2'); INSERT INTO `rc_district` VALUES ('162', '11', '许昌', '2'); INSERT INTO `rc_district` VALUES ('163', '11', '周⼝', '2'); INSERT INTO `rc_district` VALUES ('164', '11', '驻马店', '2'); INSERT INTO `rc_district` VALUES ('165', '11', '漯河', '2'); INSERT INTO `rc_district` VALUES ('166', '11', '濮阳', '2'); INSERT INTO `rc_district` VALUES ('167', '12', '哈尔滨', '2'); INSERT INTO `rc_district` VALUES ('168', '12', '⼤庆', '2');INSERT INTO `rc_district` VALUES ('176', '12', '齐齐哈尔', '2'); INSERT INTO `rc_district` VALUES ('177', '12', '双鸭⼭', '2'); INSERT INTO `rc_district` VALUES ('178', '12', '绥化', '2'); INSERT INTO `rc_district` VALUES ('179', '12', '伊春', '2'); INSERT INTO `rc_district` VALUES ('180', '13', '武汉', '2'); INSERT INTO `rc_district` VALUES ('181', '13', '仙桃', '2'); INSERT INTO `rc_district` VALUES ('182', '13', '鄂州', '2'); INSERT INTO `rc_district` VALUES ('183', '13', '黄冈', '2'); INSERT INTO `rc_district` VALUES ('184', '13', '黄⽯', '2'); INSERT INTO `rc_district` VALUES ('185', '13', '荆门', '2'); INSERT INTO `rc_district` VALUES ('186', '13', '荆州', '2'); INSERT INTO `rc_district` VALUES ('187', '13', '潜江', '2'); INSERT INTO `rc_district` VALUES ('188', '13', '神农架林区', '2'); INSERT INTO `rc_district` VALUES ('189', '13', '⼗堰', '2'); INSERT INTO `rc_district` VALUES ('190', '13', '随州', '2'); INSERT INTO `rc_district` VALUES ('191', '13', '天门', '2'); INSERT INTO `rc_district` VALUES ('192', '13', '咸宁', '2'); INSERT INTO `rc_district` VALUES ('193', '13', '襄樊', '2'); INSERT INTO `rc_district` VALUES ('194', '13', '孝感', '2'); INSERT INTO `rc_district` VALUES ('195', '13', '宜昌', '2'); INSERT INTO `rc_district` VALUES ('196', '13', '恩施', '2'); INSERT INTO `rc_district` VALUES ('197', '14', '长沙', '2'); INSERT INTO `rc_district` VALUES ('198', '14', '张家界', '2'); INSERT INTO `rc_district` VALUES ('199', '14', '常德', '2'); INSERT INTO `rc_district` VALUES ('200', '14', '郴州', '2'); INSERT INTO `rc_district` VALUES ('201', '14', '衡阳', '2'); INSERT INTO `rc_district` VALUES ('202', '14', '怀化', '2'); INSERT INTO `rc_district` VALUES ('203', '14', '娄底', '2'); INSERT INTO `rc_district` VALUES ('204', '14', '邵阳', '2'); INSERT INTO `rc_district` VALUES ('205', '14', '湘潭', '2'); INSERT INTO `rc_district` VALUES ('206', '14', '湘西', '2'); INSERT INTO `rc_district` VALUES ('207', '14', '益阳', '2'); INSERT INTO `rc_district` VALUES ('208', '14', '永州', '2'); INSERT INTO `rc_district` VALUES ('209', '14', '岳阳', '2'); INSERT INTO `rc_district` VALUES ('210', '14', '株洲', '2'); INSERT INTO `rc_district` VALUES ('211', '15', '长春', '2'); INSERT INTO `rc_district` VALUES ('212', '15', '吉林', '2'); INSERT INTO `rc_district` VALUES ('213', '15', '⽩城', '2'); INSERT INTO `rc_district` VALUES ('214', '15', '⽩⼭', '2'); INSERT INTO `rc_district` VALUES ('215', '15', '辽源', '2'); INSERT INTO `rc_district` VALUES ('216', '15', '四平', '2'); INSERT INTO `rc_district` VALUES ('217', '15', '松原', '2'); INSERT INTO `rc_district` VALUES ('218', '15', '通化', '2'); INSERT INTO `rc_district` VALUES ('219', '15', '延边', '2'); INSERT INTO `rc_district` VALUES ('220', '16', '南京', '2'); INSERT INTO `rc_district` VALUES ('221', '16', '苏州', '2'); INSERT INTO `rc_district` VALUES ('222', '16', '⽆锡', '2'); INSERT INTO `rc_district` VALUES ('223', '16', '常州', '2'); INSERT INTO `rc_district` VALUES ('224', '16', '淮安', '2'); INSERT INTO `rc_district` VALUES ('225', '16', '连云港', '2'); INSERT INTO `rc_district` VALUES ('226', '16', '南通', '2'); INSERT INTO `rc_district` VALUES ('227', '16', '宿迁', '2'); INSERT INTO `rc_district` VALUES ('228', '16', '泰州', '2'); INSERT INTO `rc_district` VALUES ('229', '16', '徐州', '2'); INSERT INTO `rc_district` VALUES ('230', '16', '盐城', '2'); INSERT INTO `rc_district` VALUES ('231', '16', '扬州', '2'); INSERT INTO `rc_district` VALUES ('232', '16', '镇江', '2'); INSERT INTO `rc_district` VALUES ('233', '17', '南昌', '2');INSERT INTO `rc_district` VALUES ('242', '17', '宜春', '2'); INSERT INTO `rc_district` VALUES ('243', '17', '鹰潭', '2'); INSERT INTO `rc_district` VALUES ('244', '18', '沈阳', '2'); INSERT INTO `rc_district` VALUES ('245', '18', '⼤连', '2'); INSERT INTO `rc_district` VALUES ('246', '18', '鞍⼭', '2'); INSERT INTO `rc_district` VALUES ('247', '18', '本溪', '2'); INSERT INTO `rc_district` VALUES ('248', '18', '朝阳', '2'); INSERT INTO `rc_district` VALUES ('249', '18', '丹东', '2'); INSERT INTO `rc_district` VALUES ('250', '18', '抚顺', '2'); INSERT INTO `rc_district` VALUES ('251', '18', '⾩新', '2'); INSERT INTO `rc_district` VALUES ('252', '18', '葫芦岛', '2'); INSERT INTO `rc_district` VALUES ('253', '18', '锦州', '2'); INSERT INTO `rc_district` VALUES ('254', '18', '辽阳', '2'); INSERT INTO `rc_district` VALUES ('255', '18', '盘锦', '2'); INSERT INTO `rc_district` VALUES ('256', '18', '铁岭', '2'); INSERT INTO `rc_district` VALUES ('257', '18', '营⼝', '2'); INSERT INTO `rc_district` VALUES ('258', '19', '呼和浩特', '2'); INSERT INTO `rc_district` VALUES ('259', '19', '阿拉善盟', '2'); INSERT INTO `rc_district` VALUES ('260', '19', '巴彦淖尔盟', '2'); INSERT INTO `rc_district` VALUES ('261', '19', '包头', '2'); INSERT INTO `rc_district` VALUES ('262', '19', '⾚峰', '2'); INSERT INTO `rc_district` VALUES ('263', '19', '鄂尔多斯', '2'); INSERT INTO `rc_district` VALUES ('264', '19', '呼伦贝尔', '2'); INSERT INTO `rc_district` VALUES ('265', '19', '通辽', '2'); INSERT INTO `rc_district` VALUES ('266', '19', '乌海', '2'); INSERT INTO `rc_district` VALUES ('267', '19', '乌兰察布市', '2'); INSERT INTO `rc_district` VALUES ('268', '19', '锡林郭勒盟', '2'); INSERT INTO `rc_district` VALUES ('269', '19', '兴安盟', '2'); INSERT INTO `rc_district` VALUES ('270', '20', '银川', '2'); INSERT INTO `rc_district` VALUES ('271', '20', '固原', '2'); INSERT INTO `rc_district` VALUES ('272', '20', '⽯嘴⼭', '2'); INSERT INTO `rc_district` VALUES ('273', '20', '吴忠', '2'); INSERT INTO `rc_district` VALUES ('274', '20', '中卫', '2'); INSERT INTO `rc_district` VALUES ('275', '21', '西宁', '2'); INSERT INTO `rc_district` VALUES ('276', '21', '果洛', '2'); INSERT INTO `rc_district` VALUES ('277', '21', '海北', '2'); INSERT INTO `rc_district` VALUES ('278', '21', '海东', '2'); INSERT INTO `rc_district` VALUES ('279', '21', '海南', '2'); INSERT INTO `rc_district` VALUES ('280', '21', '海西', '2'); INSERT INTO `rc_district` VALUES ('281', '21', '黄南', '2'); INSERT INTO `rc_district` VALUES ('282', '21', '⽟树', '2'); INSERT INTO `rc_district` VALUES ('283', '22', '济南', '2'); INSERT INTO `rc_district` VALUES ('284', '22', '青岛', '2'); INSERT INTO `rc_district` VALUES ('285', '22', '滨州', '2'); INSERT INTO `rc_district` VALUES ('286', '22', '德州', '2'); INSERT INTO `rc_district` VALUES ('287', '22', '东营', '2'); INSERT INTO `rc_district` VALUES ('288', '22', '菏泽', '2'); INSERT INTO `rc_district` VALUES ('289', '22', '济宁', '2'); INSERT INTO `rc_district` VALUES ('290', '22', '莱芜', '2'); INSERT INTO `rc_district` VALUES ('291', '22', '聊城', '2'); INSERT INTO `rc_district` VALUES ('292', '22', '临沂', '2'); INSERT INTO `rc_district` VALUES ('293', '22', '⽇照', '2'); INSERT INTO `rc_district` VALUES ('294', '22', '泰安', '2'); INSERT INTO `rc_district` VALUES ('295', '22', '威海', '2'); INSERT INTO `rc_district` VALUES ('296', '22', '潍坊', '2'); INSERT INTO `rc_district` VALUES ('297', '22', '烟台', '2'); INSERT INTO `rc_district` VALUES ('298', '22', '枣庄', '2');INSERT INTO `rc_district` VALUES ('307', '23', '朔州', '2'); INSERT INTO `rc_district` VALUES ('308', '23', '忻州', '2'); INSERT INTO `rc_district` VALUES ('309', '23', '阳泉', '2'); INSERT INTO `rc_district` VALUES ('310', '23', '运城', '2'); INSERT INTO `rc_district` VALUES ('311', '24', '西安', '2'); INSERT INTO `rc_district` VALUES ('312', '24', '安康', '2'); INSERT INTO `rc_district` VALUES ('313', '24', '宝鸡', '2'); INSERT INTO `rc_district` VALUES ('314', '24', '汉中', '2'); INSERT INTO `rc_district` VALUES ('315', '24', '商洛', '2'); INSERT INTO `rc_district` VALUES ('316', '24', '铜川', '2'); INSERT INTO `rc_district` VALUES ('317', '24', '渭南', '2'); INSERT INTO `rc_district` VALUES ('318', '24', '咸阳', '2'); INSERT INTO `rc_district` VALUES ('319', '24', '延安', '2'); INSERT INTO `rc_district` VALUES ('320', '24', '榆林', '2'); INSERT INTO `rc_district` VALUES ('321', '25', '上海', '2'); INSERT INTO `rc_district` VALUES ('322', '26', '成都', '2'); INSERT INTO `rc_district` VALUES ('323', '26', '绵阳', '2'); INSERT INTO `rc_district` VALUES ('324', '26', '阿坝', '2'); INSERT INTO `rc_district` VALUES ('325', '26', '巴中', '2'); INSERT INTO `rc_district` VALUES ('326', '26', '达州', '2'); INSERT INTO `rc_district` VALUES ('327', '26', '德阳', '2'); INSERT INTO `rc_district` VALUES ('328', '26', '⽢孜', '2'); INSERT INTO `rc_district` VALUES ('329', '26', '⼴安', '2'); INSERT INTO `rc_district` VALUES ('330', '26', '⼴元', '2'); INSERT INTO `rc_district` VALUES ('331', '26', '乐⼭', '2'); INSERT INTO `rc_district` VALUES ('332', '26', '凉⼭', '2'); INSERT INTO `rc_district` VALUES ('333', '26', '眉⼭', '2'); INSERT INTO `rc_district` VALUES ('334', '26', '南充', '2'); INSERT INTO `rc_district` VALUES ('335', '26', '内江', '2'); INSERT INTO `rc_district` VALUES ('336', '26', '攀枝花', '2'); INSERT INTO `rc_district` VALUES ('337', '26', '遂宁', '2'); INSERT INTO `rc_district` VALUES ('338', '26', '雅安', '2'); INSERT INTO `rc_district` VALUES ('339', '26', '宜宾', '2'); INSERT INTO `rc_district` VALUES ('340', '26', '资阳', '2'); INSERT INTO `rc_district` VALUES ('341', '26', '⾃贡', '2'); INSERT INTO `rc_district` VALUES ('342', '26', '泸州', '2'); INSERT INTO `rc_district` VALUES ('343', '27', '天津', '2'); INSERT INTO `rc_district` VALUES ('344', '28', '拉萨', '2'); INSERT INTO `rc_district` VALUES ('345', '28', '阿⾥', '2'); INSERT INTO `rc_district` VALUES ('346', '28', '昌都', '2'); INSERT INTO `rc_district` VALUES ('347', '28', '林芝', '2'); INSERT INTO `rc_district` VALUES ('348', '28', '那曲', '2'); INSERT INTO `rc_district` VALUES ('349', '28', '⽇喀则', '2'); INSERT INTO `rc_district` VALUES ('350', '28', '⼭南', '2'); INSERT INTO `rc_district` VALUES ('351', '29', '乌鲁⽊齐', '2'); INSERT INTO `rc_district` VALUES ('352', '29', '阿克苏', '2'); INSERT INTO `rc_district` VALUES ('353', '29', '阿拉尔', '2'); INSERT INTO `rc_district` VALUES ('354', '29', '巴⾳郭楞', '2'); INSERT INTO `rc_district` VALUES ('355', '29', '博尔塔拉', '2'); INSERT INTO `rc_district` VALUES ('356', '29', '昌吉', '2'); INSERT INTO `rc_district` VALUES ('357', '29', '哈密', '2'); INSERT INTO `rc_district` VALUES ('358', '29', '和⽥', '2'); INSERT INTO `rc_district` VALUES ('359', '29', '喀什', '2'); INSERT INTO `rc_district` VALUES ('360', '29', '克拉玛依', '2'); INSERT INTO `rc_district` VALUES ('361', '29', '克孜勒苏', '2'); INSERT INTO `rc_district` VALUES ('362', '29', '⽯河⼦', '2'); INSERT INTO `rc_district` VALUES ('363', '29', '图⽊舒克', '2');。

quan中国省市区三级数据库表.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: iptohat_area# ------------------------------------------------------# Server version 5.0.26## Source for table hat_area#CREATE TABLE hat_area (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 hat_area#INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');INSERT INTO hat_area VALUES (18,'110229','延庆县','110200'); INSERT INTO hat_area VALUES (19,'120101','和平区','120100'); INSERT INTO hat_area VALUES (20,'120102','河东区','120100'); INSERT INTO hat_area VALUES (21,'120103','河西区','120100'); INSERT INTO hat_area VALUES (22,'120104','南开区','120100'); INSERT INTO hat_area VALUES (23,'120105','河北区','120100'); INSERT INTO hat_area VALUES (24,'120106','红桥区','120100'); INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100'); INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100'); INSERT INTO hat_area VALUES (27,'120109','大港区','120100'); INSERT INTO hat_area VALUES (28,'120110','东丽区','120100'); INSERT INTO hat_area VALUES (29,'120111','西青区','120100'); INSERT INTO hat_area VALUES (30,'120112','津南区','120100'); INSERT INTO hat_area VALUES (31,'120113','北辰区','120100'); INSERT INTO hat_area VALUES (32,'120114','武清区','120100'); INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100'); INSERT INTO hat_area VALUES (34,'120221','宁河县','120200'); INSERT INTO hat_area VALUES (35,'120223','静海县','120200'); INSERT INTO hat_area VALUES (36,'120225','蓟县','120200'); INSERT INTO hat_area VALUES (37,'130101','市辖区','130100'); INSERT INTO hat_area VALUES (38,'130102','长安区','130100'); INSERT INTO hat_area VALUES (39,'130103','桥东区','130100'); INSERT INTO hat_area VALUES (40,'130104','桥西区','130100'); INSERT INTO hat_area VALUES (41,'130105','新华区','130100'); INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100'); INSERT INTO hat_area VALUES (43,'130108','裕华区','130100'); INSERT INTO hat_area VALUES (44,'130121','井陉县','130100'); INSERT INTO hat_area VALUES (45,'130123','正定县','130100'); INSERT INTO hat_area VALUES (46,'130124','栾城县','130100'); INSERT INTO hat_area VALUES (47,'130125','行唐县','130100'); INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100'); INSERT INTO hat_area VALUES (49,'130127','高邑县','130100'); INSERT INTO hat_area VALUES (50,'130128','深泽县','130100'); INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100'); INSERT INTO hat_area VALUES (52,'130130','无极县','130100'); INSERT INTO hat_area VALUES (53,'130131','平山县','130100'); INSERT INTO hat_area VALUES (54,'130132','元氏县','130100'); INSERT INTO hat_area VALUES (55,'130133','赵县','130100'); INSERT INTO hat_area VALUES (56,'130181','辛集市','130100'); INSERT INTO hat_area VALUES (57,'130182','藁城市','130100'); INSERT INTO hat_area VALUES (58,'130183','晋州市','130100'); INSERT INTO hat_area VALUES (59,'130184','新乐市','130100'); INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');INSERT INTO hat_area VALUES (62,'130202','路南区','130200'); INSERT INTO hat_area VALUES (63,'130203','路北区','130200'); INSERT INTO hat_area VALUES (64,'130204','古冶区','130200'); INSERT INTO hat_area VALUES (65,'130205','开平区','130200'); INSERT INTO hat_area VALUES (66,'130207','丰南区','130200'); INSERT INTO hat_area VALUES (67,'130208','丰润区','130200'); INSERT INTO hat_area VALUES (68,'130223','滦县','130200'); INSERT INTO hat_area VALUES (69,'130224','滦南县','130200'); INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200'); INSERT INTO hat_area VALUES (71,'130227','迁西县','130200'); INSERT INTO hat_area VALUES (72,'130229','玉田县','130200'); INSERT INTO hat_area VALUES (73,'130230','唐海县','130200'); INSERT INTO hat_area VALUES (74,'130281','遵化市','130200'); INSERT INTO hat_area VALUES (75,'130283','迁安市','130200'); INSERT INTO hat_area VALUES (76,'130301','市辖区','130300'); INSERT INTO hat_area VALUES (77,'130302','海港区','130300'); INSERT INTO hat_area VALUES (78,'130303','山海关区','130300'); INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300'); INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300'); INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300'); INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300'); INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300'); INSERT INTO hat_area VALUES (84,'130401','市辖区','130400'); INSERT INTO hat_area VALUES (85,'130402','邯山区','130400'); INSERT INTO hat_area VALUES (86,'130403','丛台区','130400'); INSERT INTO hat_area VALUES (87,'130404','复兴区','130400'); INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400'); INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400'); INSERT INTO hat_area VALUES (90,'130423','临漳县','130400'); INSERT INTO hat_area VALUES (91,'130424','成安县','130400'); INSERT INTO hat_area VALUES (92,'130425','大名县','130400'); INSERT INTO hat_area VALUES (93,'130426','涉县','130400'); INSERT INTO hat_area VALUES (94,'130427','磁县','130400'); INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400'); INSERT INTO hat_area VALUES (96,'130429','永年县','130400'); INSERT INTO hat_area VALUES (97,'130430','邱县','130400'); INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400'); INSERT INTO hat_area VALUES (99,'130432','广平县','130400'); INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400'); INSERT INTO hat_area VALUES (101,'130434','魏县','130400'); INSERT INTO hat_area VALUES (102,'130435','曲周县','130400'); INSERT INTO hat_area VALUES (103,'130481','武安市','130400'); INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');INSERT INTO hat_area VALUES (106,'130503','桥西区','130500'); INSERT INTO hat_area VALUES (107,'130521','邢台县','130500'); INSERT INTO hat_area VALUES (108,'130522','临城县','130500'); INSERT INTO hat_area VALUES (109,'130523','内丘县','130500'); INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500'); INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500'); INSERT INTO hat_area VALUES (112,'130526','任县','130500'); INSERT INTO hat_area VALUES (113,'130527','南和县','130500'); INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500'); INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500'); INSERT INTO hat_area VALUES (116,'130530','新河县','130500'); INSERT INTO hat_area VALUES (117,'130531','广宗县','130500'); INSERT INTO hat_area VALUES (118,'130532','平乡县','130500'); INSERT INTO hat_area VALUES (119,'130533','威县','130500'); INSERT INTO hat_area VALUES (120,'130534','清河县','130500'); INSERT INTO hat_area VALUES (121,'130535','临西县','130500'); INSERT INTO hat_area VALUES (122,'130581','南宫市','130500'); INSERT INTO hat_area VALUES (123,'130582','沙河市','130500'); INSERT INTO hat_area VALUES (124,'130601','市辖区','130600'); INSERT INTO hat_area VALUES (125,'130602','新市区','130600'); INSERT INTO hat_area VALUES (126,'130603','北市区','130600'); INSERT INTO hat_area VALUES (127,'130604','南市区','130600'); INSERT INTO hat_area VALUES (128,'130621','满城县','130600'); INSERT INTO hat_area VALUES (129,'130622','清苑县','130600'); INSERT INTO hat_area VALUES (130,'130623','涞水县','130600'); INSERT INTO hat_area VALUES (131,'130624','阜平县','130600'); INSERT INTO hat_area VALUES (132,'130625','徐水县','130600'); INSERT INTO hat_area VALUES (133,'130626','定兴县','130600'); INSERT INTO hat_area VALUES (134,'130627','唐县','130600'); INSERT INTO hat_area VALUES (135,'130628','高阳县','130600'); INSERT INTO hat_area VALUES (136,'130629','容城县','130600'); INSERT INTO hat_area VALUES (137,'130630','涞源县','130600'); INSERT INTO hat_area VALUES (138,'130631','望都县','130600'); INSERT INTO hat_area VALUES (139,'130632','安新县','130600'); INSERT INTO hat_area VALUES (140,'130633','易县','130600'); INSERT INTO hat_area VALUES (141,'130634','曲阳县','130600'); INSERT INTO hat_area VALUES (142,'130635','蠡县','130600'); INSERT INTO hat_area VALUES (143,'130636','顺平县','130600'); INSERT INTO hat_area VALUES (144,'130637','博野县','130600'); INSERT INTO hat_area VALUES (145,'130638','雄县','130600'); INSERT INTO hat_area VALUES (146,'130681','涿州市','130600'); INSERT INTO hat_area VALUES (147,'130682','定州市','130600'); INSERT INTO hat_area VALUES (148,'130683','安国市','130600');INSERT INTO hat_area VALUES (150,'130701','市辖区','130700');INSERT INTO hat_area VALUES (151,'130702','桥东区','130700');INSERT INTO hat_area VALUES (152,'130703','桥西区','130700');INSERT INTO hat_area VALUES (153,'130705','宣化区','130700');INSERT INTO hat_area VALUES (154,'130706','下花园区','130700');INSERT INTO hat_area VALUES (155,'130721','宣化县','130700');INSERT INTO hat_area VALUES (156,'130722','张北县','130700');INSERT INTO hat_area VALUES (157,'130723','康保县','130700');INSERT INTO hat_area VALUES (158,'130724','沽源县','130700');INSERT INTO hat_area VALUES (159,'130725','尚义县','130700');INSERT INTO hat_area VALUES (160,'130726','蔚县','130700');INSERT INTO hat_area VALUES (161,'130727','阳原县','130700');INSERT INTO hat_area VALUES (162,'130728','怀安县','130700');INSERT INTO hat_area VALUES (163,'130729','万全县','130700');INSERT INTO hat_area VALUES (164,'130730','怀来县','130700');INSERT INTO hat_area VALUES (165,'130731','涿鹿县','130700');INSERT INTO hat_area VALUES (166,'130732','赤城县','130700');INSERT INTO hat_area VALUES (167,'130733','崇礼县','130700');INSERT INTO hat_area VALUES (168,'130801','市辖区','130800');INSERT INTO hat_area VALUES (169,'130802','双桥区','130800');INSERT INTO hat_area VALUES (170,'130803','双滦区','130800');INSERT INTO hat_area VALUES (171,'130804','鹰手营子矿区','130800'); INSERT INTO hat_area VALUES (172,'130821','承德县','130800');INSERT INTO hat_area VALUES (173,'130822','兴隆县','130800');INSERT INTO hat_area VALUES (174,'130823','平泉县','130800');INSERT INTO hat_area VALUES (175,'130824','滦平县','130800');INSERT INTO hat_area VALUES (176,'130825','隆化县','130800');INSERT INTO hat_area VALUES (177,'130826','丰宁满族自治县','130800'); INSERT INTO hat_area VALUES (178,'130827','宽城满族自治县','130800'); INSERT INTO hat_area VALUES (179,'130828','围场满族蒙古族自治县','130800'); INSERT INTO hat_area VALUES (180,'130901','市辖区','130900');INSERT INTO hat_area VALUES (181,'130902','新华区','130900');INSERT INTO hat_area VALUES (182,'130903','运河区','130900');INSERT INTO hat_area VALUES (183,'130921','沧县','130900');INSERT INTO hat_area VALUES (184,'130922','青县','130900');INSERT INTO hat_area VALUES (185,'130923','东光县','130900');INSERT INTO hat_area VALUES (186,'130924','海兴县','130900');INSERT INTO hat_area VALUES (187,'130925','盐山县','130900');INSERT INTO hat_area VALUES (188,'130926','肃宁县','130900');INSERT INTO hat_area VALUES (189,'130927','南皮县','130900');INSERT INTO hat_area VALUES (190,'130928','吴桥县','130900');INSERT INTO hat_area VALUES (191,'130929','献县','130900');INSERT INTO hat_area VALUES (192,'130930','孟村回族自治县','130900');INSERT INTO hat_area VALUES (194,'130982','任丘市','130900'); INSERT INTO hat_area VALUES (195,'130983','黄骅市','130900'); INSERT INTO hat_area VALUES (196,'130984','河间市','130900'); INSERT INTO hat_area VALUES (197,'131001','市辖区','131000'); INSERT INTO hat_area VALUES (198,'131002','安次区','131000'); INSERT INTO hat_area VALUES (199,'131003','广阳区','131000'); INSERT INTO hat_area VALUES (200,'131022','固安县','131000'); INSERT INTO hat_area VALUES (201,'131023','永清县','131000'); INSERT INTO hat_area VALUES (202,'131024','香河县','131000'); INSERT INTO hat_area VALUES (203,'131025','大城县','131000'); INSERT INTO hat_area VALUES (204,'131026','文安县','131000'); INSERT INTO hat_area VALUES (205,'131028','大厂回族自治县','131000'); INSERT INTO hat_area VALUES (206,'131081','霸州市','131000'); INSERT INTO hat_area VALUES (207,'131082','三河市','131000'); INSERT INTO hat_area VALUES (208,'131101','市辖区','131100'); INSERT INTO hat_area VALUES (209,'131102','桃城区','131100'); INSERT INTO hat_area VALUES (210,'131121','枣强县','131100'); INSERT INTO hat_area VALUES (211,'131122','武邑县','131100'); INSERT INTO hat_area VALUES (212,'131123','武强县','131100'); INSERT INTO hat_area VALUES (213,'131124','饶阳县','131100'); INSERT INTO hat_area VALUES (214,'131125','安平县','131100'); INSERT INTO hat_area VALUES (215,'131126','故城县','131100'); INSERT INTO hat_area VALUES (216,'131127','景县','131100'); INSERT INTO hat_area VALUES (217,'131128','阜城县','131100'); INSERT INTO hat_area VALUES (218,'131181','冀州市','131100'); INSERT INTO hat_area VALUES (219,'131182','深州市','131100'); INSERT INTO hat_area VALUES (220,'140101','市辖区','140100'); INSERT INTO hat_area VALUES (221,'140105','小店区','140100'); INSERT INTO hat_area VALUES (222,'140106','迎泽区','140100'); INSERT INTO hat_area VALUES (223,'140107','杏花岭区','140100'); INSERT INTO hat_area VALUES (224,'140108','尖草坪区','140100'); INSERT INTO hat_area VALUES (225,'140109','万柏林区','140100'); INSERT INTO hat_area VALUES (226,'140110','晋源区','140100'); INSERT INTO hat_area VALUES (227,'140121','清徐县','140100'); INSERT INTO hat_area VALUES (228,'140122','阳曲县','140100'); INSERT INTO hat_area VALUES (229,'140123','娄烦县','140100'); INSERT INTO hat_area VALUES (230,'140181','古交市','140100'); INSERT INTO hat_area VALUES (231,'140201','市辖区','140200'); INSERT INTO hat_area VALUES (232,'140202','城区','140200'); INSERT INTO hat_area VALUES (233,'140203','矿区','140200'); INSERT INTO hat_area VALUES (234,'140211','南郊区','140200'); INSERT INTO hat_area VALUES (235,'140212','新荣区','140200'); INSERT INTO hat_area VALUES (236,'140221','阳高县','140200');INSERT INTO hat_area VALUES (238,'140223','广灵县','140200'); INSERT INTO hat_area VALUES (239,'140224','灵丘县','140200'); INSERT INTO hat_area VALUES (240,'140225','浑源县','140200'); INSERT INTO hat_area VALUES (241,'140226','左云县','140200'); INSERT INTO hat_area VALUES (242,'140227','大同县','140200'); INSERT INTO hat_area VALUES (243,'140301','市辖区','140300'); INSERT INTO hat_area VALUES (244,'140302','城区','140300'); INSERT INTO hat_area VALUES (245,'140303','矿区','140300'); INSERT INTO hat_area VALUES (246,'140311','郊区','140300'); INSERT INTO hat_area VALUES (247,'140321','平定县','140300'); INSERT INTO hat_area VALUES (248,'140322','盂县','140300'); INSERT INTO hat_area VALUES (249,'140401','市辖区','140400'); INSERT INTO hat_area VALUES (250,'140402','城区','140400'); INSERT INTO hat_area VALUES (251,'140411','郊区','140400'); INSERT INTO hat_area VALUES (252,'140421','长治县','140400'); INSERT INTO hat_area VALUES (253,'140423','襄垣县','140400'); INSERT INTO hat_area VALUES (254,'140424','屯留县','140400'); INSERT INTO hat_area VALUES (255,'140425','平顺县','140400'); INSERT INTO hat_area VALUES (256,'140426','黎城县','140400'); INSERT INTO hat_area VALUES (257,'140427','壶关县','140400'); INSERT INTO hat_area VALUES (258,'140428','长子县','140400'); INSERT INTO hat_area VALUES (259,'140429','武乡县','140400'); INSERT INTO hat_area VALUES (260,'140430','沁县','140400'); INSERT INTO hat_area VALUES (261,'140431','沁源县','140400'); INSERT INTO hat_area VALUES (262,'140481','潞城市','140400'); INSERT INTO hat_area VALUES (263,'140501','市辖区','140500'); INSERT INTO hat_area VALUES (264,'140502','城区','140500'); INSERT INTO hat_area VALUES (265,'140521','沁水县','140500'); INSERT INTO hat_area VALUES (266,'140522','阳城县','140500'); INSERT INTO hat_area VALUES (267,'140524','陵川县','140500'); INSERT INTO hat_area VALUES (268,'140525','泽州县','140500'); INSERT INTO hat_area VALUES (269,'140581','高平市','140500'); INSERT INTO hat_area VALUES (270,'140601','市辖区','140600'); INSERT INTO hat_area VALUES (271,'140602','朔城区','140600'); INSERT INTO hat_area VALUES (272,'140603','平鲁区','140600'); INSERT INTO hat_area VALUES (273,'140621','山阴县','140600'); INSERT INTO hat_area VALUES (274,'140622','应县','140600'); INSERT INTO hat_area VALUES (275,'140623','右玉县','140600'); INSERT INTO hat_area VALUES (276,'140624','怀仁县','140600'); INSERT INTO hat_area VALUES (277,'140701','市辖区','140700'); INSERT INTO hat_area VALUES (278,'140702','榆次区','140700'); INSERT INTO hat_area VALUES (279,'140721','榆社县','140700'); INSERT INTO hat_area VALUES (280,'140722','左权县','140700');INSERT INTO hat_area VALUES (282,'140724','昔阳县','140700'); INSERT INTO hat_area VALUES (283,'140725','寿阳县','140700'); INSERT INTO hat_area VALUES (284,'140726','太谷县','140700'); INSERT INTO hat_area VALUES (285,'140727','祁县','140700'); INSERT INTO hat_area VALUES (286,'140728','平遥县','140700'); INSERT INTO hat_area VALUES (287,'140729','灵石县','140700'); INSERT INTO hat_area VALUES (288,'140781','介休市','140700'); INSERT INTO hat_area VALUES (289,'140801','市辖区','140800'); INSERT INTO hat_area VALUES (290,'140802','盐湖区','140800'); INSERT INTO hat_area VALUES (291,'140821','临猗县','140800'); INSERT INTO hat_area VALUES (292,'140822','万荣县','140800'); INSERT INTO hat_area VALUES (293,'140823','闻喜县','140800'); INSERT INTO hat_area VALUES (294,'140824','稷山县','140800'); INSERT INTO hat_area VALUES (295,'140825','新绛县','140800'); INSERT INTO hat_area VALUES (296,'140826','绛县','140800'); INSERT INTO hat_area VALUES (297,'140827','垣曲县','140800'); INSERT INTO hat_area VALUES (298,'140828','夏县','140800'); INSERT INTO hat_area VALUES (299,'140829','平陆县','140800'); INSERT INTO hat_area VALUES (300,'140830','芮城县','140800'); INSERT INTO hat_area VALUES (301,'140881','永济市','140800'); INSERT INTO hat_area VALUES (302,'140882','河津市','140800'); INSERT INTO hat_area VALUES (303,'140901','市辖区','140900'); INSERT INTO hat_area VALUES (304,'140902','忻府区','140900'); INSERT INTO hat_area VALUES (305,'140921','定襄县','140900'); INSERT INTO hat_area VALUES (306,'140922','五台县','140900'); INSERT INTO hat_area VALUES (307,'140923','代县','140900'); INSERT INTO hat_area VALUES (308,'140924','繁峙县','140900'); INSERT INTO hat_area VALUES (309,'140925','宁武县','140900'); INSERT INTO hat_area VALUES (310,'140926','静乐县','140900'); INSERT INTO hat_area VALUES (311,'140927','神池县','140900'); INSERT INTO hat_area VALUES (312,'140928','五寨县','140900'); INSERT INTO hat_area VALUES (313,'140929','岢岚县','140900'); INSERT INTO hat_area VALUES (314,'140930','河曲县','140900'); INSERT INTO hat_area VALUES (315,'140931','保德县','140900'); INSERT INTO hat_area VALUES (316,'140932','偏关县','140900'); INSERT INTO hat_area VALUES (317,'140981','原平市','140900'); INSERT INTO hat_area VALUES (318,'141001','市辖区','141000'); INSERT INTO hat_area VALUES (319,'141002','尧都区','141000'); INSERT INTO hat_area VALUES (320,'141021','曲沃县','141000'); INSERT INTO hat_area VALUES (321,'141022','翼城县','141000'); INSERT INTO hat_area VALUES (322,'141023','襄汾县','141000'); INSERT INTO hat_area VALUES (323,'141024','洪洞县','141000'); INSERT INTO hat_area VALUES (324,'141025','古县','141000');INSERT INTO hat_area VALUES (326,'141027','浮山县','141000'); INSERT INTO hat_area VALUES (327,'141028','吉县','141000'); INSERT INTO hat_area VALUES (328,'141029','乡宁县','141000'); INSERT INTO hat_area VALUES (329,'141030','大宁县','141000'); INSERT INTO hat_area VALUES (330,'141031','隰县','141000'); INSERT INTO hat_area VALUES (331,'141032','永和县','141000'); INSERT INTO hat_area VALUES (332,'141033','蒲县','141000'); INSERT INTO hat_area VALUES (333,'141034','汾西县','141000'); INSERT INTO hat_area VALUES (334,'141081','侯马市','141000'); INSERT INTO hat_area VALUES (335,'141082','霍州市','141000'); INSERT INTO hat_area VALUES (336,'141101','市辖区','141100'); INSERT INTO hat_area VALUES (337,'141102','离石区','141100'); INSERT INTO hat_area VALUES (338,'141121','文水县','141100'); INSERT INTO hat_area VALUES (339,'141122','交城县','141100'); INSERT INTO hat_area VALUES (340,'141123','兴县','141100'); INSERT INTO hat_area VALUES (341,'141124','临县','141100'); INSERT INTO hat_area VALUES (342,'141125','柳林县','141100'); INSERT INTO hat_area VALUES (343,'141126','石楼县','141100'); INSERT INTO hat_area VALUES (344,'141127','岚县','141100'); INSERT INTO hat_area VALUES (345,'141128','方山县','141100'); INSERT INTO hat_area VALUES (346,'141129','中阳县','141100'); INSERT INTO hat_area VALUES (347,'141130','交口县','141100'); INSERT INTO hat_area VALUES (348,'141181','孝义市','141100'); INSERT INTO hat_area VALUES (349,'141182','汾阳市','141100'); INSERT INTO hat_area VALUES (350,'150101','市辖区','150100'); INSERT INTO hat_area VALUES (351,'150102','新城区','150100'); INSERT INTO hat_area VALUES (352,'150103','回民区','150100'); INSERT INTO hat_area VALUES (353,'150104','玉泉区','150100'); INSERT INTO hat_area VALUES (354,'150105','赛罕区','150100'); INSERT INTO hat_area VALUES (355,'150121','土默特左旗','150100'); INSERT INTO hat_area VALUES (356,'150122','托克托县','150100'); INSERT INTO hat_area VALUES (357,'150123','和林格尔县','150100'); INSERT INTO hat_area VALUES (358,'150124','清水河县','150100'); INSERT INTO hat_area VALUES (359,'150125','武川县','150100'); INSERT INTO hat_area VALUES (360,'150201','市辖区','150200'); INSERT INTO hat_area VALUES (361,'150202','东河区','150200'); INSERT INTO hat_area VALUES (362,'150203','昆都仑区','150200'); INSERT INTO hat_area VALUES (363,'150204','青山区','150200'); INSERT INTO hat_area VALUES (364,'150205','石拐区','150200'); INSERT INTO hat_area VALUES (365,'150206','白云矿区','150200'); INSERT INTO hat_area VALUES (366,'150207','九原区','150200'); INSERT INTO hat_area VALUES (367,'150221','土默特右旗','150200'); INSERT INTO hat_area VALUES (368,'150222','固阳县','150200');。

quan中国省市区三级数据库表.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: iptohat_area# ------------------------------------------------------# Server version 5.0.26## Source for table hat_area#CREATE TABLE hat_area (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 hat_area#INSERT INTO hat_area VALUES (1,'110101','东城区','110100'); INSERT INTO hat_area VALUES (2,'110102','西城区','110100'); INSERT INTO hat_area VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_area VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_area VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_area VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_area VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_area VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_area VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_area VALUES (10,'110111','房山区','110100'); INSERT INTO hat_area VALUES (11,'110112','通州区','110100'); INSERT INTO hat_area VALUES (12,'110113','顺义区','110100'); INSERT INTO hat_area VALUES (13,'110114','昌平区','110100'); INSERT INTO hat_area VALUES (14,'110115','大兴区','110100'); INSERT INTO hat_area VALUES (15,'110116','怀柔区','110100'); INSERT INTO hat_area VALUES (16,'110117','平谷区','110100');INSERT INTO hat_area VALUES (18,'110229','延庆县','110200'); INSERT INTO hat_area VALUES (19,'120101','和平区','120100'); INSERT INTO hat_area VALUES (20,'120102','河东区','120100'); INSERT INTO hat_area VALUES (21,'120103','河西区','120100'); INSERT INTO hat_area VALUES (22,'120104','南开区','120100'); INSERT INTO hat_area VALUES (23,'120105','河北区','120100'); INSERT INTO hat_area VALUES (24,'120106','红桥区','120100'); INSERT INTO hat_area VALUES (25,'120107','塘沽区','120100'); INSERT INTO hat_area VALUES (26,'120108','汉沽区','120100'); INSERT INTO hat_area VALUES (27,'120109','大港区','120100'); INSERT INTO hat_area VALUES (28,'120110','东丽区','120100'); INSERT INTO hat_area VALUES (29,'120111','西青区','120100'); INSERT INTO hat_area VALUES (30,'120112','津南区','120100'); INSERT INTO hat_area VALUES (31,'120113','北辰区','120100'); INSERT INTO hat_area VALUES (32,'120114','武清区','120100'); INSERT INTO hat_area VALUES (33,'120115','宝坻区','120100'); INSERT INTO hat_area VALUES (34,'120221','宁河县','120200'); INSERT INTO hat_area VALUES (35,'120223','静海县','120200'); INSERT INTO hat_area VALUES (36,'120225','蓟县','120200'); INSERT INTO hat_area VALUES (37,'130101','市辖区','130100'); INSERT INTO hat_area VALUES (38,'130102','长安区','130100'); INSERT INTO hat_area VALUES (39,'130103','桥东区','130100'); INSERT INTO hat_area VALUES (40,'130104','桥西区','130100'); INSERT INTO hat_area VALUES (41,'130105','新华区','130100'); INSERT INTO hat_area VALUES (42,'130107','井陉矿区','130100'); INSERT INTO hat_area VALUES (43,'130108','裕华区','130100'); INSERT INTO hat_area VALUES (44,'130121','井陉县','130100'); INSERT INTO hat_area VALUES (45,'130123','正定县','130100'); INSERT INTO hat_area VALUES (46,'130124','栾城县','130100'); INSERT INTO hat_area VALUES (47,'130125','行唐县','130100'); INSERT INTO hat_area VALUES (48,'130126','灵寿县','130100'); INSERT INTO hat_area VALUES (49,'130127','高邑县','130100'); INSERT INTO hat_area VALUES (50,'130128','深泽县','130100'); INSERT INTO hat_area VALUES (51,'130129','赞皇县','130100'); INSERT INTO hat_area VALUES (52,'130130','无极县','130100'); INSERT INTO hat_area VALUES (53,'130131','平山县','130100'); INSERT INTO hat_area VALUES (54,'130132','元氏县','130100'); INSERT INTO hat_area VALUES (55,'130133','赵县','130100'); INSERT INTO hat_area VALUES (56,'130181','辛集市','130100'); INSERT INTO hat_area VALUES (57,'130182','藁城市','130100'); INSERT INTO hat_area VALUES (58,'130183','晋州市','130100'); INSERT INTO hat_area VALUES (59,'130184','新乐市','130100'); INSERT INTO hat_area VALUES (60,'130185','鹿泉市','130100');INSERT INTO hat_area VALUES (62,'130202','路南区','130200'); INSERT INTO hat_area VALUES (63,'130203','路北区','130200'); INSERT INTO hat_area VALUES (64,'130204','古冶区','130200'); INSERT INTO hat_area VALUES (65,'130205','开平区','130200'); INSERT INTO hat_area VALUES (66,'130207','丰南区','130200'); INSERT INTO hat_area VALUES (67,'130208','丰润区','130200'); INSERT INTO hat_area VALUES (68,'130223','滦县','130200'); INSERT INTO hat_area VALUES (69,'130224','滦南县','130200'); INSERT INTO hat_area VALUES (70,'130225','乐亭县','130200'); INSERT INTO hat_area VALUES (71,'130227','迁西县','130200'); INSERT INTO hat_area VALUES (72,'130229','玉田县','130200'); INSERT INTO hat_area VALUES (73,'130230','唐海县','130200'); INSERT INTO hat_area VALUES (74,'130281','遵化市','130200'); INSERT INTO hat_area VALUES (75,'130283','迁安市','130200'); INSERT INTO hat_area VALUES (76,'130301','市辖区','130300'); INSERT INTO hat_area VALUES (77,'130302','海港区','130300'); INSERT INTO hat_area VALUES (78,'130303','山海关区','130300'); INSERT INTO hat_area VALUES (79,'130304','北戴河区','130300'); INSERT INTO hat_area VALUES (80,'130321','青龙满族自治县','130300'); INSERT INTO hat_area VALUES (81,'130322','昌黎县','130300'); INSERT INTO hat_area VALUES (82,'130323','抚宁县','130300'); INSERT INTO hat_area VALUES (83,'130324','卢龙县','130300'); INSERT INTO hat_area VALUES (84,'130401','市辖区','130400'); INSERT INTO hat_area VALUES (85,'130402','邯山区','130400'); INSERT INTO hat_area VALUES (86,'130403','丛台区','130400'); INSERT INTO hat_area VALUES (87,'130404','复兴区','130400'); INSERT INTO hat_area VALUES (88,'130406','峰峰矿区','130400'); INSERT INTO hat_area VALUES (89,'130421','邯郸县','130400'); INSERT INTO hat_area VALUES (90,'130423','临漳县','130400'); INSERT INTO hat_area VALUES (91,'130424','成安县','130400'); INSERT INTO hat_area VALUES (92,'130425','大名县','130400'); INSERT INTO hat_area VALUES (93,'130426','涉县','130400'); INSERT INTO hat_area VALUES (94,'130427','磁县','130400'); INSERT INTO hat_area VALUES (95,'130428','肥乡县','130400'); INSERT INTO hat_area VALUES (96,'130429','永年县','130400'); INSERT INTO hat_area VALUES (97,'130430','邱县','130400'); INSERT INTO hat_area VALUES (98,'130431','鸡泽县','130400'); INSERT INTO hat_area VALUES (99,'130432','广平县','130400'); INSERT INTO hat_area VALUES (100,'130433','馆陶县','130400'); INSERT INTO hat_area VALUES (101,'130434','魏县','130400'); INSERT INTO hat_area VALUES (102,'130435','曲周县','130400'); INSERT INTO hat_area VALUES (103,'130481','武安市','130400'); INSERT INTO hat_area VALUES (104,'130501','市辖区','130500');INSERT INTO hat_area VALUES (106,'130503','桥西区','130500'); INSERT INTO hat_area VALUES (107,'130521','邢台县','130500'); INSERT INTO hat_area VALUES (108,'130522','临城县','130500'); INSERT INTO hat_area VALUES (109,'130523','内丘县','130500'); INSERT INTO hat_area VALUES (110,'130524','柏乡县','130500'); INSERT INTO hat_area VALUES (111,'130525','隆尧县','130500'); INSERT INTO hat_area VALUES (112,'130526','任县','130500'); INSERT INTO hat_area VALUES (113,'130527','南和县','130500'); INSERT INTO hat_area VALUES (114,'130528','宁晋县','130500'); INSERT INTO hat_area VALUES (115,'130529','巨鹿县','130500'); INSERT INTO hat_area VALUES (116,'130530','新河县','130500'); INSERT INTO hat_area VALUES (117,'130531','广宗县','130500'); INSERT INTO hat_area VALUES (118,'130532','平乡县','130500'); INSERT INTO hat_area VALUES (119,'130533','威县','130500'); INSERT INTO hat_area VALUES (120,'130534','清河县','130500'); INSERT INTO hat_area VALUES (121,'130535','临西县','130500'); INSERT INTO hat_area VALUES (122,'130581','南宫市','130500'); INSERT INTO hat_area VALUES (123,'130582','沙河市','130500'); INSERT INTO hat_area VALUES (124,'130601','市辖区','130600'); INSERT INTO hat_area VALUES (125,'130602','新市区','130600'); INSERT INTO hat_area VALUES (126,'130603','北市区','130600'); INSERT INTO hat_area VALUES (127,'130604','南市区','130600'); INSERT INTO hat_area VALUES (128,'130621','满城县','130600'); INSERT INTO hat_area VALUES (129,'130622','清苑县','130600'); INSERT INTO hat_area VALUES (130,'130623','涞水县','130600'); INSERT INTO hat_area VALUES (131,'130624','阜平县','130600'); INSERT INTO hat_area VALUES (132,'130625','徐水县','130600'); INSERT INTO hat_area VALUES (133,'130626','定兴县','130600'); INSERT INTO hat_area VALUES (134,'130627','唐县','130600'); INSERT INTO hat_area VALUES (135,'130628','高阳县','130600'); INSERT INTO hat_area VALUES (136,'130629','容城县','130600'); INSERT INTO hat_area VALUES (137,'130630','涞源县','130600'); INSERT INTO hat_area VALUES (138,'130631','望都县','130600'); INSERT INTO hat_area VALUES (139,'130632','安新县','130600'); INSERT INTO hat_area VALUES (140,'130633','易县','130600'); INSERT INTO hat_area VALUES (141,'130634','曲阳县','130600'); INSERT INTO hat_area VALUES (142,'130635','蠡县','130600'); INSERT INTO hat_area VALUES (143,'130636','顺平县','130600'); INSERT INTO hat_area VALUES (144,'130637','博野县','130600'); INSERT INTO hat_area VALUES (145,'130638','雄县','130600'); INSERT INTO hat_area VALUES (146,'130681','涿州市','130600'); INSERT INTO hat_area VALUES (147,'130682','定州市','130600'); INSERT INTO hat_area VALUES (148,'130683','安国市','130600');INSERT INTO hat_area VALUES (150,'130701','市辖区','130700');INSERT INTO hat_area VALUES (151,'130702','桥东区','130700');INSERT INTO hat_area VALUES (152,'130703','桥西区','130700');INSERT INTO hat_area VALUES (153,'130705','宣化区','130700');INSERT INTO hat_area VALUES (154,'130706','下花园区','130700');INSERT INTO hat_area VALUES (155,'130721','宣化县','130700');INSERT INTO hat_area VALUES (156,'130722','张北县','130700');INSERT INTO hat_area VALUES (157,'130723','康保县','130700');INSERT INTO hat_area VALUES (158,'130724','沽源县','130700');INSERT INTO hat_area VALUES (159,'130725','尚义县','130700');INSERT INTO hat_area VALUES (160,'130726','蔚县','130700');INSERT INTO hat_area VALUES (161,'130727','阳原县','130700');INSERT INTO hat_area VALUES (162,'130728','怀安县','130700');INSERT INTO hat_area VALUES (163,'130729','万全县','130700');INSERT INTO hat_area VALUES (164,'130730','怀来县','130700');INSERT INTO hat_area VALUES (165,'130731','涿鹿县','130700');INSERT INTO hat_area VALUES (166,'130732','赤城县','130700');INSERT INTO hat_area VALUES (167,'130733','崇礼县','130700');INSERT INTO hat_area VALUES (168,'130801','市辖区','130800');INSERT INTO hat_area VALUES (169,'130802','双桥区','130800');INSERT INTO hat_area VALUES (170,'130803','双滦区','130800');INSERT INTO hat_area VALUES (171,'130804','鹰手营子矿区','130800'); INSERT INTO hat_area VALUES (172,'130821','承德县','130800');INSERT INTO hat_area VALUES (173,'130822','兴隆县','130800');INSERT INTO hat_area VALUES (174,'130823','平泉县','130800');INSERT INTO hat_area VALUES (175,'130824','滦平县','130800');INSERT INTO hat_area VALUES (176,'130825','隆化县','130800');INSERT INTO hat_area VALUES (177,'130826','丰宁满族自治县','130800'); INSERT INTO hat_area VALUES (178,'130827','宽城满族自治县','130800'); INSERT INTO hat_area VALUES (179,'130828','围场满族蒙古族自治县','130800'); INSERT INTO hat_area VALUES (180,'130901','市辖区','130900');INSERT INTO hat_area VALUES (181,'130902','新华区','130900');INSERT INTO hat_area VALUES (182,'130903','运河区','130900');INSERT INTO hat_area VALUES (183,'130921','沧县','130900');INSERT INTO hat_area VALUES (184,'130922','青县','130900');INSERT INTO hat_area VALUES (185,'130923','东光县','130900');INSERT INTO hat_area VALUES (186,'130924','海兴县','130900');INSERT INTO hat_area VALUES (187,'130925','盐山县','130900');INSERT INTO hat_area VALUES (188,'130926','肃宁县','130900');INSERT INTO hat_area VALUES (189,'130927','南皮县','130900');INSERT INTO hat_area VALUES (190,'130928','吴桥县','130900');INSERT INTO hat_area VALUES (191,'130929','献县','130900');INSERT INTO hat_area VALUES (192,'130930','孟村回族自治县','130900');INSERT INTO hat_area VALUES (194,'130982','任丘市','130900'); INSERT INTO hat_area VALUES (195,'130983','黄骅市','130900'); INSERT INTO hat_area VALUES (196,'130984','河间市','130900'); INSERT INTO hat_area VALUES (197,'131001','市辖区','131000'); INSERT INTO hat_area VALUES (198,'131002','安次区','131000'); INSERT INTO hat_area VALUES (199,'131003','广阳区','131000'); INSERT INTO hat_area VALUES (200,'131022','固安县','131000'); INSERT INTO hat_area VALUES (201,'131023','永清县','131000'); INSERT INTO hat_area VALUES (202,'131024','香河县','131000'); INSERT INTO hat_area VALUES (203,'131025','大城县','131000'); INSERT INTO hat_area VALUES (204,'131026','文安县','131000'); INSERT INTO hat_area VALUES (205,'131028','大厂回族自治县','131000'); INSERT INTO hat_area VALUES (206,'131081','霸州市','131000'); INSERT INTO hat_area VALUES (207,'131082','三河市','131000'); INSERT INTO hat_area VALUES (208,'131101','市辖区','131100'); INSERT INTO hat_area VALUES (209,'131102','桃城区','131100'); INSERT INTO hat_area VALUES (210,'131121','枣强县','131100'); INSERT INTO hat_area VALUES (211,'131122','武邑县','131100'); INSERT INTO hat_area VALUES (212,'131123','武强县','131100'); INSERT INTO hat_area VALUES (213,'131124','饶阳县','131100'); INSERT INTO hat_area VALUES (214,'131125','安平县','131100'); INSERT INTO hat_area VALUES (215,'131126','故城县','131100'); INSERT INTO hat_area VALUES (216,'131127','景县','131100'); INSERT INTO hat_area VALUES (217,'131128','阜城县','131100'); INSERT INTO hat_area VALUES (218,'131181','冀州市','131100'); INSERT INTO hat_area VALUES (219,'131182','深州市','131100'); INSERT INTO hat_area VALUES (220,'140101','市辖区','140100'); INSERT INTO hat_area VALUES (221,'140105','小店区','140100'); INSERT INTO hat_area VALUES (222,'140106','迎泽区','140100'); INSERT INTO hat_area VALUES (223,'140107','杏花岭区','140100'); INSERT INTO hat_area VALUES (224,'140108','尖草坪区','140100'); INSERT INTO hat_area VALUES (225,'140109','万柏林区','140100'); INSERT INTO hat_area VALUES (226,'140110','晋源区','140100'); INSERT INTO hat_area VALUES (227,'140121','清徐县','140100'); INSERT INTO hat_area VALUES (228,'140122','阳曲县','140100'); INSERT INTO hat_area VALUES (229,'140123','娄烦县','140100'); INSERT INTO hat_area VALUES (230,'140181','古交市','140100'); INSERT INTO hat_area VALUES (231,'140201','市辖区','140200'); INSERT INTO hat_area VALUES (232,'140202','城区','140200'); INSERT INTO hat_area VALUES (233,'140203','矿区','140200'); INSERT INTO hat_area VALUES (234,'140211','南郊区','140200'); INSERT INTO hat_area VALUES (235,'140212','新荣区','140200'); INSERT INTO hat_area VALUES (236,'140221','阳高县','140200');INSERT INTO hat_area VALUES (238,'140223','广灵县','140200'); INSERT INTO hat_area VALUES (239,'140224','灵丘县','140200'); INSERT INTO hat_area VALUES (240,'140225','浑源县','140200'); INSERT INTO hat_area VALUES (241,'140226','左云县','140200'); INSERT INTO hat_area VALUES (242,'140227','大同县','140200'); INSERT INTO hat_area VALUES (243,'140301','市辖区','140300'); INSERT INTO hat_area VALUES (244,'140302','城区','140300'); INSERT INTO hat_area VALUES (245,'140303','矿区','140300'); INSERT INTO hat_area VALUES (246,'140311','郊区','140300'); INSERT INTO hat_area VALUES (247,'140321','平定县','140300'); INSERT INTO hat_area VALUES (248,'140322','盂县','140300'); INSERT INTO hat_area VALUES (249,'140401','市辖区','140400'); INSERT INTO hat_area VALUES (250,'140402','城区','140400'); INSERT INTO hat_area VALUES (251,'140411','郊区','140400'); INSERT INTO hat_area VALUES (252,'140421','长治县','140400'); INSERT INTO hat_area VALUES (253,'140423','襄垣县','140400'); INSERT INTO hat_area VALUES (254,'140424','屯留县','140400'); INSERT INTO hat_area VALUES (255,'140425','平顺县','140400'); INSERT INTO hat_area VALUES (256,'140426','黎城县','140400'); INSERT INTO hat_area VALUES (257,'140427','壶关县','140400'); INSERT INTO hat_area VALUES (258,'140428','长子县','140400'); INSERT INTO hat_area VALUES (259,'140429','武乡县','140400'); INSERT INTO hat_area VALUES (260,'140430','沁县','140400'); INSERT INTO hat_area VALUES (261,'140431','沁源县','140400'); INSERT INTO hat_area VALUES (262,'140481','潞城市','140400'); INSERT INTO hat_area VALUES (263,'140501','市辖区','140500'); INSERT INTO hat_area VALUES (264,'140502','城区','140500'); INSERT INTO hat_area VALUES (265,'140521','沁水县','140500'); INSERT INTO hat_area VALUES (266,'140522','阳城县','140500'); INSERT INTO hat_area VALUES (267,'140524','陵川县','140500'); INSERT INTO hat_area VALUES (268,'140525','泽州县','140500'); INSERT INTO hat_area VALUES (269,'140581','高平市','140500'); INSERT INTO hat_area VALUES (270,'140601','市辖区','140600'); INSERT INTO hat_area VALUES (271,'140602','朔城区','140600'); INSERT INTO hat_area VALUES (272,'140603','平鲁区','140600'); INSERT INTO hat_area VALUES (273,'140621','山阴县','140600'); INSERT INTO hat_area VALUES (274,'140622','应县','140600'); INSERT INTO hat_area VALUES (275,'140623','右玉县','140600'); INSERT INTO hat_area VALUES (276,'140624','怀仁县','140600'); INSERT INTO hat_area VALUES (277,'140701','市辖区','140700'); INSERT INTO hat_area VALUES (278,'140702','榆次区','140700'); INSERT INTO hat_area VALUES (279,'140721','榆社县','140700'); INSERT INTO hat_area VALUES (280,'140722','左权县','140700');INSERT INTO hat_area VALUES (282,'140724','昔阳县','140700'); INSERT INTO hat_area VALUES (283,'140725','寿阳县','140700'); INSERT INTO hat_area VALUES (284,'140726','太谷县','140700'); INSERT INTO hat_area VALUES (285,'140727','祁县','140700'); INSERT INTO hat_area VALUES (286,'140728','平遥县','140700'); INSERT INTO hat_area VALUES (287,'140729','灵石县','140700'); INSERT INTO hat_area VALUES (288,'140781','介休市','140700'); INSERT INTO hat_area VALUES (289,'140801','市辖区','140800'); INSERT INTO hat_area VALUES (290,'140802','盐湖区','140800'); INSERT INTO hat_area VALUES (291,'140821','临猗县','140800'); INSERT INTO hat_area VALUES (292,'140822','万荣县','140800'); INSERT INTO hat_area VALUES (293,'140823','闻喜县','140800'); INSERT INTO hat_area VALUES (294,'140824','稷山县','140800'); INSERT INTO hat_area VALUES (295,'140825','新绛县','140800'); INSERT INTO hat_area VALUES (296,'140826','绛县','140800'); INSERT INTO hat_area VALUES (297,'140827','垣曲县','140800'); INSERT INTO hat_area VALUES (298,'140828','夏县','140800'); INSERT INTO hat_area VALUES (299,'140829','平陆县','140800'); INSERT INTO hat_area VALUES (300,'140830','芮城县','140800'); INSERT INTO hat_area VALUES (301,'140881','永济市','140800'); INSERT INTO hat_area VALUES (302,'140882','河津市','140800'); INSERT INTO hat_area VALUES (303,'140901','市辖区','140900'); INSERT INTO hat_area VALUES (304,'140902','忻府区','140900'); INSERT INTO hat_area VALUES (305,'140921','定襄县','140900'); INSERT INTO hat_area VALUES (306,'140922','五台县','140900'); INSERT INTO hat_area VALUES (307,'140923','代县','140900'); INSERT INTO hat_area VALUES (308,'140924','繁峙县','140900'); INSERT INTO hat_area VALUES (309,'140925','宁武县','140900'); INSERT INTO hat_area VALUES (310,'140926','静乐县','140900'); INSERT INTO hat_area VALUES (311,'140927','神池县','140900'); INSERT INTO hat_area VALUES (312,'140928','五寨县','140900'); INSERT INTO hat_area VALUES (313,'140929','岢岚县','140900'); INSERT INTO hat_area VALUES (314,'140930','河曲县','140900'); INSERT INTO hat_area VALUES (315,'140931','保德县','140900'); INSERT INTO hat_area VALUES (316,'140932','偏关县','140900'); INSERT INTO hat_area VALUES (317,'140981','原平市','140900'); INSERT INTO hat_area VALUES (318,'141001','市辖区','141000'); INSERT INTO hat_area VALUES (319,'141002','尧都区','141000'); INSERT INTO hat_area VALUES (320,'141021','曲沃县','141000'); INSERT INTO hat_area VALUES (321,'141022','翼城县','141000'); INSERT INTO hat_area VALUES (322,'141023','襄汾县','141000'); INSERT INTO hat_area VALUES (323,'141024','洪洞县','141000'); INSERT INTO hat_area VALUES (324,'141025','古县','141000');INSERT INTO hat_area VALUES (326,'141027','浮山县','141000'); INSERT INTO hat_area VALUES (327,'141028','吉县','141000'); INSERT INTO hat_area VALUES (328,'141029','乡宁县','141000'); INSERT INTO hat_area VALUES (329,'141030','大宁县','141000'); INSERT INTO hat_area VALUES (330,'141031','隰县','141000'); INSERT INTO hat_area VALUES (331,'141032','永和县','141000'); INSERT INTO hat_area VALUES (332,'141033','蒲县','141000'); INSERT INTO hat_area VALUES (333,'141034','汾西县','141000'); INSERT INTO hat_area VALUES (334,'141081','侯马市','141000'); INSERT INTO hat_area VALUES (335,'141082','霍州市','141000'); INSERT INTO hat_area VALUES (336,'141101','市辖区','141100'); INSERT INTO hat_area VALUES (337,'141102','离石区','141100'); INSERT INTO hat_area VALUES (338,'141121','文水县','141100'); INSERT INTO hat_area VALUES (339,'141122','交城县','141100'); INSERT INTO hat_area VALUES (340,'141123','兴县','141100'); INSERT INTO hat_area VALUES (341,'141124','临县','141100'); INSERT INTO hat_area VALUES (342,'141125','柳林县','141100'); INSERT INTO hat_area VALUES (343,'141126','石楼县','141100'); INSERT INTO hat_area VALUES (344,'141127','岚县','141100'); INSERT INTO hat_area VALUES (345,'141128','方山县','141100'); INSERT INTO hat_area VALUES (346,'141129','中阳县','141100'); INSERT INTO hat_area VALUES (347,'141130','交口县','141100'); INSERT INTO hat_area VALUES (348,'141181','孝义市','141100'); INSERT INTO hat_area VALUES (349,'141182','汾阳市','141100'); INSERT INTO hat_area VALUES (350,'150101','市辖区','150100'); INSERT INTO hat_area VALUES (351,'150102','新城区','150100'); INSERT INTO hat_area VALUES (352,'150103','回民区','150100'); INSERT INTO hat_area VALUES (353,'150104','玉泉区','150100'); INSERT INTO hat_area VALUES (354,'150105','赛罕区','150100'); INSERT INTO hat_area VALUES (355,'150121','土默特左旗','150100'); INSERT INTO hat_area VALUES (356,'150122','托克托县','150100'); INSERT INTO hat_area VALUES (357,'150123','和林格尔县','150100'); INSERT INTO hat_area VALUES (358,'150124','清水河县','150100'); INSERT INTO hat_area VALUES (359,'150125','武川县','150100'); INSERT INTO hat_area VALUES (360,'150201','市辖区','150200'); INSERT INTO hat_area VALUES (361,'150202','东河区','150200'); INSERT INTO hat_area VALUES (362,'150203','昆都仑区','150200'); INSERT INTO hat_area VALUES (363,'150204','青山区','150200'); INSERT INTO hat_area VALUES (364,'150205','石拐区','150200'); INSERT INTO hat_area VALUES (365,'150206','白云矿区','150200'); INSERT INTO hat_area VALUES (366,'150207','九原区','150200'); INSERT INTO hat_area VALUES (367,'150221','土默特右旗','150200'); INSERT INTO hat_area VALUES (368,'150222','固阳县','150200');。

全国省市县SQL数据库(大全)

全国省市区数据SQL-省市区

全国省份城市表（sql版）

MySQL中国省市区SQL表数据

全国-省-地级市-县级市 数据库

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

sql_数据库__省市区_数据建表和数据

全国省市县SQL数据库(大全)

(word完整版)中国省市区(地区MySql数据表)

省市县级联查询sql详解

中国三级省市区sql

全国省市县SQL数据库(大全)

全国省市数据库(修正后)

中国省市区----SQL表

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

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

全国-省-地级市-县级市数据库