好文档 - 专业文书写作范文服务资料分享网站

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

天下 分享 时间: 加入收藏 我要投稿 点赞

INSERT INTO hat_area VALUES (853,'320582','张家港市','320500'); INSERT INTO hat_area VALUES (854,'320583','昆山市','320500'); INSERT INTO hat_area VALUES (855,'320584','吴江市','320500'); INSERT INTO hat_area VALUES (856,'320585','太仓市','320500'); INSERT INTO hat_area VALUES (857,'320601','市辖区','320600'); INSERT INTO hat_area VALUES (858,'320602','崇川区','320600'); INSERT INTO hat_area VALUES (859,'320611','港闸区','320600'); INSERT INTO hat_area VALUES (860,'320621','海安县','320600'); INSERT INTO hat_area VALUES (861,'320623','如东县','320600'); INSERT INTO hat_area VALUES (862,'320681','启东市','320600'); INSERT INTO hat_area VALUES (863,'320682','如皋市','320600'); INSERT INTO hat_area VALUES (864,'320683','通州市','320600'); INSERT INTO hat_area VALUES (865,'320684','海门市','320600'); INSERT INTO hat_area VALUES (866,'320701','市辖区','320700'); INSERT INTO hat_area VALUES (867,'320703','连云区','320700'); INSERT INTO hat_area VALUES (868,'320705','新浦区','320700'); INSERT INTO hat_area VALUES (869,'320706','海州区','320700'); INSERT INTO hat_area VALUES (870,'320721','赣榆县','320700'); INSERT INTO hat_area VALUES (871,'320722','东海县','320700'); INSERT INTO hat_area VALUES (872,'320723','灌云县','320700'); INSERT INTO hat_area VALUES (873,'320724','灌南县','320700'); INSERT INTO hat_area VALUES (874,'320801','市辖区','320800'); INSERT INTO hat_area VALUES (875,'320802','清河区','320800'); INSERT INTO hat_area VALUES (876,'320803','楚州区','320800'); INSERT INTO hat_area VALUES (877,'320804','淮阴区','320800'); INSERT INTO hat_area VALUES (878,'320811','清浦区','320800'); INSERT INTO hat_area VALUES (879,'320826','涟水县','320800'); INSERT INTO hat_area VALUES (880,'320829','洪泽县','320800'); INSERT INTO hat_area VALUES (881,'320830','盱眙县','320800'); INSERT INTO hat_area VALUES (882,'320831','金湖县','320800'); INSERT INTO hat_area VALUES (883,'320901','市辖区','320900'); INSERT INTO hat_area VALUES (884,'320902','亭湖区','320900'); INSERT INTO hat_area VALUES (885,'320903','盐都区','320900'); INSERT INTO hat_area VALUES (886,'320921','响水县','320900'); INSERT INTO hat_area VALUES (887,'320922','滨海县','320900'); INSERT INTO hat_area VALUES (888,'320923','阜宁县','320900'); INSERT INTO hat_area VALUES (889,'320924','射阳县','320900'); INSERT INTO hat_area VALUES (890,'320925','建湖县','320900'); INSERT INTO hat_area VALUES (891,'320981','东台市','320900'); INSERT INTO hat_area VALUES (892,'320982','大丰市','320900'); INSERT INTO hat_area VALUES (893,'321001','市辖区','321000'); INSERT INTO hat_area VALUES (894,'321002','广陵区','321000'); INSERT INTO hat_area VALUES (895,'321003','邗江区','321000'); INSERT INTO hat_area VALUES (896,'321011','郊 区','321000');

