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

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

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

INSERT INTO hat_area VALUES (633,'222401','延吉市','222400'); INSERT INTO hat_area VALUES (634,'222402','图们市','222400'); INSERT INTO hat_area VALUES (635,'222403','敦化市','222400'); INSERT INTO hat_area VALUES (636,'222404','珲春市','222400'); INSERT INTO hat_area VALUES (637,'222405','龙井市','222400'); INSERT INTO hat_area VALUES (638,'222406','和龙市','222400'); INSERT INTO hat_area VALUES (639,'222424','汪清县','222400'); INSERT INTO hat_area VALUES (640,'222426','安图县','222400'); INSERT INTO hat_area VALUES (641,'230101','市辖区','230100'); INSERT INTO hat_area VALUES (642,'230102','道里区','230100'); INSERT INTO hat_area VALUES (643,'230103','南岗区','230100'); INSERT INTO hat_area VALUES (644,'230104','道外区','230100'); INSERT INTO hat_area VALUES (645,'230106','香坊区','230100'); INSERT INTO hat_area VALUES (646,'230107','动力区','230100'); INSERT INTO hat_area VALUES (647,'230108','平房区','230100'); INSERT INTO hat_area VALUES (648,'230109','松北区','230100'); INSERT INTO hat_area VALUES (649,'230111','呼兰区','230100'); INSERT INTO hat_area VALUES (650,'230123','依兰县','230100'); INSERT INTO hat_area VALUES (651,'230124','方正县','230100'); INSERT INTO hat_area VALUES (652,'230125','宾 县','230100'); INSERT INTO hat_area VALUES (653,'230126','巴彦县','230100'); INSERT INTO hat_area VALUES (654,'230127','木兰县','230100'); INSERT INTO hat_area VALUES (655,'230128','通河县','230100'); INSERT INTO hat_area VALUES (656,'230129','延寿县','230100'); INSERT INTO hat_area VALUES (657,'230181','阿城市','230100'); INSERT INTO hat_area VALUES (658,'230182','双城市','230100'); INSERT INTO hat_area VALUES (659,'230183','尚志市','230100'); INSERT INTO hat_area VALUES (660,'230184','五常市','230100'); INSERT INTO hat_area VALUES (661,'230201','市辖区','230200'); INSERT INTO hat_area VALUES (662,'230202','龙沙区','230200'); INSERT INTO hat_area VALUES (663,'230203','建华区','230200'); INSERT INTO hat_area VALUES (664,'230204','铁锋区','230200'); INSERT INTO hat_area VALUES (665,'230205','昂昂溪区','230200'); INSERT INTO hat_area VALUES (666,'230206','富拉尔基区','230200'); INSERT INTO hat_area VALUES (667,'230207','碾子山区','230200');

INSERT INTO hat_area VALUES (668,'230208','梅里斯达斡尔族区','230200'); INSERT INTO hat_area VALUES (669,'230221','龙江县','230200'); INSERT INTO hat_area VALUES (670,'230223','依安县','230200'); INSERT INTO hat_area VALUES (671,'230224','泰来县','230200'); INSERT INTO hat_area VALUES (672,'230225','甘南县','230200'); INSERT INTO hat_area VALUES (673,'230227','富裕县','230200'); INSERT INTO hat_area VALUES (674,'230229','克山县','230200'); INSERT INTO hat_area VALUES (675,'230230','克东县','230200'); INSERT INTO hat_area VALUES (676,'230231','拜泉县','230200');

