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

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

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

INSERT INTO hat_area VALUES (413,'150781','满洲里市','150700'); INSERT INTO hat_area VALUES (414,'150782','牙克石市','150700'); INSERT INTO hat_area VALUES (415,'150783','扎兰屯市','150700'); INSERT INTO hat_area VALUES (416,'150784','额尔古纳市','150700'); INSERT INTO hat_area VALUES (417,'150785','根河市','150700'); INSERT INTO hat_area VALUES (418,'150801','市辖区','150800'); INSERT INTO hat_area VALUES (419,'150802','临河区','150800'); INSERT INTO hat_area VALUES (420,'150821','五原县','150800'); INSERT INTO hat_area VALUES (421,'150822','磴口县','150800'); INSERT INTO hat_area VALUES (422,'150823','乌拉特前旗','150800'); INSERT INTO hat_area VALUES (423,'150824','乌拉特中旗','150800'); INSERT INTO hat_area VALUES (424,'150825','乌拉特后旗','150800'); INSERT INTO hat_area VALUES (425,'150826','杭锦后旗','150800'); INSERT INTO hat_area VALUES (426,'150901','市辖区','150900'); INSERT INTO hat_area VALUES (427,'150902','集宁区','150900'); INSERT INTO hat_area VALUES (428,'150921','卓资县','150900'); INSERT INTO hat_area VALUES (429,'150922','化德县','150900'); INSERT INTO hat_area VALUES (430,'150923','商都县','150900'); INSERT INTO hat_area VALUES (431,'150924','兴和县','150900'); INSERT INTO hat_area VALUES (432,'150925','凉城县','150900');

INSERT INTO hat_area VALUES (433,'150926','察哈尔右翼前旗','150900'); INSERT INTO hat_area VALUES (434,'150927','察哈尔右翼中旗','150900'); INSERT INTO hat_area VALUES (435,'150928','察哈尔右翼后旗','150900'); INSERT INTO hat_area VALUES (436,'150929','四子王旗','150900'); INSERT INTO hat_area VALUES (437,'150981','丰镇市','150900'); INSERT INTO hat_area VALUES (438,'152201','乌兰浩特市','152200'); INSERT INTO hat_area VALUES (439,'152202','阿尔山市','152200');

INSERT INTO hat_area VALUES (440,'152221','科尔沁右翼前旗','152200'); INSERT INTO hat_area VALUES (441,'152222','科尔沁右翼中旗','152200'); INSERT INTO hat_area VALUES (442,'152223','扎赉特旗','152200'); INSERT INTO hat_area VALUES (443,'152224','突泉县','152200'); INSERT INTO hat_area VALUES (444,'152501','二连浩特市','152500'); INSERT INTO hat_area VALUES (445,'152502','锡林浩特市','152500'); INSERT INTO hat_area VALUES (446,'152522','阿巴嘎旗','152500'); INSERT INTO hat_area VALUES (447,'152523','苏尼特左旗','152500'); INSERT INTO hat_area VALUES (448,'152524','苏尼特右旗','152500'); INSERT INTO hat_area VALUES (449,'152525','东乌珠穆沁旗','152500'); INSERT INTO hat_area VALUES (450,'152526','西乌珠穆沁旗','152500'); INSERT INTO hat_area VALUES (451,'152527','太仆寺旗','152500'); INSERT INTO hat_area VALUES (452,'152528','镶黄旗','152500'); INSERT INTO hat_area VALUES (453,'152529','正镶白旗','152500'); INSERT INTO hat_area VALUES (454,'152530','正蓝旗','152500'); INSERT INTO hat_area VALUES (455,'152531','多伦县','152500'); INSERT INTO hat_area VALUES (456,'152921','阿拉善左旗','152900');

