下载文档原格式
省市区三级联动菜单（附数据库）<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><!----------------------------------------------------------------省的字段是：province--市的字段是：city--县的字段是：area---------------------------------------------------------------------------><mce:script type="text/javascript"><!--/*********定义创建XMLHttpRequest对象的⽅法***************************************/var xmlHttp;//声明变量var requestType="";//声明初始类型为空function createXMLHttpRequest()//定义创建⼀个跨浏览器函数的开头{if(window.ActiveXObject)//ActiveXObject对象到找到的时候返回的是真，否则是假{xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");//这个是使⽤IE的⽅法创建XmlHttp}else if(window.XMLHttpRequest){xmlHttp=new XMLHttpRequest();//这个是使⽤⾮IE的⽅法创建XmlHttp}}/****************判断服务器响应的事件，如果返回是4则说明交互完成，判断标⽰头，**************************************************/function handleStateChange(){//判断返回的⼀个函数，来确定执⾏那个的函数if(xmlHttp.readystate==4){//4说明是执⾏交互完毕0 (未初始化)1 (正在装载)2 (装载完毕) 3 (交互中)4 (完成)if(xmlHttp.status==200){//http的⼀个报头说明成功找到if(type=="city"){//判断查询的类型showcity();//返回响应的显⽰}else if(type="area"){//判断响应的查询的类型showarea();//返回响应的显⽰}}}}/**************************城市的⼀个查询函数**********************************************************/function queryCity(citycode){//执⾏程序查询，查询城市的createXMLHttpRequest();//调⽤创建XmlHttp的函数type="city";//表⽰类型，查询城市处理显⽰的时候需要⽤到var url='data.php?provincecode='+citycode+'&n='+Math.random();//设定URL传值⽅法同时防⽌缓存xmlHttp.open("GET",url,true);//建⽴服务器连接，异步传输treexmlHttp.onreadystatechange=handleStateChange;//处理这个响应所需要的函数xmlHttp.send(null);//执⾏程序函数这⾥的中间的参数是因为GET原因}/**********************县区的⼀个查询函数***********************************************************/function queryArea(citycode){//查询程序createXMLHttpRequest();//调⽤创建XmlHttp的函数type="area";//查询县的var url="data.php?citycode="+citycode+'&n='+Math.random();//设定URL传值⽅法同时防⽌缓存xmlHttp.open("GET",url,true);xmlHttp.onreadystatechange=handleStateChange;//处理响应的函数名xmlHttp.send(null);//执⾏程序函数这⾥的中间的参数是因为GET原因}/*********************⼀个显⽰函数**********************************************************/function showcity(){//显⽰函数document.getElementById("city").innerHTML=xmlHttp.responseText;//捕获ID显⽰返回的数据}function showarea(){document.getElementById("area").innerHTML=xmlHttp.responseText;//捕获ID显⽰返回的数据}$conn=mysql_connect("localhost","root","");//链接数据库mysql_select_db("novel");//选择数据库mysql_query("set names 'utf8'");//设定字符集$sql="select * from province";//查询数据库province表也就是省$result=mysql_query($sql);//执⾏语句赋值给变量><from id='form1'><!--输出表单头--><!--输出下拉列表框，并设定onchange响应事件，把省值传递过去--><select id='province' onchange='queryCity(this.options[this.selectedIndex].value)'><!--输出下拉列表项值--><option value='-1' selected>请选择省份</option><?phpwhile($row=mysql_fetch_row($result)){//循环循环查询显⽰省输出数据显⽰echo "<option value='$row[1]'>$row[2]</option>/n";}></select><!--下拉列表项尾数--><span id='city'></span><!--显⽰数据的城市的位置--><span id='area'></span><!--显⽰数据的城市的位置--></form><!--表单项结尾--></body></html><?php$provincecode=$_GET['provincecode'];//接收省键值$citycode=$_GET['citycode'];//接收城市键值$conn=mysql_connect("localhost","root","");//连接主机mysql_select_db("novel");//选择数据库mysql_query("set names 'utf8'");if($provincecode!=""){//如果传递过来的不为空则执⾏$sql="select * from city where provincecode=$provincecode";//查询城市符合属于上边传递过来的省的字段 $result=mysql_query($sql);//执⾏SQL查询语句print_r($row);><select onchange='queryArea(this.options[this.selectedIndex].value)'><!--下拉列表框开头--><option value='-1' selected>请选择城市</option><!--下拉列表框值开头--><?php while($row=mysql_fetch_row($result)){//循环记录集?><option value="<?= $row[1]?>"><?=$row[2]?></option><?php }?></select><?php }?><?phpif($citycode!=""){$sql="select * from area where citycode=$citycode";$result=mysql_query($sql);echo "<select>/n";echo "<option value='-1' selected>请选择县</option>/n";while($row=mysql_fetch_row($result)){echo "<option value='$row[1]'>$row[2]</option>/n";}echo "</select>/n";}>-- phpMyAdmin SQL Dump-- version 2.11.2-- ---- 主机: localhost-- ⽣成⽇期: 2008 年 07 ⽉ 11 ⽇ 00:45-- 服务器版本: 5.0.27-- PHP 版本: 5.2.0SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- 数据库: `novel`--CREATE DATABASE `novel` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;USE `novel`;-- 表的结构 `area`--CREATE TABLE IF NOT EXISTS `area` (`id` int(11) NOT NULL auto_increment,`code` varchar(6) NOT NULL,`name` varchar(20) NOT NULL,`citycode` varchar(6) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3145 ; ---- 导出表中的数据 `area`--INSERT INTO `area` (`id`, `code`, `name`, `citycode`) 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'),(31, '120113', '北⾠区', '120100'),(32, '120114', '武清区', '120100'),(33, '120115', '宝坻区', '120100'),(34, '120221', '宁河县', '120200'),(35, '120223', '静海县', '120200'),(36, '120225', '蓟 县', '120200'),(37, '130101', '市辖区', '130100'),(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'),(61, '130201', '市辖区', '130200'),(62, '130202', '路南区', '130200'),(63, '130203', '路北区', '130200'),(64, '130204', '古冶区', '130200'),(73, '130230', '唐海县', '130200'), (74, '130281', '遵化市', '130200'), (75, '130283', '迁安市', '130200'), (76, '130301', '市辖区', '130300'), (77, '130302', '海港区', '130300'), (78, '130303', '⼭海关区', '130300'), (79, '130304', '北戴河区', '130300'), (80, '130321', '青龙满族⾃治县', '130300'), (81, '130322', '昌黎县', '130300'), (82, '130323', '抚宁县', '130300'), (83, '130324', '卢龙县', '130300'), (84, '130401', '市辖区', '130400'), (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'), (104, '130501', '市辖区', '130500'), (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'), (124, '130601', '市辖区', '130600'), (125, '130602', '新市区', '130600'), (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'),(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'),(168, '130801', '市辖区', '130800'),(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'), (180, '130901', '市辖区', '130900'),(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'),(197, '131001', '市辖区', '131000'),(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'),(208, '131101', '市辖区', '131100'),(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'),(218, '131181', '冀州市', '131100'),(219, '131182', '深州市', '131100'),(220, '140101', '市辖区', '140100'),(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'),(231, '140201', '市辖区', '140200'),(232, '140202', '城 区', '140200'),(241, '140226', '左云县', '140200'), (242, '140227', '⼤同县', '140200'), (243, '140301', '市辖区', '140300'), (244, '140302', '城 区', '140300'), (245, '140303', '矿 区', '140300'), (246, '140311', '郊 区', '140300'), (247, '140321', '平定县', '140300'), (248, '140322', '盂 县', '140300'), (249, '140401', '市辖区', '140400'), (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'), (263, '140501', '市辖区', '140500'), (264, '140502', '城 区', '140500'), (265, '140521', '沁⽔县', '140500'), (266, '140522', '阳城县', '140500'), (267, '140524', '陵川县', '140500'), (268, '140525', '泽州县', '140500'), (269, '140581', '⾼平市', '140500'), (270, '140601', '市辖区', '140600'), (271, '140602', '朔城区', '140600'), (272, '140603', '平鲁区', '140600'), (273, '140621', '⼭阴县', '140600'), (274, '140622', '应 县', '140600'), (275, '140623', '右⽟县', '140600'), (276, '140624', '怀仁县', '140600'), (277, '140701', '市辖区', '140700'), (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'), (289, '140801', '市辖区', '140800'), (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'), (303, '140901', '市辖区', '140900'), (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'), (315, '140931', '保德县', '140900'), (316, '140932', '偏关县', '140900'),(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'),(336, '141101', '市辖区', '141100'),(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'),(350, '150101', '市辖区', '150100'),(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'),(360, '150201', '市辖区', '150200'),(361, '150202', '东河区', '150200'),(362, '150203', '昆都仑区', '150200'),(363, '150204', '青⼭区', '150200'),(364, '150205', '⽯拐区', '150200'),(365, '150206', '⽩云矿区', '150200'),(366, '150207', '九原区', '150200'),(367, '150221', '⼟默特右旗', '150200'), (368, '150222', '固阳县', '150200'),(369, '150223', '达尔罕茂明安联合旗', '150200'), (370, '150301', '市辖区', '150300'),(371, '150302', '海勃湾区', '150300'),(372, '150303', '海南区', '150300'),(373, '150304', '乌达区', '150300'),(374, '150401', '市辖区', '150400'),(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'),(387, '150501', '市辖区', '150500'),(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'),(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'),(418, '150801', '市辖区', '150800'),(419, '150802', '临河区', '150800'),(420, '150821', '五原县', '150800'),(421, '150822', '磴⼝县', '150800'),(422, '150823', '乌拉特前旗', '150800'),(423, '150824', '乌拉特中旗', '150800'),(424, '150825', '乌拉特后旗', '150800'),(425, '150826', '杭锦后旗', '150800'),(426, '150901', '市辖区', '150900'),(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'),(459, '210101', '市辖区', '210100'),(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'),(473, '210201', '市辖区', '210200'),(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'),(484, '210301', '市辖区', '210300'),。
一、介绍全国行政区域划分是指将我国国土按照行政管理区域划分为若干个省、自治区、直辖市、特别行政区和县级行政区域。
这一划分有助于国家的行政管理和资源配置，对于各级政府的管理和公共服务的提供具有重要意义。
在数据库管理系统中，我们可以使用SQLServer来管理全国行政区域划分表。
二、创建全国行政区域划分表1. 创建数据库在SQLServer中，首先需要创建一个数据库来存储全国行政区域划分表。
可以使用如下SQL语句来创建一个名为"区域划分"的数据库：CREATE DATABASE 区域划分;2. 创建表格在创建了数据库之后，我们需要创建一个表格来存储全国行政区域划分的数据。
可以使用如下SQL语句来创建一个名为"行政区域"的表格：CREATE TABLE 行政区域(省份名称 NVARCHAR(50),城市名称 NVARCHAR(50),区县名称 NVARCHAR(50));三、插入数据1. 插入省份数据为了方便管理和查询，我们可以先插入全国的省份数据。
可以使用如下SQL语句来插入一些省份的数据：INSERT INTO 行政区域 (省份名称) VALUES ('北京');INSERT INTO 行政区域 (省份名称) VALUES ('上海');INSERT INTO 行政区域 (省份名称) VALUES ('天津');INSERT INTO 行政区域 (省份名称) VALUES ('重庆');...（其他省份数据省略）2. 插入城市数据同样的方法，我们可以插入各个省份的城市数据：INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '东城区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '西城区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '朝阳区');INSERT INTO 行政区域 (省份名称, 城市名称) VALUES ('北京', '海淀区');...（其他城市数据省略）3. 插入区县数据我们可以插入各个城市的区县数据：INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '东城街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '景山街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '交道口街道');INSERT INTO 行政区域 (省份名称, 城市名称, 区县名称) VALUES ('北京', '东城区', '永定门外街道');...（其他区县数据省略）四、查询数据为了验证数据的插入是否成功，我们可以使用如下的SQL语句来查询某个省份的所有城市和区县数据：SELECT 城市名称, 区县名称 FROM 行政区域 WHERE 省份名称 = '北京';这样就可以查询出北京市的所有城市和区县数据了。
SQL省市区三级表结构-- 表的结构 areaDROP TABLE area;CREATE TABLE area (id int NOT NULL ,areaID int NOT NULL,area varchar(200) NOT NULL,fatherID int NOT NULL,PRIMARY KEY (id))DROP TABLE city;CREATE TABLE city selectid int NOT NULL ,cityID int NOT NULL,city varcharselect 200) NOT NULL,fatherID int NOT NULL,PRIMARY KEY select id))---- 导出表中的数据 city---- ------------------------------------------------------------ 表的结构 province--DROP TABLE province;CREATE TABLE province selectid int NOT NULL ,provinceID int NOT NULL,province varcharselect 200) NOT NULL,PRIMARY KEY select id))insert province(id,provinceID,province)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,'⼴西壮族⾃治区' unionselect 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,'青海省' unionINSERT city (id,cityID,city,fatherID)select 1,110100,'市辖区',110000 unionselect 2,110200,'县',110000 unionselect 3,120100,'市辖区',120000 unionselect 4,120200,'县',120000 unionselect 5,130100,'⽯家庄市',130000 unionselect 6,130200,'唐⼭市',130000 unionselect 7,130300,'秦皇岛市',130000 unionselect 8,130400,'邯郸市',130000 unionselect 9,130500,'邢台市',130000 unionselect 10,130600,'保定市',130000 unionselect 11,130700,'张家⼝市',130000 unionselect 12,130800,'承德市',130000 unionselect 13,130900,'沧州市',130000 unionselect 14,131000,'廊坊市',130000 unionselect 15,131100,'衡⽔市',130000 unionselect 16,140100,'太原市',140000 unionselect 17,140200,'⼤同市',140000 unionselect 18,140300,'阳泉市',140000 unionselect 19,140400,'长治市',140000 unionselect 20,140500,'晋城市',140000 unionselect 21,140600,'朔州市',140000 unionselect 22,140700,'晋中市',140000 unionselect 23,140800,'运城市',140000 unionselect 24,140900,'忻州市',140000 unionselect 25,141000,'临汾市',140000 unionselect 26,141100,'吕梁市',140000INSERT city (id,cityID,city,fatherID)select 27,150100,'呼和浩特市',150000 union select 28,150200,'包头市',150000 unionselect 29,150300,'乌海市',150000 unionselect 30,150400,'⾚峰市',150000 unionselect 31,150500,'通辽市',150000 unionselect 32,150600,'鄂尔多斯市',150000 union select 33,150700,'呼伦贝尔市',150000 union select 34,150800,'巴彦淖尔市',150000 union select 35,150900,'乌兰察布市',150000 union select 36,152200,'兴安盟',150000 unionselect 37,152500,'锡林郭勒盟',150000 union select 38,152900,'阿拉善盟',150000 unionselect 39,210100,'沈阳市',210000 unionselect 40,210200,'⼤连市',210000 unionselect 41,210300,'鞍⼭市',210000 unionselect 42,210400,'抚顺市',210000 unionselect 43,210500,'本溪市',210000 unionselect 44,210600,'丹东市',210000 unionselect 45,210700,'锦州市',210000 unionselect 46,210800,'营⼝市',210000 unionselect 47,210900,'⾩新市',210000 unionselect 48,211000,'辽阳市',210000 unionselect 49,211100,'盘锦市',210000 unionselect 50,211200,'铁岭市',210000 unionselect 51,211300,'朝阳市',210000 unionselect 52,211400,'葫芦岛市',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 74,232700,'⼤兴安岭地区',230000 union select 75,310100,'市辖区',310000 union select 76,310200,'县',310000 unionselect 77,320100,'南京市',320000 union select 78,320200,'⽆锡市',320000 union select 79,320300,'徐州市',320000 union select 80,320400,'常州市',320000 union select 81,320500,'苏州市',320000 union select 82,320600,'南通市',320000 union select 83,320700,'连云港市',320000 union select 84,320800,'淮安市',320000 union select 85,320900,'盐城市',320000 union select 86,321000,'扬州市',320000 union select 87,321100,'镇江市',320000 union select 88,321200,'泰州市',320000 union select 89,321300,'宿迁市',320000 union select 90,330100,'杭州市',330000 union select 91,330200,'宁波市',330000 union select 92,330300,'温州市',330000 union select 93,330400,'嘉兴市',330000 union select 94,330500,'湖州市',330000 union select 95,330600,'绍兴市',330000 union select 96,330700,'⾦华市',330000 union select 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,city,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 union select 138,370100,'济南市',370000 union select 139,370200,'青岛市',370000 unionselect 148,371100,'⽇照市',370000 unionselect 149,371200,'莱芜市',370000 unionselect 150,371300,'临沂市',370000 unionselect 151,371400,'德州市',370000 unionselect 152,371500,'聊城市',370000 unionselect 153,371600,'滨州市',370000 unionselect 154,371700,'荷泽市',370000 unionselect 155,410100,'郑州市',410000 unionselect 156,410200,'开封市',410000 unionselect 157,410300,'洛阳市',410000 unionselect 158,410400,'平顶⼭市',410000 unionselect 159,410500,'安阳市',410000 unionselect 160,410600,'鹤壁市',410000 unionselect 161,410700,'新乡市',410000 unionselect 162,410800,'焦作市',410000 unionselect 163,410900,'濮阳市',410000 unionselect 164,411000,'许昌市',410000 unionselect 165,411100,'漯河市',410000 unionselect 166,411200,'三门峡市',410000 unionselect 167,411300,'南阳市',410000 unionselect 168,411400,'商丘市',410000 unionselect 169,411500,'信阳市',410000 unionselect 170,411600,'周⼝市',410000 unionselect 171,411700,'驻马店市',410000INSERT city (id,cityID,city,fatherID)select 172,420100,'武汉市',420000 unionselect 173,420200,'黄⽯市',420000 unionselect 174,420300,'⼗堰市',420000 unionselect 175,420500,'宜昌市',420000 unionselect 176,420600,'襄樊市',420000 unionselect 177,420700,'鄂州市',420000 unionselect 178,420800,'荆门市',420000 unionselect 179,420900,'孝感市',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 220,445300,'云浮市',440000 unionselect 221,450100,'南宁市',450000 unionselect 222,450200,'柳州市',450000 unionselect 223,450300,'桂林市',450000 unionselect 224,450400,'梧州市',450000 unionselect 225,450500,'北海市',450000INSERT city (id,cityID,city,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 unionselect 261,513400,'凉⼭彝族⾃治州',510000 unionselect 262,520100,'贵阳市',520000 unionselect 263,520200,'六盘⽔市',520000INSERT city (id,cityID,city,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 unionselect 292,542500,'阿⾥地区',540000 unionselect 293,542600,'林芝地区',540000INSERT city (id,cityID,city,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,city,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,city,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 unionselect 345,659000,'省直辖⾏政单位',650000INSERT INTO area (id,areaID,area,fatherID)select 1,110101,'东城区',110100 unionselect 2,110102,'西城区',110100 unionselect 12,110113,'顺义区',110100 union select 13,110114,'昌平区',110100 union select 14,110115,'⼤兴区',110100 union select 15,110116,'怀柔区',110100 union select 16,110117,'平⾕区',110100 union select 17,110228,'密云县',110200 union select 18,110229,'延庆县',110200 union select 19,120101,'和平区',120100 union select 20,120102,'河东区',120100 union select 21,120103,'河西区',120100 union select 22,120104,'南开区',120100 union select 23,120105,'河北区',120100 union select 24,120106,'红桥区',120100 union select 25,120107,'塘沽区',120100 union select 26,120108,'汉沽区',120100 union select 27,120109,'⼤港区',120100 union select 28,120110,'东丽区',120100 union select 29,120111,'西青区',120100 union select 30,120112,'津南区',120100 union select 31,120113,'北⾠区',120100 union select 32,120114,'武清区',120100 union select 33,120115,'宝坻区',120100 union select 34,120221,'宁河县',120200 union select 35,120223,'静海县',120200 union select 36,120225,'蓟 县',120200 union select 37,130101,'市辖区',130100 union select 38,130102,'长安区',130100 union select 39,130103,'桥东区',130100 union select 40,130104,'桥西区',130100 union select 41,130105,'新华区',130100 union select 42,130107,'井陉矿区',130100 union select 43,130108,'裕华区',130100 union select 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 union select 74,130281,'遵化市',130200 union select 75,130283,'迁安市',130200 union select 76,130301,'市辖区',130300 union select 77,130302,'海港区',130300 unionselect 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,'平乡县',130500 union select 119,130533,'威 县',130500 union select 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 126,130603,'北市区',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 unionselect 162,130728,'怀安县',130700 unionselect 163,130729,'万全县',130700 unionselect 164,130730,'怀来县',130700 unionselect 165,130731,'涿⿅县',130700 unionselect 166,130732,'⾚城县',130700 unionselect 167,130733,'崇礼县',130700 unionselect 168,130801,'市辖区',130800 unionselect 169,130802,'双桥区',130800 unionselect 170,130803,'双滦区',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 214,131125,'安平县',131100 unionselect 215,131126,'故城县',131100 unionselect 216,131127,'景 县',131100 unionselect 217,131128,'⾩城县',131100 unionselect 218,131181,'冀州市',131100 unionselect 219,131182,'深州市',131100 unionselect 220,140101,'市辖区',140100 unionselect 221,140105,'⼩店区',140100 unionselect 222,140106,'迎泽区',140100 unionselect 223,140107,'杏花岭区',140100 unionselect 224,140108,'尖草坪区',140100 unionselect 225,140109,'万柏林区',140100 unionselect 226,140110,'晋源区',140100 unionselect 227,140121,'清徐县',140100 unionselect 228,140122,'阳曲县',140100 unionselect 233,140203,'矿 区',140200 union select 234,140211,'南郊区',140200 union select 235,140212,'新荣区',140200 union select 236,140221,'阳⾼县',140200 union select 237,140222,'天镇县',140200 union select 238,140223,'⼴灵县',140200 union select 239,140224,'灵丘县',140200 union select 240,140225,'浑源县',140200 union select 241,140226,'左云县',140200 union select 242,140227,'⼤同县',140200 union select 243,140301,'市辖区',140300 union select 244,140302,'城 区',140300 union select 245,140303,'矿 区',140300 union select 246,140311,'郊 区',140300 union select 247,140321,'平定县',140300 union select 248,140322,'盂 县',140300 union select 249,140401,'市辖区',140400 union select 250,140402,'城 区',140400 union select 251,140411,'郊 区',140400 union select 252,140421,'长治县',140400 union select 253,140423,'襄垣县',140400 union select 254,140424,'屯留县',140400 union select 255,140425,'平顺县',140400 union select 256,140426,'黎城县',140400 union select 257,140427,'壶关县',140400 union select 258,140428,'长⼦县',140400 union select 259,140429,'武乡县',140400 union select 260,140430,'沁 县',140400 union select 261,140431,'沁源县',140400 union select 262,140481,'潞城市',140400 union select 263,140501,'市辖区',140500 union select 264,140502,'城 区',140500 union select 265,140521,'沁⽔县',140500 union select 266,140522,'阳城县',140500 union select 267,140524,'陵川县',140500 union select 268,140525,'泽州县',140500 union select 269,140581,'⾼平市',140500 union select 270,140601,'市辖区',140600 union select 271,140602,'朔城区',140600 union select 272,140603,'平鲁区',140600 union select 273,140621,'⼭阴县',140600 union select 274,140622,'应 县',140600 union select 275,140623,'右⽟县',140600 union select 276,140624,'怀仁县',140600 union select 277,140701,'市辖区',140700 union select 278,140702,'榆次区',140700 union select 279,140721,'榆社县',140700 union select 280,140722,'左权县',140700 union select 281,140723,'和顺县',140700 union select 282,140724,'昔阳县',140700 union select 283,140725,'寿阳县',140700 union select 284,140726,'太⾕县',140700 union select 285,140727,'祁 县',140700 union select 286,140728,'平遥县',140700 union select 287,140729,'灵⽯县',140700 union select 288,140781,'介休市',140700 union select 289,140801,'市辖区',140800 union select 290,140802,'盐湖区',140800 union select 291,140821,'临猗县',140800 union select 292,140822,'万荣县',140800 union select 293,140823,'闻喜县',140800 union select 294,140824,'稷⼭县',140800 union select 295,140825,'新绛县',140800 union select 296,140826,'绛 县',140800 union select 297,140827,'垣曲县',140800 union select 298,140828,'夏 县',140800 union select 299,140829,'平陆县',140800 union select 300,140830,'芮城县',140800 union select 301,140881,'永济市',140800 union select 302,140882,'河津市',140800 union select 303,140901,'市辖区',140900 union。
省级别1110000北京市2120000天津市3130000河北省4140000山西省5150000内蒙古自治区6210000辽宁省7220000吉林省8230000黑龙江省9310000上海市10320000江苏省11330000浙江省12340000安徽省13350000福建省14360000江西省15370000山东省16410000河南省17420000湖北省18430000湖南省19440000广东省20450000广西壮族自治区21460000海南省22500000重庆市23510000四川省24520000贵州省25530000云南省26540000西藏自治区27610000陕西省28620000甘肃省29630000青海省30640000宁夏回族自治区31650000新疆维吾尔自治区32710000台湾省33810000香港特别行政区34820000澳门特别行政区地级1110100市辖区1100002110200县1100003120100市辖区1200004120200县1200005130100石家庄市1300006130200唐山市1300007130300秦皇岛市1300008130400邯郸市1300009130500邢台市13000010130600保定市13000011130700张家口市13000012130800承德市13000013130900沧州市13000014131000廊坊市13000015131100衡水市13000016140100太原市14000017140200大同市14000018140300阳泉市14000022140700晋中市140000 23140800运城市140000 24140900忻州市140000 25141000临汾市140000 26141100吕梁市140000 27150100呼和浩特市150000 28150200包头市150000 29150300乌海市150000 30150400赤峰市150000 31150500通辽市150000 32150600鄂尔多斯市150000 33150700呼伦贝尔市150000 34150800巴彦淖尔市150000 35150900乌兰察布市150000 36152200兴安盟150000 37152500锡林郭勒盟150000 38152900阿拉善盟150000 39210100沈阳市210000 40210200大连市210000 41210300鞍山市210000 42210400抚顺市210000 43210500本溪市210000 44210600丹东市210000 45210700锦州市210000 46210800营口市210000 47210900阜新市210000 48211000辽阳市210000 49211100盘锦市210000 50211200铁岭市210000 51211300朝阳市210000 52211400葫芦岛市210000 53220100长春市220000 54220200吉林市220000 55220300四平市220000 56220400辽源市220000 57220500通化市220000 58220600白山市220000 59220700松原市220000 60220800白城市220000220000 61222400延边朝鲜族自62230100哈尔滨市230000 63230200齐齐哈尔市230000 64230300鸡西市230000 65230400鹤岗市230000 66230500双鸭山市230000 67230600大庆市230000 68230700伊春市230000 69230800佳木斯市230000 70230900七台河市230000 71231000牡丹江市230000 72231100黑河市230000 73231200绥化市230000230000 74232700大兴安岭地区75310100市辖区310000 76310200县310000 77320100南京市32000081320500苏州市320000 82320600南通市320000 83320700连云港市320000 84320800淮安市320000 85320900盐城市320000 86321000扬州市320000 87321100镇江市320000 88321200泰州市320000 89321300宿迁市320000 90330100杭州市330000 91330200宁波市330000 92330300温州市330000 93330400嘉兴市330000 94330500湖州市330000 95330600绍兴市330000 96330700金华市330000 97330800衢州市330000 98330900舟山市330000 99331000台州市330000 100331100丽水市330000 101340100合肥市340000 102340200芜湖市340000 103340300蚌埠市340000 104340400淮南市340000 105340500马鞍山市340000 106340600淮北市340000 107340700铜陵市340000 108340800安庆市340000 109341000黄山市340000 110341100滁州市340000 111341200阜阳市340000 112341300宿州市340000 113341400巢湖市340000 114341500六安市340000 115341600亳州市340000 116341700池州市340000 117341800宣城市340000 118350100福州市350000 119350200厦门市350000 120350300莆田市350000 121350400三明市350000 122350500泉州市350000 123350600漳州市350000 124350700南平市350000 125350800龙岩市350000 126350900宁德市350000 127360100南昌市360000 128360200景德镇市360000 129360300萍乡市360000 130360400九江市360000 131360500新余市360000 132360600鹰潭市360000 133360700赣州市360000 134360800吉安市360000 135360900宜春市360000 136361000抚州市360000139370200青岛市370000 140370300淄博市370000 141370400枣庄市370000 142370500东营市370000 143370600烟台市370000 144370700潍坊市370000 145370800济宁市370000 146370900泰安市370000 147371000威海市370000 148371100日照市370000 149371200莱芜市370000 150371300临沂市370000 151371400德州市370000 152371500聊城市370000 153371600滨州市370000 154371700荷泽市370000 155410100郑州市410000 156410200开封市410000 157410300洛阳市410000 158410400平顶山市410000 159410500安阳市410000 160410600鹤壁市410000 161410700新乡市410000 162410800焦作市410000 163410900濮阳市410000 164411000许昌市410000 165411100漯河市410000 166411200三门峡市410000 167411300南阳市410000 168411400商丘市410000 169411500信阳市410000 170411600周口市410000 171411700驻马店市410000 172420100武汉市420000 173420200黄石市420000 174420300十堰市420000 175420500宜昌市420000 176420600襄樊市420000 177420700鄂州市420000 178420800荆门市420000 179420900孝感市420000 180421000荆州市420000 181421100黄冈市420000 182421200咸宁市420000 183421300随州市420000 184422800恩施土家族苗420000420000 185429000省直辖行政单186430100长沙市430000 187430200株洲市430000 188430300湘潭市430000 189430400衡阳市430000 190430500邵阳市430000 191430600岳阳市430000 192430700常德市430000 193430800张家界市430000 194430900益阳市430000 195431000郴州市430000198431300娄底市430000430000 199433100湘西土家族苗200440100广州市440000 201440200韶关市440000 202440300深圳市440000 203440400珠海市440000 204440500汕头市440000 205440600佛山市440000 206440700江门市440000 207440800湛江市440000 208440900茂名市440000 209441200肇庆市440000 210441300惠州市440000 211441400梅州市440000 212441500汕尾市440000 213441600河源市440000 214441700阳江市440000 215441800清远市440000 216441900东莞市440000 217442000中山市440000 218445100潮州市440000 219445200揭阳市440000 220445300云浮市440000 221450100南宁市450000 222450200柳州市450000 223450300桂林市450000 224450400梧州市450000 225450500北海市450000 226450600防城港市450000 227450700钦州市450000 228450800贵港市450000 229450900玉林市450000 230451000百色市450000 231451100贺州市450000 232451200河池市450000 233451300来宾市450000 234451400崇左市450000 235460100海口市460000 236460200三亚市460000460000 237469000省直辖县级行238500100市辖区500000 239500200县500000 240500300市500000 241510100成都市510000 242510300自贡市510000 243510400攀枝花市510000 244510500泸州市510000 245510600德阳市510000 246510700绵阳市510000 247510800广元市510000 248510900遂宁市510000 249511000内江市510000 250511100乐山市510000 251511300南充市510000 252511400眉山市510000 253511500宜宾市510000 254511600广安市510000257511900巴中市510000 258512000资阳市510000510000 259513200阿坝藏族羌族510000 260513300甘孜藏族自治510000 261513400凉山彝族自治262520100贵阳市520000 263520200六盘水市520000 264520300遵义市520000 265520400安顺市520000 266522200铜仁地区520000 267522300黔西南布依族520000 268522400毕节地区520000520000 269522600黔东南苗族侗270522700黔南布依族苗520000 271530100昆明市530000 272530300曲靖市530000 273530400玉溪市530000 274530500保山市530000 275530600昭通市530000 276530700丽江市530000 277530800思茅市530000 278530900临沧市530000530000 279532300楚雄彝族自治530000 280532500红河哈尼族彝530000 281532600文山壮族苗族530000 282532800西双版纳傣族530000 283532900大理白族自治530000 284533100德宏傣族景颇530000 285533300怒江傈僳族自530000 286533400迪庆藏族自治287540100拉萨市540000 288542100昌都地区540000 289542200山南地区540000 290542300日喀则地区540000 291542400那曲地区540000 292542500阿里地区540000 293542600林芝地区540000 294610100西安市610000 295610200铜川市610000 296610300宝鸡市610000 297610400咸阳市610000 298610500渭南市610000 299610600延安市610000 300610700汉中市610000 301610800榆林市610000 302610900安康市610000 303611000商洛市610000 304620100兰州市620000 305620200嘉峪关市620000 306620300金昌市620000 307620400白银市620000 308620500天水市620000 309620600武威市620000 310620700张掖市620000 311620800平凉市620000 312620900酒泉市620000 313621000庆阳市620000316622900临夏回族自治620000620000 317623000甘南藏族自治318630100西宁市630000319632100海东地区630000630000 320632200海北藏族自治630000 321632300黄南藏族自治630000 322632500海南藏族自治630000 323632600果洛藏族自治630000 324632700玉树藏族自治630000 325632800海西蒙古族藏326640100银川市640000327640200石嘴山市640000328640300吴忠市640000329640400固原市640000330640500中卫市640000331650100乌鲁木齐市650000332650200克拉玛依市650000333652100吐鲁番地区650000334652200哈密地区650000650000 335652300昌吉回族自治650000 336652700博尔塔拉蒙古650000 337652800巴音郭楞蒙古338652900阿克苏地区650000339653000克孜勒苏柯尔650000 340653100喀什地区650000341653200和田地区650000342654000伊犁哈萨克自650000 343654200塔城地区650000344654300阿勒泰地区650000345659000省直辖行政单650000县1110101东城区1101002110102西城区1101003110103崇文区1101004110104宣武区1101005110105朝阳区1101006110106丰台区1101007110107石景山区1101008110108海淀区1101009110109门头沟区11010010110111房山区11010011110112通州区11010012110113顺义区11010013110114昌平区11010014110115大兴区11010015110116怀柔区11010016110117平谷区11010017110228密云县11020018110229延庆县11020019120101和平区12010020120102河东区12010021120103河西区12010022120104南开区12010025120107塘沽区120100 26120108汉沽区120100 27120109大港区120100 28120110东丽区120100 29120111西青区120100 30120112津南区120100 31120113北辰区120100 32120114武清区120100 33120115宝坻区120100 34120221宁河县120200 35120223静海县120200 36120225蓟 县120200 37130101市辖区130100 38130102长安区130100 39130103桥东区130100 40130104桥西区130100 41130105新华区130100 42130107井陉矿区130100 43130108裕华区130100 44130121井陉县130100 45130123正定县130100 46130124栾城县130100 47130125行唐县130100 48130126灵寿县130100 49130127高邑县130100 50130128深泽县130100 51130129赞皇县130100 52130130无极县130100 53130131平山县130100 54130132元氏县130100 55130133赵 县130100 56130181辛集市130100 57130182藁城市130100 58130183晋州市130100 59130184新乐市130100 60130185鹿泉市130100 61130201市辖区130200 62130202路南区130200 63130203路北区130200 64130204古冶区130200 65130205开平区130200 66130207丰南区130200 67130208丰润区130200 68130223滦 县130200 69130224滦南县130200 70130225乐亭县130200 71130227迁西县130200 72130229玉田县130200 73130230唐海县130200 74130281遵化市130200 75130283迁安市130200 76130301市辖区130300 77130302海港区130300 78130303山海关区130300 79130304北戴河区130300 80130321青龙满族自治130300 81130322昌黎县13030084130401市辖区130400 85130402邯山区130400 86130403丛台区130400 87130404复兴区130400 88130406峰峰矿区130400 89130421邯郸县130400 90130423临漳县130400 91130424成安县130400 92130425大名县130400 93130426涉 县130400 94130427磁 县130400 95130428肥乡县130400 96130429永年县130400 97130430邱 县130400 98130431鸡泽县130400 99130432广平县130400 100130433馆陶县130400 101130434魏 县130400 102130435曲周县130400 103130481武安市130400 104130501市辖区130500 105130502桥东区130500 106130503桥西区130500 107130521邢台县130500 108130522临城县130500 109130523内丘县130500 110130524柏乡县130500 111130525隆尧县130500 112130526任 县130500 113130527南和县130500 114130528宁晋县130500 115130529巨鹿县130500 116130530新河县130500 117130531广宗县130500 118130532平乡县130500 119130533威 县130500 120130534清河县130500 121130535临西县130500 122130581南宫市130500 123130582沙河市130500 124130601市辖区130600 125130602新市区130600 126130603北市区130600 127130604南市区130600 128130621满城县130600 129130622清苑县130600 130130623涞水县130600 131130624阜平县130600 132130625徐水县130600 133130626定兴县130600 134130627唐 县130600 135130628高阳县130600 136130629容城县130600 137130630涞源县130600 138130631望都县130600 139130632安新县130600 140130633易 县130600143130636顺平县130600 144130637博野县130600 145130638雄 县130600 146130681涿州市130600 147130682定州市130600 148130683安国市130600 149130684高碑店市130600 150130701市辖区130700 151130702桥东区130700 152130703桥西区130700 153130705宣化区130700 154130706下花园区130700 155130721宣化县130700 156130722张北县130700 157130723康保县130700 158130724沽源县130700 159130725尚义县130700 160130726蔚 县130700 161130727阳原县130700 162130728怀安县130700 163130729万全县130700 164130730怀来县130700 165130731涿鹿县130700 166130732赤城县130700 167130733崇礼县130700 168130801市辖区130800 169130802双桥区130800 170130803双滦区130800130800 171130804鹰手营子矿区172130821承德县130800 173130822兴隆县130800 174130823平泉县130800 175130824滦平县130800 176130825隆化县130800130800 177130826丰宁满族自治130800 178130827宽城满族自治130800 179130828围场满族蒙古180130901市辖区130900 181130902新华区130900 182130903运河区130900 183130921沧 县130900 184130922青 县130900 185130923东光县130900 186130924海兴县130900 187130925盐山县130900 188130926肃宁县130900 189130927南皮县130900 190130928吴桥县130900 191130929献 县130900130900 192130930孟村回族自治193130981泊头市130900 194130982任丘市130900 195130983黄骅市130900 196130984河间市130900 197131001市辖区131000 198131002安次区131000 199131003广阳区131000202131024香河县131000 203131025大城县131000 204131026文安县131000 205131028大厂回族自治131000 206131081霸州市131000 207131082三河市131000 208131101市辖区131100 209131102桃城区131100 210131121枣强县131100 211131122武邑县131100 212131123武强县131100 213131124饶阳县131100 214131125安平县131100 215131126故城县131100 216131127景 县131100 217131128阜城县131100 218131181冀州市131100 219131182深州市131100 220140101市辖区140100 221140105小店区140100 222140106迎泽区140100 223140107杏花岭区140100 224140108尖草坪区140100 225140109万柏林区140100 226140110晋源区140100 227140121清徐县140100 228140122阳曲县140100 229140123娄烦县140100 230140181古交市140100 231140201市辖区140200 232140202城 区140200 233140203矿 区140200 234140211南郊区140200 235140212新荣区140200 236140221阳高县140200 237140222天镇县140200 238140223广灵县140200 239140224灵丘县140200 240140225浑源县140200 241140226左云县140200 242140227大同县140200 243140301市辖区140300 244140302城 区140300 245140303矿 区140300 246140311郊 区140300 247140321平定县140300 248140322盂 县140300 249140401市辖区140400 250140402城 区140400 251140411郊 区140400 252140421长治县140400 253140423襄垣县140400 254140424屯留县140400 255140425平顺县140400 256140426黎城县140400 257140427壶关县140400 258140428长子县140400 259140429武乡县140400262140481潞城市140400 263140501市辖区140500 264140502城 区140500 265140521沁水县140500 266140522阳城县140500 267140524陵川县140500 268140525泽州县140500 269140581高平市140500 270140601市辖区140600 271140602朔城区140600 272140603平鲁区140600 273140621山阴县140600 274140622应 县140600 275140623右玉县140600 276140624怀仁县140600 277140701市辖区140700 278140702榆次区140700 279140721榆社县140700 280140722左权县140700 281140723和顺县140700 282140724昔阳县140700 283140725寿阳县140700 284140726太谷县140700 285140727祁 县140700 286140728平遥县140700 287140729灵石县140700 288140781介休市140700 289140801市辖区140800 290140802盐湖区140800 291140821临猗县140800 292140822万荣县140800 293140823闻喜县140800 294140824稷山县140800 295140825新绛县140800 296140826绛 县140800 297140827垣曲县140800 298140828夏 县140800 299140829平陆县140800 300140830芮城县140800 301140881永济市140800 302140882河津市140800 303140901市辖区140900 304140902忻府区140900 305140921定襄县140900 306140922五台县140900 307140923代 县140900 308140924繁峙县140900 309140925宁武县140900 310140926静乐县140900 311140927神池县140900 312140928五寨县140900 313140929岢岚县140900 314140930河曲县140900 315140931保德县140900 316140932偏关县140900 317140981原平市140900 318141001市辖区141000321141022翼城县141000 322141023襄汾县141000 323141024洪洞县141000 324141025古 县141000 325141026安泽县141000 326141027浮山县141000 327141028吉 县141000 328141029乡宁县141000 329141030大宁县141000 330141031隰 县141000 331141032永和县141000 332141033蒲 县141000 333141034汾西县141000 334141081侯马市141000 335141082霍州市141000 336141101市辖区141100 337141102离石区141100 338141121文水县141100 339141122交城县141100 340141123兴 县141100 341141124临 县141100 342141125柳林县141100 343141126石楼县141100 344141127岚 县141100 345141128方山县141100 346141129中阳县141100 347141130交口县141100 348141181孝义市141100 349141182汾阳市141100 350150101市辖区150100 351150102新城区150100 352150103回民区150100 353150104玉泉区150100 354150105赛罕区150100 355150121土默特左旗150100 356150122托克托县150100 357150123和林格尔县150100 358150124清水河县150100 359150125武川县150100 360150201市辖区150200 361150202东河区150200 362150203昆都仑区150200 363150204青山区150200 364150205石拐区150200 365150206白云矿区150200 366150207九原区150200 367150221土默特右旗150200 368150222固阳县150200150200 369150223达尔罕茂明安370150301市辖区150300 371150302海勃湾区150300 372150303海南区150300 373150304乌达区150300 374150401市辖区150400 375150402红山区150400 376150403元宝山区150400 377150404松山区150400379150422巴林左旗150400 380150423巴林右旗150400 381150424林西县150400 382150425克什克腾旗150400 383150426翁牛特旗150400 384150428喀喇沁旗150400 385150429宁城县150400 386150430敖汉旗150400 387150501市辖区150500 388150502科尔沁区150500150500 389150521科尔沁左翼中150500 390150522科尔沁左翼后391150523开鲁县150500 392150524库伦旗150500 393150525奈曼旗150500 394150526扎鲁特旗150500 395150581霍林郭勒市150500 396150602东胜区150600 397150621达拉特旗150600 398150622准格尔旗150600 399150623鄂托克前旗150600 400150624鄂托克旗150600 401150625杭锦旗150600 402150626乌审旗150600 403150627伊金霍洛旗150600 404150701市辖区150700 405150702海拉尔区150700 406150721阿荣旗150700150700 407150722莫力达瓦达斡150700 408150723鄂伦春自治旗150700 409150724鄂温克族自治410150725陈巴尔虎旗150700 411150726新巴尔虎左旗150700150700 412150727新巴尔虎右旗413150781满洲里市150700 414150782牙克石市150700 415150783扎兰屯市150700 416150784额尔古纳市150700 417150785根河市150700 418150801市辖区150800 419150802临河区150800 420150821五原县150800 421150822磴口县150800 422150823乌拉特前旗150800 423150824乌拉特中旗150800 424150825乌拉特后旗150800 425150826杭锦后旗150800 426150901市辖区150900 427150902集宁区150900 428150921卓资县150900 429150922化德县150900 430150923商都县150900 431150924兴和县150900 432150925凉城县150900150900 433150926察哈尔右翼前150900 434150927察哈尔右翼中435150928察哈尔右翼后150900 436150929四子王旗150900438152201乌兰浩特市152200 439152202阿尔山市152200152200 440152221科尔沁右翼前152200 441152222科尔沁右翼中442152223扎赉特旗152200 443152224突泉县152200 444152501二连浩特市152500 445152502锡林浩特市152500 446152522阿巴嘎旗152500 447152523苏尼特左旗152500 448152524苏尼特右旗152500152500 449152525东乌珠穆沁旗152500 450152526西乌珠穆沁旗451152527太仆寺旗152500 452152528镶黄旗152500 453152529正镶白旗152500 454152530正蓝旗152500 455152531多伦县152500 456152921阿拉善左旗152900 457152922阿拉善右旗152900 458152923额济纳旗152900 459210101市辖区210100 460210102和平区210100 461210103沈河区210100 462210104大东区210100 463210105皇姑区210100 464210106铁西区210100 465210111苏家屯区210100 466210112东陵区210100 467210113新城子区210100 468210114于洪区210100 469210122辽中县210100 470210123康平县210100 471210124法库县210100 472210181新民市210100 473210201市辖区210200 474210202中山区210200 475210203西岗区210200 476210204沙河口区210200 477210211甘井子区210200 478210212旅顺口区210200 479210213金州区210200 480210224长海县210200 481210281瓦房店市210200 482210282普兰店市210200 483210283庄河市210200 484210301市辖区210300 485210302铁东区210300 486210303铁西区210300 487210304立山区210300 488210311千山区210300 489210321台安县210300 490210323岫岩满族自治210300 491210381海城市210300 492210401市辖区210400 493210402新抚区210400 494210403东洲区210400 495210404望花区210400497210421抚顺县210400210400 498210422新宾满族自治210400 499210423清原满族自治500210501市辖区210500 501210502平山区210500 502210503溪湖区210500 503210504明山区210500 504210505南芬区210500210500 505210521本溪满族自治210500 506210522桓仁满族自治507210601市辖区210600 508210602元宝区210600 509210603振兴区210600 510210604振安区210600210600 511210624宽甸满族自治512210681东港市210600 513210682凤城市210600 514210701市辖区210700 515210702古塔区210700 516210703凌河区210700 517210711太和区210700 518210726黑山县210700 519210727义 县210700 520210781凌海市210700 521210782北宁市210700 522210801市辖区210800 523210802站前区210800 524210803西市区210800 525210804鲅鱼圈区210800 526210811老边区210800 527210881盖州市210800 528210882大石桥市210800 529210901市辖区210900 530210902海州区210900 531210903新邱区210900 532210904太平区210900 533210905清河门区210900 534210911细河区210900210900 535210921阜新蒙古族自536210922彰武县210900 537211001市辖区211000 538211002白塔区211000 539211003文圣区211000 540211004宏伟区211000 541211005弓长岭区211000 542211011太子河区211000 543211021辽阳县211000 544211081灯塔市211000 545211101市辖区211100 546211102双台子区211100 547211103兴隆台区211100 548211121大洼县211100 549211122盘山县211100 550211201市辖区211200 551211202银州区211200 552211204清河区211200 553211221铁岭县211200 554211223西丰县211200556211281调兵山市211200 557211282开原市211200 558211301市辖区211300 559211302双塔区211300 560211303龙城区211300 561211321朝阳县211300 562211322建平县211300 563211324喀喇沁左翼蒙211300 564211381北票市211300 565211382凌源市211300 566211401市辖区211400 567211402连山区211400 568211403龙港区211400 569211404南票区211400 570211421绥中县211400 571211422建昌县211400 572211481兴城市211400 573220101市辖区220100 574220102南关区220100 575220103宽城区220100 576220104朝阳区220100 577220105二道区220100 578220106绿园区220100 579220112双阳区220100 580220122农安县220100 581220181九台市220100 582220182榆树市220100 583220183德惠市220100 584220201市辖区220200 585220202昌邑区220200 586220203龙潭区220200 587220204船营区220200 588220211丰满区220200 589220221永吉县220200 590220281蛟河市220200 591220282桦甸市220200 592220283舒兰市220200 593220284磐石市220200 594220301市辖区220300 595220302铁西区220300 596220303铁东区220300 597220322梨树县220300220300 598220323伊通满族自治599220381公主岭市220300 600220382双辽市220300 601220401市辖区220400 602220402龙山区220400 603220403西安区220400 604220421东丰县220400 605220422东辽县220400 606220501市辖区220500 607220502东昌区220500 608220503二道江区220500 609220521通化县220500 610220523辉南县220500 611220524柳河县220500 612220581梅河口市220500 613220582集安市220500615220602八道江区220600 616220621抚松县220600 617220622靖宇县220600 618220623长白朝鲜族自220600 619220625江源县220600 620220681临江市220600 621220701市辖区220700 622220702宁江区220700220700 623220721前郭尔罗斯蒙624220722长岭县220700 625220723乾安县220700 626220724扶余县220700 627220801市辖区220800 628220802洮北区220800 629220821镇赉县220800 630220822通榆县220800 631220881洮南市220800 632220882大安市220800 633222401延吉市222400 634222402图们市222400 635222403敦化市222400 636222404珲春市222400 637222405龙井市222400 638222406和龙市222400 639222424汪清县222400 640222426安图县222400 641230101市辖区230100 642230102道里区230100 643230103南岗区230100 644230104道外区230100 645230106香坊区230100 646230107动力区230100 647230108平房区230100 648230109松北区230100 649230111呼兰区230100 650230123依兰县230100 651230124方正县230100 652230125宾 县230100 653230126巴彦县230100 654230127木兰县230100 655230128通河县230100 656230129延寿县230100 657230181阿城市230100 658230182双城市230100 659230183尚志市230100 660230184五常市230100 661230201市辖区230200 662230202龙沙区230200 663230203建华区230200 664230204铁锋区230200 665230205昂昂溪区230200 666230206富拉尔基区230200 667230207碾子山区230200230200 668230208梅里斯达斡尔669230221龙江县230200 670230223依安县230200 671230224泰来县230200 672230225甘南县230200674230229克山县230200 675230230克东县230200 676230231拜泉县230200 677230281讷河市230200 678230301市辖区230300 679230302鸡冠区230300 680230303恒山区230300 681230304滴道区230300 682230305梨树区230300 683230306城子河区230300 684230307麻山区230300 685230321鸡东县230300 686230381虎林市230300 687230382密山市230300 688230401市辖区230400 689230402向阳区230400 690230403工农区230400 691230404南山区230400 692230405兴安区230400 693230406东山区230400 694230407兴山区230400 695230421萝北县230400 696230422绥滨县230400 697230501市辖区230500 698230502尖山区230500 699230503岭东区230500 700230505四方台区230500 701230506宝山区230500 702230521集贤县230500 703230522友谊县230500 704230523宝清县230500 705230524饶河县230500 706230601市辖区230600 707230602萨尔图区230600 708230603龙凤区230600 709230604让胡路区230600 710230605红岗区230600 711230606大同区230600 712230621肇州县230600 713230622肇源县230600 714230623林甸县230600 715230624杜尔伯特蒙古230600 716230701市辖区230700 717230702伊春区230700 718230703南岔区230700 719230704友好区230700 720230705西林区230700 721230706翠峦区230700 722230707新青区230700 723230708美溪区230700 724230709金山屯区230700 725230710五营区230700 726230711乌马河区230700 727230712汤旺河区230700 728230713带岭区230700 729230714乌伊岭区230700 730230715红星区230700 731230716上甘岭区230700733230781铁力市230700 734230801市辖区230800 735230802永红区230800 736230803向阳区230800 737230804前进区230800 738230805东风区230800 739230811郊 区230800 740230822桦南县230800 741230826桦川县230800 742230828汤原县230800 743230833抚远县230800 744230881同江市230800 745230882富锦市230800 746230901市辖区230900 747230902新兴区230900 748230903桃山区230900 749230904茄子河区230900 750230921勃利县230900 751231001市辖区231000 752231002东安区231000 753231003阳明区231000 754231004爱民区231000 755231005西安区231000 756231024东宁县231000 757231025林口县231000 758231081绥芬河市231000 759231083海林市231000 760231084宁安市231000 761231085穆棱市231000 762231101市辖区231100 763231102爱辉区231100 764231121嫩江县231100 765231123逊克县231100 766231124孙吴县231100 767231181北安市231100 768231182五大连池市231100 769231201市辖区231200 770231202北林区231200 771231221望奎县231200 772231222兰西县231200 773231223青冈县231200 774231224庆安县231200 775231225明水县231200 776231226绥棱县231200 777231281安达市231200 778231282肇东市231200 779231283海伦市231200 780232721呼玛县232700 781232722塔河县232700 782232723漠河县232700 783310101黄浦区310100 784310103卢湾区310100 785310104徐汇区310100 786310105长宁区310100 787310106静安区310100 788310107普陀区310100 789310108闸北区310100 790310109虹口区310100792310112闵行区310100 793310113宝山区310100 794310114嘉定区310100 795310115浦东新区310100 796310116金山区310100 797310117松江区310100 798310118青浦区310100 799310119南汇区310100 800310120奉贤区310100 801310230崇明县310200 802320101市辖区320100 803320102玄武区320100 804320103白下区320100 805320104秦淮区320100 806320105建邺区320100 807320106鼓楼区320100 808320107下关区320100 809320111浦口区320100 810320113栖霞区320100 811320114雨花台区320100 812320115江宁区320100 813320116六合区320100 814320124溧水县320100 815320125高淳县320100 816320201市辖区320200 817320202崇安区320200 818320203南长区320200 819320204北塘区320200 820320205锡山区320200 821320206惠山区320200 822320211滨湖区320200 823320281江阴市320200 824320282宜兴市320200 825320301市辖区320300 826320302鼓楼区320300 827320303云龙区320300 828320304九里区320300 829320305贾汪区320300 830320311泉山区320300 831320321丰 县320300 832320322沛 县320300 833320323铜山县320300 834320324睢宁县320300 835320381新沂市320300 836320382邳州市320300 837320401市辖区320400 838320402天宁区320400 839320404钟楼区320400 840320405戚墅堰区320400 841320411新北区320400 842320412武进区320400 843320481溧阳市320400 844320482金坛市320400 845320501市辖区320500 846320502沧浪区320500 847320503平江区320500 848320504金阊区320500 849320505虎丘区320500 850320506吴中区320500851320507相城区320500 852320581常熟市320500 853320582张家港市320500 854320583昆山市320500 855320584吴江市320500 856320585太仓市320500 857320601市辖区320600 858320602崇川区320600 859320611港闸区320600 860320621海安县320600 861320623如东县320600 862320681启东市320600 863320682如皋市320600 864320683通州市320600 865320684海门市320600 866320701市辖区320700 867320703连云区320700 868320705新浦区320700 869320706海州区320700 870320721赣榆县320700 871320722东海县320700 872320723灌云县320700 873320724灌南县320700 874320801市辖区320800 875320802清河区320800 876320803楚州区320800 877320804淮阴区320800 878320811清浦区320800 879320826涟水县320800 880320829洪泽县320800 881320830盱眙县320800 882320831金湖县320800 883320901市辖区320900 884320902亭湖区320900 885320903盐都区320900 886320921响水县320900 887320922滨海县320900 888320923阜宁县320900 889320924射阳县320900 890320925建湖县320900 891320981东台市320900 892320982大丰市320900 893321001市辖区321000 894321002广陵区321000 895321003邗江区321000 896321011郊 区321000 897321023宝应县321000 898321081仪征市321000 899321084高邮市321000 900321088江都市321000 901321101市辖区321100 902321102京口区321100 903321111润州区321100 904321112丹徒区321100 905321181丹阳市321100 906321182扬中市321100 907321183句容市321100 908321201市辖区321200 909321202海陵区321200910321203高港区321200 911321281兴化市321200 912321282靖江市321200 913321283泰兴市321200 914321284姜堰市321200 915321301市辖区321300 916321302宿城区321300 917321311宿豫区321300 918321322沭阳县321300 919321323泗阳县321300 920321324泗洪县321300 921330101市辖区330100 922330102上城区330100 923330103下城区330100 924330104江干区330100 925330105拱墅区330100 926330106西湖区330100 927330108滨江区330100 928330109萧山区330100 929330110余杭区330100 930330122桐庐县330100 931330127淳安县330100 932330182建德市330100 933330183富阳市330100 934330185临安市330100 935330201市辖区330200 936330203海曙区330200 937330204江东区330200 938330205江北区330200 939330206北仑区330200 940330211镇海区330200 941330212鄞州区330200 942330225象山县330200 943330226宁海县330200 944330281余姚市330200 945330282慈溪市330200 946330283奉化市330200 947330301市辖区330300 948330302鹿城区330300 949330303龙湾区330300 950330304瓯海区330300 951330322洞头县330300 952330324永嘉县330300 953330326平阳县330300 954330327苍南县330300 955330328文成县330300 956330329泰顺县330300 957330381瑞安市330300 958330382乐清市330300 959330401市辖区330400 960330402秀城区330400 961330411秀洲区330400 962330421嘉善县330400 963330424海盐县330400 964330481海宁市330400 965330482平湖市330400 966330483桐乡市330400 967330501市辖区330500 968330502吴兴区330500969330503南浔区330500 970330521德清县330500 971330522长兴县330500 972330523安吉县330500 973330601市辖区330600 974330602越城区330600 975330621绍兴县330600 976330624新昌县330600 977330681诸暨市330600 978330682上虞市330600 979330683嵊州市330600 980330701市辖区330700 981330702婺城区330700 982330703金东区330700 983330723武义县330700 984330726浦江县330700 985330727磐安县330700 986330781兰溪市330700 987330782义乌市330700 988330783东阳市330700 989330784永康市330700 990330801市辖区330800 991330802柯城区330800 992330803衢江区330800 993330822常山县330800 994330824开化县330800 995330825龙游县330800 996330881江山市330800 997330901市辖区330900 998330902定海区330900 999330903普陀区330900 1000330921岱山县330900 1001330922嵊泗县330900 1002331001市辖区331000 1003331002椒江区331000 1004331003黄岩区331000 1005331004路桥区331000 1006331021玉环县331000 1007331022三门县331000 1008331023天台县331000 1009331024仙居县331000 1010331081温岭市331000 1011331082临海市331000 1012331101市辖区331100 1013331102莲都区331100 1014331121青田县331100 1015331122缙云县331100 1016331123遂昌县331100 1017331124松阳县331100 1018331125云和县331100 1019331126庆元县331100331100 1020331127景宁畲族自治1021331181龙泉市331100 1022340101市辖区340100 1023340102瑶海区340100 1024340103庐阳区340100 1025340104蜀山区340100 1026340111包河区340100 1027340121长丰县3401001028340122肥东县340100 1029340123肥西县340100 1030340201市辖区340200 1031340202镜湖区340200 1032340203马塘区340200 1033340204新芜区340200 1034340207鸠江区340200 1035340221芜湖县340200 1036340222繁昌县340200 1037340223南陵县340200 1038340301市辖区340300 1039340302龙子湖区340300 1040340303蚌山区340300 1041340304禹会区340300 1042340311淮上区340300 1043340321怀远县340300 1044340322五河县340300 1045340323固镇县340300 1046340401市辖区340400 1047340402大通区340400 1048340403田家庵区340400 1049340404谢家集区340400 1050340405八公山区340400 1051340406潘集区340400 1052340421凤台县340400 1053340501市辖区340500 1054340502金家庄区340500 1055340503花山区340500 1056340504雨山区340500 1057340521当涂县340500 1058340601市辖区340600 1059340602杜集区340600 1060340603相山区340600 1061340604烈山区340600 1062340621濉溪县340600 1063340701市辖区340700 1064340702铜官山区340700 1065340703狮子山区340700 1066340711郊 区340700 1067340721铜陵县340700 1068340801市辖区340800 1069340802迎江区340800 1070340803大观区340800 1071340811郊 区340800 1072340822怀宁县340800 1073340823枞阳县340800 1074340824潜山县340800 1075340825太湖县340800 1076340826宿松县340800 1077340827望江县340800 1078340828岳西县340800 1079340881桐城市340800 1080341001市辖区341000 1081341002屯溪区341000 1082341003黄山区341000 1083341004徽州区341000 1084341021歙 县341000 1085341022休宁县341000 1086341023黟 县3410001087341024祁门县341000 1088341101市辖区341100 1089341102琅琊区341100 1090341103南谯区341100 1091341122来安县341100 1092341124全椒县341100 1093341125定远县341100 1094341126凤阳县341100 1095341181天长市341100 1096341182明光市341100 1097341201市辖区341200 1098341202颍州区341200 1099341203颍东区341200 1100341204颍泉区341200 1101341221临泉县341200 1102341222太和县341200 1103341225阜南县341200 1104341226颍上县341200 1105341282界首市341200 1106341301市辖区341300 1107341302墉桥区341300 1108341321砀山县341300 1109341322萧 县341300 1110341323灵璧县341300 1111341324泗 县341300 1112341401市辖区341400 1113341402居巢区341400 1114341421庐江县341400 1115341422无为县341400 1116341423含山县341400 1117341424和 县341400 1118341501市辖区341500 1119341502金安区341500 1120341503裕安区341500 1121341521寿 县341500 1122341522霍邱县341500 1123341523舒城县341500 1124341524金寨县341500 1125341525霍山县341500 1126341601市辖区341600 1127341602谯城区341600 1128341621涡阳县341600 1129341622蒙城县341600 1130341623利辛县341600 1131341701市辖区341700 1132341702贵池区341700 1133341721东至县341700 1134341722石台县341700 1135341723青阳县341700 1136341801市辖区341800 1137341802宣州区341800 1138341821郎溪县341800 1139341822广德县341800 1140341823泾 县341800 1141341824绩溪县341800 1142341825旌德县341800 1143341881宁国市341800 1144350101市辖区350100 1145350102鼓楼区350100。
全国省份城市表（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-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');。
中国省市区三级数据库表-MysqlCREATE 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;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 (17,'110228','密云县','110200'); 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 (61,'130201','市辖区','130200'); 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 (105,'130502','桥东区','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 (149,'130684','高碑店市','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 (193,'130981','泊头市','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 (237,'140222','天镇县','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 (281,'140723','和顺县','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 VALUE。
全国省市县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');。
DROP TABLE IF EXISTS `province`;CREATE TABLE `province` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(50) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;-- ------------------------------ Records of province-- ----------------------------INSERT INTO `province` VALUES ('1', '北京市');INSERT INTO `province` VALUES ('2', '天津市');INSERT INTO `province` VALUES ('3', '上海市');INSERT INTO `province` VALUES ('4', '重庆市');INSERT INTO `province` VALUES ('5', '河北省');INSERT INTO `province` VALUES ('6', '山西省');INSERT INTO `province` VALUES ('7', '台湾省');INSERT INTO `province` VALUES ('8', '辽宁省');INSERT INTO `province` VALUES ('9', '吉林省');INSERT INTO `province` VALUES ('10', '黑龙江省');INSERT INTO `province` VALUES ('11', '江苏省');INSERT INTO `province` VALUES ('12', '浙江省');INSERT INTO `province` VALUES ('13', '安徽省');INSERT INTO `province` VALUES ('14', '福建省');INSERT INTO `province` VALUES ('15', '江西省');INSERT INTO `province` VALUES ('16', '山东省');INSERT INTO `province` VALUES ('17', '河南省');INSERT INTO `province` VALUES ('18', '湖北省');INSERT INTO `province` VALUES ('19', '湖南省');INSERT INTO `province` VALUES ('20', '广东省');INSERT INTO `province` VALUES ('21', '甘肃省');INSERT INTO `province` VALUES ('22', '四川省');INSERT INTO `province` VALUES ('23', '贵州省');INSERT INTO `province` VALUES ('24', '海南省');INSERT INTO `province` VALUES ('25', '云南省');INSERT INTO `province` VALUES ('26', '青海省');INSERT INTO `province` VALUES ('27', '陕西省');INSERT INTO `province` VALUES ('28', '广西壮族自治区'); INSERT INTO `province` VALUES ('29', '西藏自治区');INSERT INTO `province` VALUES ('30', '宁夏回族自治区'); INSERT INTO `province` VALUES ('31', '新疆维吾尔自治区'); INSERT INTO `province` VALUES ('32', '内蒙古自治区'); INSERT INTO `province` VALUES ('33', '澳门特别行政区'); INSERT INTO `province` VALUES ('34', '香港特别行政区');本文档全是数据库脚本，结合本人上传的另一个类似文件可以完成省市县三级联动的数据库版本。
# 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');。