INSERT INTO hat_area VALUES (677,'230281','讷河市','230200'); INSERT INTO hat_area VALUES (678,'230301','市辖区','230300'); INSERT INTO hat_area VALUES (679,'230302','鸡冠区','230300'); INSERT INTO hat_area VALUES (680,'230303','恒山区','230300'); INSERT INTO hat_area VALUES (681,'230304','滴道区','230300'); INSERT INTO hat_area VALUES (682,'230305','梨树区','230300'); INSERT INTO hat_area VALUES (683,'230306','城子河区','230300'); INSERT INTO hat_area VALUES (684,'230307','麻山区','230300'); INSERT INTO hat_area VALUES (685,'230321','鸡东县','230300'); INSERT INTO hat_area VALUES (686,'230381','虎林市','230300'); INSERT INTO hat_area VALUES (687,'230382','密山市','230300'); INSERT INTO hat_area VALUES (688,'230401','市辖区','230400'); INSERT INTO hat_area VALUES (689,'230402','向阳区','230400'); INSERT INTO hat_area VALUES (690,'230403','工农区','230400'); INSERT INTO hat_area VALUES (691,'230404','南山区','230400'); INSERT INTO hat_area VALUES (692,'230405','兴安区','230400'); INSERT INTO hat_area VALUES (693,'230406','东山区','230400'); INSERT INTO hat_area VALUES (694,'230407','兴山区','230400'); INSERT INTO hat_area VALUES (695,'230421','萝北县','230400'); INSERT INTO hat_area VALUES (696,'230422','绥滨县','230400'); INSERT INTO hat_area VALUES (697,'230501','市辖区','230500'); INSERT INTO hat_area VALUES (698,'230502','尖山区','230500'); INSERT INTO hat_area VALUES (699,'230503','岭东区','230500'); INSERT INTO hat_area VALUES (700,'230505','四方台区','230500'); INSERT INTO hat_area VALUES (701,'230506','宝山区','230500'); INSERT INTO hat_area VALUES (702,'230521','集贤县','230500'); INSERT INTO hat_area VALUES (703,'230522','友谊县','230500'); INSERT INTO hat_area VALUES (704,'230523','宝清县','230500'); INSERT INTO hat_area VALUES (705,'230524','饶河县','230500'); INSERT INTO hat_area VALUES (706,'230601','市辖区','230600'); INSERT INTO hat_area VALUES (707,'230602','萨尔图区','230600'); INSERT INTO hat_area VALUES (708,'230603','龙凤区','230600'); INSERT INTO hat_area VALUES (709,'230604','让胡路区','230600'); INSERT INTO hat_area VALUES (710,'230605','红岗区','230600'); INSERT INTO hat_area VALUES (711,'230606','大同区','230600'); INSERT INTO hat_area VALUES (712,'230621','肇州县','230600'); INSERT INTO hat_area VALUES (713,'230622','肇源县','230600'); INSERT INTO hat_area VALUES (714,'230623','林甸县','230600');

INSERT INTO hat_area VALUES (715,'230624','杜尔伯特蒙古族自治县','230600'); INSERT INTO hat_area VALUES (716,'230701','市辖区','230700'); INSERT INTO hat_area VALUES (717,'230702','伊春区','230700'); INSERT INTO hat_area VALUES (718,'230703','南岔区','230700'); INSERT INTO hat_area VALUES (719,'230704','友好区','230700'); INSERT INTO hat_area VALUES (720,'230705','西林区','230700');

INSERT INTO hat_area VALUES (721,'230706','翠峦区','230700'); INSERT INTO hat_area VALUES (722,'230707','新青区','230700'); INSERT INTO hat_area VALUES (723,'230708','美溪区','230700'); INSERT INTO hat_area VALUES (724,'230709','金山屯区','230700'); INSERT INTO hat_area VALUES (725,'230710','五营区','230700'); INSERT INTO hat_area VALUES (726,'230711','乌马河区','230700'); INSERT INTO hat_area VALUES (727,'230712','汤旺河区','230700'); INSERT INTO hat_area VALUES (728,'230713','带岭区','230700'); INSERT INTO hat_area VALUES (729,'230714','乌伊岭区','230700'); INSERT INTO hat_area VALUES (730,'230715','红星区','230700'); INSERT INTO hat_area VALUES (731,'230716','上甘岭区','230700'); INSERT INTO hat_area VALUES (732,'230722','嘉荫县','230700'); INSERT INTO hat_area VALUES (733,'230781','铁力市','230700'); INSERT INTO hat_area VALUES (734,'230801','市辖区','230800'); INSERT INTO hat_area VALUES (735,'230802','永红区','230800'); INSERT INTO hat_area VALUES (736,'230803','向阳区','230800'); INSERT INTO hat_area VALUES (737,'230804','前进区','230800'); INSERT INTO hat_area VALUES (738,'230805','东风区','230800'); INSERT INTO hat_area VALUES (739,'230811','郊 区','230800'); INSERT INTO hat_area VALUES (740,'230822','桦南县','230800'); INSERT INTO hat_area VALUES (741,'230826','桦川县','230800'); INSERT INTO hat_area VALUES (742,'230828','汤原县','230800'); INSERT INTO hat_area VALUES (743,'230833','抚远县','230800'); INSERT INTO hat_area VALUES (744,'230881','同江市','230800'); INSERT INTO hat_area VALUES (745,'230882','富锦市','230800'); INSERT INTO hat_area VALUES (746,'230901','市辖区','230900'); INSERT INTO hat_area VALUES (747,'230902','新兴区','230900'); INSERT INTO hat_area VALUES (748,'230903','桃山区','230900'); INSERT INTO hat_area VALUES (749,'230904','茄子河区','230900'); INSERT INTO hat_area VALUES (750,'230921','勃利县','230900'); INSERT INTO hat_area VALUES (751,'231001','市辖区','231000'); INSERT INTO hat_area VALUES (752,'231002','东安区','231000'); INSERT INTO hat_area VALUES (753,'231003','阳明区','231000'); INSERT INTO hat_area VALUES (754,'231004','爱民区','231000'); INSERT INTO hat_area VALUES (755,'231005','西安区','231000'); INSERT INTO hat_area VALUES (756,'231024','东宁县','231000'); INSERT INTO hat_area VALUES (757,'231025','林口县','231000'); INSERT INTO hat_area VALUES (758,'231081','绥芬河市','231000'); INSERT INTO hat_area VALUES (759,'231083','海林市','231000'); INSERT INTO hat_area VALUES (760,'231084','宁安市','231000'); INSERT INTO hat_area VALUES (761,'231085','穆棱市','231000'); INSERT INTO hat_area VALUES (762,'231101','市辖区','231100'); INSERT INTO hat_area VALUES (763,'231102','爱辉区','231100'); INSERT INTO hat_area VALUES (764,'231121','嫩江县','231100');