INSERT INTO hat_area VALUES (457,'152922','阿拉善右旗','152900'); INSERT INTO hat_area VALUES (458,'152923','额济纳旗','152900'); INSERT INTO hat_area VALUES (459,'210101','市辖区','210100'); INSERT INTO hat_area VALUES (460,'210102','和平区','210100'); INSERT INTO hat_area VALUES (461,'210103','沈河区','210100'); INSERT INTO hat_area VALUES (462,'210104','大东区','210100'); INSERT INTO hat_area VALUES (463,'210105','皇姑区','210100'); INSERT INTO hat_area VALUES (464,'210106','铁西区','210100'); INSERT INTO hat_area VALUES (465,'210111','苏家屯区','210100'); INSERT INTO hat_area VALUES (466,'210112','东陵区','210100'); INSERT INTO hat_area VALUES (467,'210113','新城子区','210100'); INSERT INTO hat_area VALUES (468,'210114','于洪区','210100'); INSERT INTO hat_area VALUES (469,'210122','辽中县','210100'); INSERT INTO hat_area VALUES (470,'210123','康平县','210100'); INSERT INTO hat_area VALUES (471,'210124','法库县','210100'); INSERT INTO hat_area VALUES (472,'210181','新民市','210100'); INSERT INTO hat_area VALUES (473,'210201','市辖区','210200'); INSERT INTO hat_area VALUES (474,'210202','中山区','210200'); INSERT INTO hat_area VALUES (475,'210203','西岗区','210200'); INSERT INTO hat_area VALUES (476,'210204','沙河口区','210200'); INSERT INTO hat_area VALUES (477,'210211','甘井子区','210200'); INSERT INTO hat_area VALUES (478,'210212','旅顺口区','210200'); INSERT INTO hat_area VALUES (479,'210213','金州区','210200'); INSERT INTO hat_area VALUES (480,'210224','长海县','210200'); INSERT INTO hat_area VALUES (481,'210281','瓦房店市','210200'); INSERT INTO hat_area VALUES (482,'210282','普兰店市','210200'); INSERT INTO hat_area VALUES (483,'210283','庄河市','210200'); INSERT INTO hat_area VALUES (484,'210301','市辖区','210300'); INSERT INTO hat_area VALUES (485,'210302','铁东区','210300'); INSERT INTO hat_area VALUES (486,'210303','铁西区','210300'); INSERT INTO hat_area VALUES (487,'210304','立山区','210300'); INSERT INTO hat_area VALUES (488,'210311','千山区','210300'); INSERT INTO hat_area VALUES (489,'210321','台安县','210300');

INSERT INTO hat_area VALUES (490,'210323','岫岩满族自治县','210300'); INSERT INTO hat_area VALUES (491,'210381','海城市','210300'); INSERT INTO hat_area VALUES (492,'210401','市辖区','210400'); INSERT INTO hat_area VALUES (493,'210402','新抚区','210400'); INSERT INTO hat_area VALUES (494,'210403','东洲区','210400'); INSERT INTO hat_area VALUES (495,'210404','望花区','210400'); INSERT INTO hat_area VALUES (496,'210411','顺城区','210400'); INSERT INTO hat_area VALUES (497,'210421','抚顺县','210400');

INSERT INTO hat_area VALUES (498,'210422','新宾满族自治县','210400'); INSERT INTO hat_area VALUES (499,'210423','清原满族自治县','210400'); INSERT INTO hat_area VALUES (500,'210501','市辖区','210500');

INSERT INTO hat_area VALUES (501,'210502','平山区','210500'); INSERT INTO hat_area VALUES (502,'210503','溪湖区','210500'); INSERT INTO hat_area VALUES (503,'210504','明山区','210500'); INSERT INTO hat_area VALUES (504,'210505','南芬区','210500');

INSERT INTO hat_area VALUES (505,'210521','本溪满族自治县','210500'); INSERT INTO hat_area VALUES (506,'210522','桓仁满族自治县','210500'); INSERT INTO hat_area VALUES (507,'210601','市辖区','210600'); INSERT INTO hat_area VALUES (508,'210602','元宝区','210600'); INSERT INTO hat_area VALUES (509,'210603','振兴区','210600'); INSERT INTO hat_area VALUES (510,'210604','振安区','210600');

INSERT INTO hat_area VALUES (511,'210624','宽甸满族自治县','210600'); INSERT INTO hat_area VALUES (512,'210681','东港市','210600'); INSERT INTO hat_area VALUES (513,'210682','凤城市','210600'); INSERT INTO hat_area VALUES (514,'210701','市辖区','210700'); INSERT INTO hat_area VALUES (515,'210702','古塔区','210700'); INSERT INTO hat_area VALUES (516,'210703','凌河区','210700'); INSERT INTO hat_area VALUES (517,'210711','太和区','210700'); INSERT INTO hat_area VALUES (518,'210726','黑山县','210700'); INSERT INTO hat_area VALUES (519,'210727','义 县','210700'); INSERT INTO hat_area VALUES (520,'210781','凌海市','210700'); INSERT INTO hat_area VALUES (521,'210782','北宁市','210700'); INSERT INTO hat_area VALUES (522,'210801','市辖区','210800'); INSERT INTO hat_area VALUES (523,'210802','站前区','210800'); INSERT INTO hat_area VALUES (524,'210803','西市区','210800'); INSERT INTO hat_area VALUES (525,'210804','鲅鱼圈区','210800'); INSERT INTO hat_area VALUES (526,'210811','老边区','210800'); INSERT INTO hat_area VALUES (527,'210881','盖州市','210800'); INSERT INTO hat_area VALUES (528,'210882','大石桥市','210800'); INSERT INTO hat_area VALUES (529,'210901','市辖区','210900'); INSERT INTO hat_area VALUES (530,'210902','海州区','210900'); INSERT INTO hat_area VALUES (531,'210903','新邱区','210900'); INSERT INTO hat_area VALUES (532,'210904','太平区','210900'); INSERT INTO hat_area VALUES (533,'210905','清河门区','210900'); INSERT INTO hat_area VALUES (534,'210911','细河区','210900');