INSERT INTO hat_area VALUES (897,'321023','宝应县','321000'); INSERT INTO hat_area VALUES (898,'321081','仪征市','321000'); INSERT INTO hat_area VALUES (899,'321084','高邮市','321000'); INSERT INTO hat_area VALUES (900,'321088','江都市','321000'); INSERT INTO hat_area VALUES (901,'321101','市辖区','321100'); INSERT INTO hat_area VALUES (902,'321102','京口区','321100'); INSERT INTO hat_area VALUES (903,'321111','润州区','321100'); INSERT INTO hat_area VALUES (904,'321112','丹徒区','321100'); INSERT INTO hat_area VALUES (905,'321181','丹阳市','321100'); INSERT INTO hat_area VALUES (906,'321182','扬中市','321100'); INSERT INTO hat_area VALUES (907,'321183','句容市','321100'); INSERT INTO hat_area VALUES (908,'321201','市辖区','321200'); INSERT INTO hat_area VALUES (909,'321202','海陵区','321200'); INSERT INTO hat_area VALUES (910,'321203','高港区','321200'); INSERT INTO hat_area VALUES (911,'321281','兴化市','321200'); INSERT INTO hat_area VALUES (912,'321282','靖江市','321200'); INSERT INTO hat_area VALUES (913,'321283','泰兴市','321200'); INSERT INTO hat_area VALUES (914,'321284','姜堰市','321200'); INSERT INTO hat_area VALUES (915,'321301','市辖区','321300'); INSERT INTO hat_area VALUES (916,'321302','宿城区','321300'); INSERT INTO hat_area VALUES (917,'321311','宿豫区','321300'); INSERT INTO hat_area VALUES (918,'321322','沭阳县','321300'); INSERT INTO hat_area VALUES (919,'321323','泗阳县','321300'); INSERT INTO hat_area VALUES (920,'321324','泗洪县','321300'); INSERT INTO hat_area VALUES (921,'330101','市辖区','330100'); INSERT INTO hat_area VALUES (922,'330102','上城区','330100'); INSERT INTO hat_area VALUES (923,'330103','下城区','330100'); INSERT INTO hat_area VALUES (924,'330104','江干区','330100'); INSERT INTO hat_area VALUES (925,'330105','拱墅区','330100'); INSERT INTO hat_area VALUES (926,'330106','西湖区','330100'); INSERT INTO hat_area VALUES (927,'330108','滨江区','330100'); INSERT INTO hat_area VALUES (928,'330109','萧山区','330100'); INSERT INTO hat_area VALUES (929,'330110','余杭区','330100'); INSERT INTO hat_area VALUES (930,'330122','桐庐县','330100'); INSERT INTO hat_area VALUES (931,'330127','淳安县','330100'); INSERT INTO hat_area VALUES (932,'330182','建德市','330100'); INSERT INTO hat_area VALUES (933,'330183','富阳市','330100'); INSERT INTO hat_area VALUES (934,'330185','临安市','330100'); INSERT INTO hat_area VALUES (935,'330201','市辖区','330200'); INSERT INTO hat_area VALUES (936,'330203','海曙区','330200'); INSERT INTO hat_area VALUES (937,'330204','江东区','330200'); INSERT INTO hat_area VALUES (938,'330205','江北区','330200'); INSERT INTO hat_area VALUES (939,'330206','北仑区','330200'); INSERT INTO hat_area VALUES (940,'330211','镇海区','330200');

INSERT INTO hat_area VALUES (941,'330212','鄞州区','330200'); INSERT INTO hat_area VALUES (942,'330225','象山县','330200'); INSERT INTO hat_area VALUES (943,'330226','宁海县','330200'); INSERT INTO hat_area VALUES (944,'330281','余姚市','330200'); INSERT INTO hat_area VALUES (945,'330282','慈溪市','330200'); INSERT INTO hat_area VALUES (946,'330283','奉化市','330200'); INSERT INTO hat_area VALUES (947,'330301','市辖区','330300'); INSERT INTO hat_area VALUES (948,'330302','鹿城区','330300'); INSERT INTO hat_area VALUES (949,'330303','龙湾区','330300'); INSERT INTO hat_area VALUES (950,'330304','瓯海区','330300'); INSERT INTO hat_area VALUES (951,'330322','洞头县','330300'); INSERT INTO hat_area VALUES (952,'330324','永嘉县','330300'); INSERT INTO hat_area VALUES (953,'330326','平阳县','330300'); INSERT INTO hat_area VALUES (954,'330327','苍南县','330300'); INSERT INTO hat_area VALUES (955,'330328','文成县','330300'); INSERT INTO hat_area VALUES (956,'330329','泰顺县','330300'); INSERT INTO hat_area VALUES (957,'330381','瑞安市','330300'); INSERT INTO hat_area VALUES (958,'330382','乐清市','330300'); INSERT INTO hat_area VALUES (959,'330401','市辖区','330400'); INSERT INTO hat_area VALUES (960,'330402','秀城区','330400'); INSERT INTO hat_area VALUES (961,'330411','秀洲区','330400'); INSERT INTO hat_area VALUES (962,'330421','嘉善县','330400'); INSERT INTO hat_area VALUES (963,'330424','海盐县','330400'); INSERT INTO hat_area VALUES (964,'330481','海宁市','330400'); INSERT INTO hat_area VALUES (965,'330482','平湖市','330400'); INSERT INTO hat_area VALUES (966,'330483','桐乡市','330400'); INSERT INTO hat_area VALUES (967,'330501','市辖区','330500'); INSERT INTO hat_area VALUES (968,'330502','吴兴区','330500'); INSERT INTO hat_area VALUES (969,'330503','南浔区','330500'); INSERT INTO hat_area VALUES (970,'330521','德清县','330500'); INSERT INTO hat_area VALUES (971,'330522','长兴县','330500'); INSERT INTO hat_area VALUES (972,'330523','安吉县','330500'); INSERT INTO hat_area VALUES (973,'330601','市辖区','330600'); INSERT INTO hat_area VALUES (974,'330602','越城区','330600'); INSERT INTO hat_area VALUES (975,'330621','绍兴县','330600'); INSERT INTO hat_area VALUES (976,'330624','新昌县','330600'); INSERT INTO hat_area VALUES (977,'330681','诸暨市','330600'); INSERT INTO hat_area VALUES (978,'330682','上虞市','330600'); INSERT INTO hat_area VALUES (979,'330683','嵊州市','330600'); INSERT INTO hat_area VALUES (980,'330701','市辖区','330700'); INSERT INTO hat_area VALUES (981,'330702','婺城区','330700'); INSERT INTO hat_area VALUES (982,'330703','金东区','330700'); INSERT INTO hat_area VALUES (983,'330723','武义县','330700'); INSERT INTO hat_area VALUES (984,'330726','浦江县','330700');

