provincecityarea.sql

三层无刷新级联选择省市区县 C#语言开发SQL 数据库(含全国完整数据库)Ajax无刷新三级联动

INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 97,'330800','衢州市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 98,'330900','舟山市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 99,'331000','台州市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 100,'331100','丽水市','330000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 101,'340100','合肥市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 102,'340200','芜湖市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 103,'340300','蚌埠市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 104,'340400','淮南市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 105,'340500','马鞍山市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 106,'340600','淮北市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 107,'340700','铜陵市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 108,'340800','安庆市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 109,'341000','黄山市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 110,'341100','滁州市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 111,'341200','阜阳市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 112,'341300','宿州市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 113,'341400','巢湖市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 114,'341500','六安市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 115,'341600','亳州市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 116,'341700','池州市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 117,'341800','宣城市','340000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 118,'350100','福州市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 119,'350200','厦门市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 120,'350300','莆田市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 121,'350400','三明市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 122,'350500','泉州市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 123,'350600','漳州市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 124,'350700','南平市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 125,'350800','龙岩市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 126,'350900','宁德市','350000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 127,'360100','南昌市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 128,'360200','景德镇市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 129,'360300','萍乡市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 130,'360400','九江市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 131,'360500','新余市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 132,'360600','鹰潭市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 133,'360700','赣州市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 134,'360800','吉安市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 135,'360900','宜春市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 136,'361000','抚州市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 137,'361100','上饶市','360000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 138,'370100','济南市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 139,'370200','青岛市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 140,'370300','淄博市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 141,'370400','枣庄市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 142,'370500','东营市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 143,'370600','烟台市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 144,'370700','潍坊市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 145,'370800','济宁市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 146,'370900','泰安市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 147,'371000','威海市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 148,'371100','日照市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 149,'371200','莱芜市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 150,'371300','临沂市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 151,'371400','德州市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 152,'371500','聊城市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 153,'371600','滨州市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 154,'371700','荷泽市','370000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 155,'410100','郑州市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 156,'410200','开封市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 157,'410300','洛阳市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 158,'410400','平顶山市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 159,'410500','安阳市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 160,'410600','鹤壁市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 161,'410700','新乡市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 162,'410800','焦作市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 163,'410900','濮阳市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 164,'411000','许昌市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 165,'411100','漯河市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 166,'411200','三门峡市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 167,'411300','南阳市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 168,'411400','商丘市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 169,'411500','信阳市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 170,'411600','周口市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 171,'411700','驻马店市','410000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 172,'420100','武汉市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 173,'420200','黄石市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 174,'420300','十堰市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 175,'420500','宜昌市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 176,'420600','襄樊市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 177,'420700','鄂州市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 178,'420800','荆门市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 179,'420900','孝感市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 180,'421000','荆州市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 181,'421100','黄冈市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 182,'421200','咸宁市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 183,'421300','随州市','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 184,'422800','恩施土家族苗族自治州','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 185,'429000','省直辖行政单位','420000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 186,'430100','长沙市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 187,'430200','株洲市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 188,'430300','湘潭市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 189,'430400','衡阳市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 190,'430500','邵阳市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 191,'430600','岳阳市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 192,'430700','常德市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 193,'430800','张家界市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 194,'430900','益阳市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 195,'431000','郴州市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 196,'431100','永州市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 197,'431200','怀化市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 198,'431300','娄底市','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 199,'433100','湘西土家族苗族自治州','430000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 200,'440100','广州市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 201,'440200','韶关市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 202,'440300','深圳市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 203,'440400','珠海市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 204,'440500','汕头市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 205,'440600','佛山市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 206,'440700','江门市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 207,'440800','湛江市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 208,'440900','茂名市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 209,'441200','肇庆市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 210,'441300','惠州市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 211,'441400','梅州市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 212,'441500','汕尾市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 213,'441600','河源市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 214,'441700','阳江市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 215,'441800','清远市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 216,'441900','东莞市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 217,'442000','中山市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 218,'445100','潮州市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 219,'445200','揭阳市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 220,'445300','云浮市','440000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 221,'450100','南宁市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 222,'450200','柳州市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 223,'450300','桂林市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 224,'450400','梧州市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 225,'450500','北海市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 226,'450600','防城港市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 227,'450700','钦州市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 228,'450800','贵港市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 229,'450900','玉林市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 230,'451000','百色市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 231,'451100','贺州市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 232,'451200','河池市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 233,'451300','来宾市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 234,'451400','崇左市','450000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 235,'460100','海口市','460000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 236,'460200','三亚市','460000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 237,'469000','省直辖县级行政单位','460000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 238,'500100','市辖区','500000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 239,'500200','县','500000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 240,'500300','市','500000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 241,'510100','成都市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 242,'510300','自贡市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 243,'510400','攀枝花市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 244,'510500','泸州市','510000')
INSERT [city] ([id],[code],[name],[provinceId]) VALUES ( 245,'510600','德阳市','510000')