INSERT INTO hat_area VALUES (535,'210921','阜新蒙古族自治县','210900'); INSERT INTO hat_area VALUES (536,'210922','彰武县','210900'); INSERT INTO hat_area VALUES (537,'211001','市辖区','211000'); INSERT INTO hat_area VALUES (538,'211002','白塔区','211000'); INSERT INTO hat_area VALUES (539,'211003','文圣区','211000'); INSERT INTO hat_area VALUES (540,'211004','宏伟区','211000'); INSERT INTO hat_area VALUES (541,'211005','弓长岭区','211000'); INSERT INTO hat_area VALUES (542,'211011','太子河区','211000'); INSERT INTO hat_area VALUES (543,'211021','辽阳县','211000'); INSERT INTO hat_area VALUES (544,'211081','灯塔市','211000');

INSERT INTO hat_area VALUES (545,'211101','市辖区','211100'); INSERT INTO hat_area VALUES (546,'211102','双台子区','211100'); INSERT INTO hat_area VALUES (547,'211103','兴隆台区','211100'); INSERT INTO hat_area VALUES (548,'211121','大洼县','211100'); INSERT INTO hat_area VALUES (549,'211122','盘山县','211100'); INSERT INTO hat_area VALUES (550,'211201','市辖区','211200'); INSERT INTO hat_area VALUES (551,'211202','银州区','211200'); INSERT INTO hat_area VALUES (552,'211204','清河区','211200'); INSERT INTO hat_area VALUES (553,'211221','铁岭县','211200'); INSERT INTO hat_area VALUES (554,'211223','西丰县','211200'); INSERT INTO hat_area VALUES (555,'211224','昌图县','211200'); INSERT INTO hat_area VALUES (556,'211281','调兵山市','211200'); INSERT INTO hat_area VALUES (557,'211282','开原市','211200'); INSERT INTO hat_area VALUES (558,'211301','市辖区','211300'); INSERT INTO hat_area VALUES (559,'211302','双塔区','211300'); INSERT INTO hat_area VALUES (560,'211303','龙城区','211300'); INSERT INTO hat_area VALUES (561,'211321','朝阳县','211300'); INSERT INTO hat_area VALUES (562,'211322','建平县','211300');

INSERT INTO hat_area VALUES (563,'211324','喀喇沁左翼蒙古族自治县','211300'); INSERT INTO hat_area VALUES (564,'211381','北票市','211300'); INSERT INTO hat_area VALUES (565,'211382','凌源市','211300'); INSERT INTO hat_area VALUES (566,'211401','市辖区','211400'); INSERT INTO hat_area VALUES (567,'211402','连山区','211400'); INSERT INTO hat_area VALUES (568,'211403','龙港区','211400'); INSERT INTO hat_area VALUES (569,'211404','南票区','211400'); INSERT INTO hat_area VALUES (570,'211421','绥中县','211400'); INSERT INTO hat_area VALUES (571,'211422','建昌县','211400'); INSERT INTO hat_area VALUES (572,'211481','兴城市','211400'); INSERT INTO hat_area VALUES (573,'220101','市辖区','220100'); INSERT INTO hat_area VALUES (574,'220102','南关区','220100'); INSERT INTO hat_area VALUES (575,'220103','宽城区','220100'); INSERT INTO hat_area VALUES (576,'220104','朝阳区','220100'); INSERT INTO hat_area VALUES (577,'220105','二道区','220100'); INSERT INTO hat_area VALUES (578,'220106','绿园区','220100'); INSERT INTO hat_area VALUES (579,'220112','双阳区','220100'); INSERT INTO hat_area VALUES (580,'220122','农安县','220100'); INSERT INTO hat_area VALUES (581,'220181','九台市','220100'); INSERT INTO hat_area VALUES (582,'220182','榆树市','220100'); INSERT INTO hat_area VALUES (583,'220183','德惠市','220100'); INSERT INTO hat_area VALUES (584,'220201','市辖区','220200'); INSERT INTO hat_area VALUES (585,'220202','昌邑区','220200'); INSERT INTO hat_area VALUES (586,'220203','龙潭区','220200'); INSERT INTO hat_area VALUES (587,'220204','船营区','220200'); INSERT INTO hat_area VALUES (588,'220211','丰满区','220200');