INSERT INTO hat_area VALUES (985,'330727','磐安县','330700'); INSERT INTO hat_area VALUES (986,'330781','兰溪市','330700'); INSERT INTO hat_area VALUES (987,'330782','义乌市','330700'); INSERT INTO hat_area VALUES (988,'330783','东阳市','330700'); INSERT INTO hat_area VALUES (989,'330784','永康市','330700'); INSERT INTO hat_area VALUES (990,'330801','市辖区','330800'); INSERT INTO hat_area VALUES (991,'330802','柯城区','330800'); INSERT INTO hat_area VALUES (992,'330803','衢江区','330800'); INSERT INTO hat_area VALUES (993,'330822','常山县','330800'); INSERT INTO hat_area VALUES (994,'330824','开化县','330800'); INSERT INTO hat_area VALUES (995,'330825','龙游县','330800'); INSERT INTO hat_area VALUES (996,'330881','江山市','330800'); INSERT INTO hat_area VALUES (997,'330901','市辖区','330900'); INSERT INTO hat_area VALUES (998,'330902','定海区','330900'); INSERT INTO hat_area VALUES (999,'330903','普陀区','330900'); INSERT INTO hat_area VALUES (1000,'330921','岱山县','330900'); INSERT INTO hat_area VALUES (1001,'330922','嵊泗县','330900'); INSERT INTO hat_area VALUES (1002,'331001','市辖区','331000'); INSERT INTO hat_area VALUES (1003,'331002','椒江区','331000'); INSERT INTO hat_area VALUES (1004,'331003','黄岩区','331000'); INSERT INTO hat_area VALUES (1005,'331004','路桥区','331000'); INSERT INTO hat_area VALUES (1006,'331021','玉环县','331000'); INSERT INTO hat_area VALUES (1007,'331022','三门县','331000'); INSERT INTO hat_area VALUES (1008,'331023','天台县','331000'); INSERT INTO hat_area VALUES (1009,'331024','仙居县','331000'); INSERT INTO hat_area VALUES (1010,'331081','温岭市','331000'); INSERT INTO hat_area VALUES (1011,'331082','临海市','331000'); INSERT INTO hat_area VALUES (1012,'331101','市辖区','331100'); INSERT INTO hat_area VALUES (1013,'331102','莲都区','331100'); INSERT INTO hat_area VALUES (1014,'331121','青田县','331100'); INSERT INTO hat_area VALUES (1015,'331122','缙云县','331100'); INSERT INTO hat_area VALUES (1016,'331123','遂昌县','331100'); INSERT INTO hat_area VALUES (1017,'331124','松阳县','331100'); INSERT INTO hat_area VALUES (1018,'331125','云和县','331100'); INSERT INTO hat_area VALUES (1019,'331126','庆元县','331100');