INSERT INTO hat_area VALUES (765,'231123','逊克县','231100'); INSERT INTO hat_area VALUES (766,'231124','孙吴县','231100'); INSERT INTO hat_area VALUES (767,'231181','北安市','231100'); INSERT INTO hat_area VALUES (768,'231182','五大连池市','231100'); INSERT INTO hat_area VALUES (769,'231201','市辖区','231200'); INSERT INTO hat_area VALUES (770,'231202','北林区','231200'); INSERT INTO hat_area VALUES (771,'231221','望奎县','231200'); INSERT INTO hat_area VALUES (772,'231222','兰西县','231200'); INSERT INTO hat_area VALUES (773,'231223','青冈县','231200'); INSERT INTO hat_area VALUES (774,'231224','庆安县','231200'); INSERT INTO hat_area VALUES (775,'231225','明水县','231200'); INSERT INTO hat_area VALUES (776,'231226','绥棱县','231200'); INSERT INTO hat_area VALUES (777,'231281','安达市','231200'); INSERT INTO hat_area VALUES (778,'231282','肇东市','231200'); INSERT INTO hat_area VALUES (779,'231283','海伦市','231200'); INSERT INTO hat_area VALUES (780,'232721','呼玛县','232700'); INSERT INTO hat_area VALUES (781,'232722','塔河县','232700'); INSERT INTO hat_area VALUES (782,'232723','漠河县','232700'); INSERT INTO hat_area VALUES (783,'310101','黄浦区','310100'); INSERT INTO hat_area VALUES (784,'310103','卢湾区','310100'); INSERT INTO hat_area VALUES (785,'310104','徐汇区','310100'); INSERT INTO hat_area VALUES (786,'310105','长宁区','310100'); INSERT INTO hat_area VALUES (787,'310106','静安区','310100'); INSERT INTO hat_area VALUES (788,'310107','普陀区','310100'); INSERT INTO hat_area VALUES (789,'310108','闸北区','310100'); INSERT INTO hat_area VALUES (790,'310109','虹口区','310100'); INSERT INTO hat_area VALUES (791,'310110','杨浦区','310100'); INSERT INTO hat_area VALUES (792,'310112','闵行区','310100'); INSERT INTO hat_area VALUES (793,'310113','宝山区','310100'); INSERT INTO hat_area VALUES (794,'310114','嘉定区','310100'); INSERT INTO hat_area VALUES (795,'310115','浦东新区','310100'); INSERT INTO hat_area VALUES (796,'310116','金山区','310100'); INSERT INTO hat_area VALUES (797,'310117','松江区','310100'); INSERT INTO hat_area VALUES (798,'310118','青浦区','310100'); INSERT INTO hat_area VALUES (799,'310119','南汇区','310100'); INSERT INTO hat_area VALUES (800,'310120','奉贤区','310100'); INSERT INTO hat_area VALUES (801,'310230','崇明县','310200'); INSERT INTO hat_area VALUES (802,'320101','市辖区','320100'); INSERT INTO hat_area VALUES (803,'320102','玄武区','320100'); INSERT INTO hat_area VALUES (804,'320103','白下区','320100'); INSERT INTO hat_area VALUES (805,'320104','秦淮区','320100'); INSERT INTO hat_area VALUES (806,'320105','建邺区','320100'); INSERT INTO hat_area VALUES (807,'320106','鼓楼区','320100'); INSERT INTO hat_area VALUES (808,'320107','下关区','320100');