INSERT INTO hat_area VALUES (589,'220221','永吉县','220200'); INSERT INTO hat_area VALUES (590,'220281','蛟河市','220200'); INSERT INTO hat_area VALUES (591,'220282','桦甸市','220200'); INSERT INTO hat_area VALUES (592,'220283','舒兰市','220200'); INSERT INTO hat_area VALUES (593,'220284','磐石市','220200'); INSERT INTO hat_area VALUES (594,'220301','市辖区','220300'); INSERT INTO hat_area VALUES (595,'220302','铁西区','220300'); INSERT INTO hat_area VALUES (596,'220303','铁东区','220300'); INSERT INTO hat_area VALUES (597,'220322','梨树县','220300');

INSERT INTO hat_area VALUES (598,'220323','伊通满族自治县','220300'); INSERT INTO hat_area VALUES (599,'220381','公主岭市','220300'); INSERT INTO hat_area VALUES (600,'220382','双辽市','220300'); INSERT INTO hat_area VALUES (601,'220401','市辖区','220400'); INSERT INTO hat_area VALUES (602,'220402','龙山区','220400'); INSERT INTO hat_area VALUES (603,'220403','西安区','220400'); INSERT INTO hat_area VALUES (604,'220421','东丰县','220400'); INSERT INTO hat_area VALUES (605,'220422','东辽县','220400'); INSERT INTO hat_area VALUES (606,'220501','市辖区','220500'); INSERT INTO hat_area VALUES (607,'220502','东昌区','220500'); INSERT INTO hat_area VALUES (608,'220503','二道江区','220500'); INSERT INTO hat_area VALUES (609,'220521','通化县','220500'); INSERT INTO hat_area VALUES (610,'220523','辉南县','220500'); INSERT INTO hat_area VALUES (611,'220524','柳河县','220500'); INSERT INTO hat_area VALUES (612,'220581','梅河口市','220500'); INSERT INTO hat_area VALUES (613,'220582','集安市','220500'); INSERT INTO hat_area VALUES (614,'220601','市辖区','220600'); INSERT INTO hat_area VALUES (615,'220602','八道江区','220600'); INSERT INTO hat_area VALUES (616,'220621','抚松县','220600'); INSERT INTO hat_area VALUES (617,'220622','靖宇县','220600');

INSERT INTO hat_area VALUES (618,'220623','长白朝鲜族自治县','220600'); INSERT INTO hat_area VALUES (619,'220625','江源县','220600'); INSERT INTO hat_area VALUES (620,'220681','临江市','220600'); INSERT INTO hat_area VALUES (621,'220701','市辖区','220700'); INSERT INTO hat_area VALUES (622,'220702','宁江区','220700');

INSERT INTO hat_area VALUES (623,'220721','前郭尔罗斯蒙古族自治县','220700'); INSERT INTO hat_area VALUES (624,'220722','长岭县','220700'); INSERT INTO hat_area VALUES (625,'220723','乾安县','220700'); INSERT INTO hat_area VALUES (626,'220724','扶余县','220700'); INSERT INTO hat_area VALUES (627,'220801','市辖区','220800'); INSERT INTO hat_area VALUES (628,'220802','洮北区','220800'); INSERT INTO hat_area VALUES (629,'220821','镇赉县','220800'); INSERT INTO hat_area VALUES (630,'220822','通榆县','220800'); INSERT INTO hat_area VALUES (631,'220881','洮南市','220800'); INSERT INTO hat_area VALUES (632,'220882','大安市','220800');

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

INSERTINTOhat_areaVALUES(413,'150781','满洲里市','150700');INSERTINTOhat_areaVALUES(414,'150782','牙克石市','150700');INSERTINTOhat_areaVALUES(415,'150783','扎兰屯市','150700');INSERTINTOhat_a
推荐度:
点击下载文档文档为doc格式
6nfrw8csng55t2h95zwz
领取福利

微信扫码领取福利

微信扫码分享