INSERT INTO hat_area VALUES (1020,'331127','景宁畲族自治县','331100'); INSERT INTO hat_area VALUES (1021,'331181','龙泉市','331100'); INSERT INTO hat_area VALUES (1022,'340101','市辖区','340100'); INSERT INTO hat_area VALUES (1023,'340102','瑶海区','340100'); INSERT INTO hat_area VALUES (1024,'340103','庐阳区','340100'); INSERT INTO hat_area VALUES (1025,'340104','蜀山区','340100'); INSERT INTO hat_area VALUES (1026,'340111','包河区','340100'); INSERT INTO hat_area VALUES (1027,'340121','长丰县','340100'); INSERT INTO hat_area VALUES (1028,'340122','肥东县','340100');

INSERT INTO hat_area VALUES (1029,'340123','肥西县','340100'); INSERT INTO hat_area VALUES (1030,'340201','市辖区','340200'); INSERT INTO hat_area VALUES (1031,'340202','镜湖区','340200'); INSERT INTO hat_area VALUES (1032,'340203','马塘区','340200'); INSERT INTO hat_area VALUES (1033,'340204','新芜区','340200'); INSERT INTO hat_area VALUES (1034,'340207','鸠江区','340200'); INSERT INTO hat_area VALUES (1035,'340221','芜湖县','340200'); INSERT INTO hat_area VALUES (1036,'340222','繁昌县','340200'); INSERT INTO hat_area VALUES (1037,'340223','南陵县','340200'); INSERT INTO hat_area VALUES (1038,'340301','市辖区','340300'); INSERT INTO hat_area VALUES (1039,'340302','龙子湖区','340300'); INSERT INTO hat_area VALUES (1040,'340303','蚌山区','340300'); INSERT INTO hat_area VALUES (1041,'340304','禹会区','340300'); INSERT INTO hat_area VALUES (1042,'340311','淮上区','340300'); INSERT INTO hat_area VALUES (1043,'340321','怀远县','340300'); INSERT INTO hat_area VALUES (1044,'340322','五河县','340300'); INSERT INTO hat_area VALUES (1045,'340323','固镇县','340300'); INSERT INTO hat_area VALUES (1046,'340401','市辖区','340400'); INSERT INTO hat_area VALUES (1047,'340402','大通区','340400'); INSERT INTO hat_area VALUES (1048,'340403','田家庵区','340400'); INSERT INTO hat_area VALUES (1049,'340404','谢家集区','340400'); INSERT INTO hat_area VALUES (1050,'340405','八公山区','340400'); INSERT INTO hat_area VALUES (1051,'340406','潘集区','340400'); INSERT INTO hat_area VALUES (1052,'340421','凤台县','340400'); INSERT INTO hat_area VALUES (1053,'340501','市辖区','340500'); INSERT INTO hat_area VALUES (1054,'340502','金家庄区','340500'); INSERT INTO hat_area VALUES (1055,'340503','花山区','340500'); INSERT INTO hat_area VALUES (1056,'340504','雨山区','340500'); INSERT INTO hat_area VALUES (1057,'340521','当涂县','340500'); INSERT INTO hat_area VALUES (1058,'340601','市辖区','340600'); INSERT INTO hat_area VALUES (1059,'340602','杜集区','340600'); INSERT INTO hat_area VALUES (1060,'340603','相山区','340600'); INSERT INTO hat_area VALUES (1061,'340604','烈山区','340600'); INSERT INTO hat_area VALUES (1062,'340621','濉溪县','340600'); INSERT INTO hat_area VALUES (1063,'340701','市辖区','340700'); INSERT INTO hat_area VALUES (1064,'340702','铜官山区','340700'); INSERT INTO hat_area VALUES (1065,'340703','狮子山区','340700'); INSERT INTO hat_area VALUES (1066,'340711','郊 区','340700'); INSERT INTO hat_area VALUES (1067,'340721','铜陵县','340700'); INSERT INTO hat_area VALUES (1068,'340801','市辖区','340800'); INSERT INTO hat_area VALUES (1069,'340802','迎江区','340800'); INSERT INTO hat_area VALUES (1070,'340803','大观区','340800'); INSERT INTO hat_area VALUES (1071,'340811','郊 区','340800'); INSERT INTO hat_area VALUES (1072,'340822','怀宁县','340800');

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

INSERTINTOhat_areaVALUES(853,'320582','张家港市','320500');INSERTINTOhat_areaVALUES(854,'320583','昆山市','320500');INSERTINTOhat_areaVALUES(855,'320584','吴江市','320500');INSERTINTOhat_are
推荐度:
点击下载文档文档为doc格式
6nfrw8csng55t2h95zwz
领取福利

微信扫码领取福利

微信扫码分享