INSERT INTO hat_area VALUES (809,'320111','浦口区','320100'); INSERT INTO hat_area VALUES (810,'320113','栖霞区','320100'); INSERT INTO hat_area VALUES (811,'320114','雨花台区','320100'); INSERT INTO hat_area VALUES (812,'320115','江宁区','320100'); INSERT INTO hat_area VALUES (813,'320116','六合区','320100'); INSERT INTO hat_area VALUES (814,'320124','溧水县','320100'); INSERT INTO hat_area VALUES (815,'320125','高淳县','320100'); INSERT INTO hat_area VALUES (816,'320201','市辖区','320200'); INSERT INTO hat_area VALUES (817,'320202','崇安区','320200'); INSERT INTO hat_area VALUES (818,'320203','南长区','320200'); INSERT INTO hat_area VALUES (819,'320204','北塘区','320200'); INSERT INTO hat_area VALUES (820,'320205','锡山区','320200'); INSERT INTO hat_area VALUES (821,'320206','惠山区','320200'); INSERT INTO hat_area VALUES (822,'320211','滨湖区','320200'); INSERT INTO hat_area VALUES (823,'320281','江阴市','320200'); INSERT INTO hat_area VALUES (824,'320282','宜兴市','320200'); INSERT INTO hat_area VALUES (825,'320301','市辖区','320300'); INSERT INTO hat_area VALUES (826,'320302','鼓楼区','320300'); INSERT INTO hat_area VALUES (827,'320303','云龙区','320300'); INSERT INTO hat_area VALUES (828,'320304','九里区','320300'); INSERT INTO hat_area VALUES (829,'320305','贾汪区','320300'); INSERT INTO hat_area VALUES (830,'320311','泉山区','320300'); INSERT INTO hat_area VALUES (831,'320321','丰 县','320300'); INSERT INTO hat_area VALUES (832,'320322','沛 县','320300'); INSERT INTO hat_area VALUES (833,'320323','铜山县','320300'); INSERT INTO hat_area VALUES (834,'320324','睢宁县','320300'); INSERT INTO hat_area VALUES (835,'320381','新沂市','320300'); INSERT INTO hat_area VALUES (836,'320382','邳州市','320300'); INSERT INTO hat_area VALUES (837,'320401','市辖区','320400'); INSERT INTO hat_area VALUES (838,'320402','天宁区','320400'); INSERT INTO hat_area VALUES (839,'320404','钟楼区','320400'); INSERT INTO hat_area VALUES (840,'320405','戚墅堰区','320400'); INSERT INTO hat_area VALUES (841,'320411','新北区','320400'); INSERT INTO hat_area VALUES (842,'320412','武进区','320400'); INSERT INTO hat_area VALUES (843,'320481','溧阳市','320400'); INSERT INTO hat_area VALUES (844,'320482','金坛市','320400'); INSERT INTO hat_area VALUES (845,'320501','市辖区','320500'); INSERT INTO hat_area VALUES (846,'320502','沧浪区','320500'); INSERT INTO hat_area VALUES (847,'320503','平江区','320500'); INSERT INTO hat_area VALUES (848,'320504','金阊区','320500'); INSERT INTO hat_area VALUES (849,'320505','虎丘区','320500'); INSERT INTO hat_area VALUES (850,'320506','吴中区','320500'); INSERT INTO hat_area VALUES (851,'320507','相城区','320500'); INSERT INTO hat_area VALUES (852,'320581','常熟市','320500');

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

INSERTINTOhat_areaVALUES(633,'222401','延吉市','222400');INSERTINTOhat_areaVALUES(634,'222402','图们市','222400');INSERTINTOhat_areaVALUES(635,'222403','敦化市','222400');INSERTINTOhat_area
推荐度:
点击下载文档文档为doc格式
6nfrw8csng55t2h95zwz
领取福利

微信扫码领取福利

微信扫码分享