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

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

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

INSERT INTO hat_area VALUES (1953,'440282','南雄市','440200'); INSERT INTO hat_area VALUES (1954,'440301','市辖区','440300'); INSERT INTO hat_area VALUES (1955,'440303','罗湖区','440300'); INSERT INTO hat_area VALUES (1956,'440304','福田区','440300'); INSERT INTO hat_area VALUES (1957,'440305','南山区','440300'); INSERT INTO hat_area VALUES (1958,'440306','宝安区','440300'); INSERT INTO hat_area VALUES (1959,'440307','龙岗区','440300'); INSERT INTO hat_area VALUES (1960,'440308','盐田区','440300'); INSERT INTO hat_area VALUES (1961,'440401','市辖区','440400'); INSERT INTO hat_area VALUES (1962,'440402','香洲区','440400'); INSERT INTO hat_area VALUES (1963,'440403','斗门区','440400'); INSERT INTO hat_area VALUES (1964,'440404','金湾区','440400'); INSERT INTO hat_area VALUES (1965,'440501','市辖区','440500'); INSERT INTO hat_area VALUES (1966,'440507','龙湖区','440500'); INSERT INTO hat_area VALUES (1967,'440511','金平区','440500'); INSERT INTO hat_area VALUES (1968,'440512','濠江区','440500'); INSERT INTO hat_area VALUES (1969,'440513','潮阳区','440500'); INSERT INTO hat_area VALUES (1970,'440514','潮南区','440500'); INSERT INTO hat_area VALUES (1971,'440515','澄海区','440500'); INSERT INTO hat_area VALUES (1972,'440523','南澳县','440500'); INSERT INTO hat_area VALUES (1973,'440601','市辖区','440600'); INSERT INTO hat_area VALUES (1974,'440604','禅城区','440600'); INSERT INTO hat_area VALUES (1975,'440605','南海区','440600'); INSERT INTO hat_area VALUES (1976,'440606','顺德区','440600'); INSERT INTO hat_area VALUES (1977,'440607','三水区','440600'); INSERT INTO hat_area VALUES (1978,'440608','高明区','440600'); INSERT INTO hat_area VALUES (1979,'440701','市辖区','440700'); INSERT INTO hat_area VALUES (1980,'440703','蓬江区','440700'); INSERT INTO hat_area VALUES (1981,'440704','江海区','440700'); INSERT INTO hat_area VALUES (1982,'440705','新会区','440700'); INSERT INTO hat_area VALUES (1983,'440781','台山市','440700'); INSERT INTO hat_area VALUES (1984,'440783','开平市','440700'); INSERT INTO hat_area VALUES (1985,'440784','鹤山市','440700'); INSERT INTO hat_area VALUES (1986,'440785','恩平市','440700'); INSERT INTO hat_area VALUES (1987,'440801','市辖区','440800'); INSERT INTO hat_area VALUES (1988,'440802','赤坎区','440800'); INSERT INTO hat_area VALUES (1989,'440803','霞山区','440800'); INSERT INTO hat_area VALUES (1990,'440804','坡头区','440800'); INSERT INTO hat_area VALUES (1991,'440811','麻章区','440800'); INSERT INTO hat_area VALUES (1992,'440823','遂溪县','440800'); INSERT INTO hat_area VALUES (1993,'440825','徐闻县','440800'); INSERT INTO hat_area VALUES (1994,'440881','廉江市','440800'); INSERT INTO hat_area VALUES (1995,'440882','雷州市','440800'); INSERT INTO hat_area VALUES (1996,'440883','吴川市','440800');

INSERT INTO hat_area VALUES (1997,'440901','市辖区','440900'); INSERT INTO hat_area VALUES (1998,'440902','茂南区','440900'); INSERT INTO hat_area VALUES (1999,'440903','茂港区','440900'); INSERT INTO hat_area VALUES (2000,'440923','电白县','440900'); INSERT INTO hat_area VALUES (2001,'440981','高州市','440900'); INSERT INTO hat_area VALUES (2002,'440982','化州市','440900'); INSERT INTO hat_area VALUES (2003,'440983','信宜市','440900'); INSERT INTO hat_area VALUES (2004,'441201','市辖区','441200'); INSERT INTO hat_area VALUES (2005,'441202','端州区','441200'); INSERT INTO hat_area VALUES (2006,'441203','鼎湖区','441200'); INSERT INTO hat_area VALUES (2007,'441223','广宁县','441200'); INSERT INTO hat_area VALUES (2008,'441224','怀集县','441200'); INSERT INTO hat_area VALUES (2009,'441225','封开县','441200'); INSERT INTO hat_area VALUES (2010,'441226','德庆县','441200'); INSERT INTO hat_area VALUES (2011,'441283','高要市','441200'); INSERT INTO hat_area VALUES (2012,'441284','四会市','441200'); INSERT INTO hat_area VALUES (2013,'441301','市辖区','441300'); INSERT INTO hat_area VALUES (2014,'441302','惠城区','441300'); INSERT INTO hat_area VALUES (2015,'441303','惠阳区','441300'); INSERT INTO hat_area VALUES (2016,'441322','博罗县','441300'); INSERT INTO hat_area VALUES (2017,'441323','惠东县','441300'); INSERT INTO hat_area VALUES (2018,'441324','龙门县','441300'); INSERT INTO hat_area VALUES (2019,'441401','市辖区','441400'); INSERT INTO hat_area VALUES (2020,'441402','梅江区','441400'); INSERT INTO hat_area VALUES (2021,'441421','梅 县','441400'); INSERT INTO hat_area VALUES (2022,'441422','大埔县','441400'); INSERT INTO hat_area VALUES (2023,'441423','丰顺县','441400'); INSERT INTO hat_area VALUES (2024,'441424','五华县','441400'); INSERT INTO hat_area VALUES (2025,'441426','平远县','441400'); INSERT INTO hat_area VALUES (2026,'441427','蕉岭县','441400'); INSERT INTO hat_area VALUES (2027,'441481','兴宁市','441400'); INSERT INTO hat_area VALUES (2028,'441501','市辖区','441500'); INSERT INTO hat_area VALUES (2029,'441502','城 区','441500'); INSERT INTO hat_area VALUES (2030,'441521','海丰县','441500'); INSERT INTO hat_area VALUES (2031,'441523','陆河县','441500'); INSERT INTO hat_area VALUES (2032,'441581','陆丰市','441500'); INSERT INTO hat_area VALUES (2033,'441601','市辖区','441600'); INSERT INTO hat_area VALUES (2034,'441602','源城区','441600'); INSERT INTO hat_area VALUES (2035,'441621','紫金县','441600'); INSERT INTO hat_area VALUES (2036,'441622','龙川县','441600'); INSERT INTO hat_area VALUES (2037,'441623','连平县','441600'); INSERT INTO hat_area VALUES (2038,'441624','和平县','441600'); INSERT INTO hat_area VALUES (2039,'441625','东源县','441600'); INSERT INTO hat_area VALUES (2040,'441701','市辖区','441700');

INSERT INTO hat_area VALUES (2041,'441702','江城区','441700'); INSERT INTO hat_area VALUES (2042,'441721','阳西县','441700'); INSERT INTO hat_area VALUES (2043,'441723','阳东县','441700'); INSERT INTO hat_area VALUES (2044,'441781','阳春市','441700'); INSERT INTO hat_area VALUES (2045,'441801','市辖区','441800'); INSERT INTO hat_area VALUES (2046,'441802','清城区','441800'); INSERT INTO hat_area VALUES (2047,'441821','佛冈县','441800'); INSERT INTO hat_area VALUES (2048,'441823','阳山县','441800');

INSERT INTO hat_area VALUES (2049,'441825','连山壮族瑶族自治县','441800'); INSERT INTO hat_area VALUES (2050,'441826','连南瑶族自治县','441800'); INSERT INTO hat_area VALUES (2051,'441827','清新县','441800'); INSERT INTO hat_area VALUES (2052,'441881','英德市','441800'); INSERT INTO hat_area VALUES (2053,'441882','连州市','441800'); INSERT INTO hat_area VALUES (2054,'445101','市辖区','445100'); INSERT INTO hat_area VALUES (2055,'445102','湘桥区','445100'); INSERT INTO hat_area VALUES (2056,'445121','潮安县','445100'); INSERT INTO hat_area VALUES (2057,'445122','饶平县','445100'); INSERT INTO hat_area VALUES (2058,'445201','市辖区','445200'); INSERT INTO hat_area VALUES (2059,'445202','榕城区','445200'); INSERT INTO hat_area VALUES (2060,'445221','揭东县','445200'); INSERT INTO hat_area VALUES (2061,'445222','揭西县','445200'); INSERT INTO hat_area VALUES (2062,'445224','惠来县','445200'); INSERT INTO hat_area VALUES (2063,'445281','普宁市','445200'); INSERT INTO hat_area VALUES (2064,'445301','市辖区','445300'); INSERT INTO hat_area VALUES (2065,'445302','云城区','445300'); INSERT INTO hat_area VALUES (2066,'445321','新兴县','445300'); INSERT INTO hat_area VALUES (2067,'445322','郁南县','445300'); INSERT INTO hat_area VALUES (2068,'445323','云安县','445300'); INSERT INTO hat_area VALUES (2069,'445381','罗定市','445300'); INSERT INTO hat_area VALUES (2070,'450101','市辖区','450100'); INSERT INTO hat_area VALUES (2071,'450102','兴宁区','450100'); INSERT INTO hat_area VALUES (2072,'450103','青秀区','450100'); INSERT INTO hat_area VALUES (2073,'450105','江南区','450100'); INSERT INTO hat_area VALUES (2074,'450107','西乡塘区','450100'); INSERT INTO hat_area VALUES (2075,'450108','良庆区','450100'); INSERT INTO hat_area VALUES (2076,'450109','邕宁区','450100'); INSERT INTO hat_area VALUES (2077,'450122','武鸣县','450100'); INSERT INTO hat_area VALUES (2078,'450123','隆安县','450100'); INSERT INTO hat_area VALUES (2079,'450124','马山县','450100'); INSERT INTO hat_area VALUES (2080,'450125','上林县','450100'); INSERT INTO hat_area VALUES (2081,'450126','宾阳县','450100'); INSERT INTO hat_area VALUES (2082,'450127','横 县','450100'); INSERT INTO hat_area VALUES (2083,'450201','市辖区','450200'); INSERT INTO hat_area VALUES (2084,'450202','城中区','450200');

INSERT INTO hat_area VALUES (2085,'450203','鱼峰区','450200'); INSERT INTO hat_area VALUES (2086,'450204','柳南区','450200'); INSERT INTO hat_area VALUES (2087,'450205','柳北区','450200'); INSERT INTO hat_area VALUES (2088,'450221','柳江县','450200'); INSERT INTO hat_area VALUES (2089,'450222','柳城县','450200'); INSERT INTO hat_area VALUES (2090,'450223','鹿寨县','450200'); INSERT INTO hat_area VALUES (2091,'450224','融安县','450200');

INSERT INTO hat_area VALUES (2092,'450225','融水苗族自治县','450200'); INSERT INTO hat_area VALUES (2093,'450226','三江侗族自治县','450200'); INSERT INTO hat_area VALUES (2094,'450301','市辖区','450300'); INSERT INTO hat_area VALUES (2095,'450302','秀峰区','450300'); INSERT INTO hat_area VALUES (2096,'450303','叠彩区','450300'); INSERT INTO hat_area VALUES (2097,'450304','象山区','450300'); INSERT INTO hat_area VALUES (2098,'450305','七星区','450300'); INSERT INTO hat_area VALUES (2099,'450311','雁山区','450300'); INSERT INTO hat_area VALUES (2100,'450321','阳朔县','450300'); INSERT INTO hat_area VALUES (2101,'450322','临桂县','450300'); INSERT INTO hat_area VALUES (2102,'450323','灵川县','450300'); INSERT INTO hat_area VALUES (2103,'450324','全州县','450300'); INSERT INTO hat_area VALUES (2104,'450325','兴安县','450300'); INSERT INTO hat_area VALUES (2105,'450326','永福县','450300'); INSERT INTO hat_area VALUES (2106,'450327','灌阳县','450300');

INSERT INTO hat_area VALUES (2107,'450328','龙胜各族自治县','450300'); INSERT INTO hat_area VALUES (2108,'450329','资源县','450300'); INSERT INTO hat_area VALUES (2109,'450330','平乐县','450300'); INSERT INTO hat_area VALUES (2110,'450331','荔蒲县','450300');

INSERT INTO hat_area VALUES (2111,'450332','恭城瑶族自治县','450300'); INSERT INTO hat_area VALUES (2112,'450401','市辖区','450400'); INSERT INTO hat_area VALUES (2113,'450403','万秀区','450400'); INSERT INTO hat_area VALUES (2114,'450404','蝶山区','450400'); INSERT INTO hat_area VALUES (2115,'450405','长洲区','450400'); INSERT INTO hat_area VALUES (2116,'450421','苍梧县','450400'); INSERT INTO hat_area VALUES (2117,'450422','藤 县','450400'); INSERT INTO hat_area VALUES (2118,'450423','蒙山县','450400'); INSERT INTO hat_area VALUES (2119,'450481','岑溪市','450400'); INSERT INTO hat_area VALUES (2120,'450501','市辖区','450500'); INSERT INTO hat_area VALUES (2121,'450502','海城区','450500'); INSERT INTO hat_area VALUES (2122,'450503','银海区','450500'); INSERT INTO hat_area VALUES (2123,'450512','铁山港区','450500'); INSERT INTO hat_area VALUES (2124,'450521','合浦县','450500'); INSERT INTO hat_area VALUES (2125,'450601','市辖区','450600'); INSERT INTO hat_area VALUES (2126,'450602','港口区','450600'); INSERT INTO hat_area VALUES (2127,'450603','防城区','450600'); INSERT INTO hat_area VALUES (2128,'450621','上思县','450600');

INSERT INTO hat_area VALUES (2129,'450681','东兴市','450600'); INSERT INTO hat_area VALUES (2130,'450701','市辖区','450700'); INSERT INTO hat_area VALUES (2131,'450702','钦南区','450700'); INSERT INTO hat_area VALUES (2132,'450703','钦北区','450700'); INSERT INTO hat_area VALUES (2133,'450721','灵山县','450700'); INSERT INTO hat_area VALUES (2134,'450722','浦北县','450700'); INSERT INTO hat_area VALUES (2135,'450801','市辖区','450800'); INSERT INTO hat_area VALUES (2136,'450802','港北区','450800'); INSERT INTO hat_area VALUES (2137,'450803','港南区','450800'); INSERT INTO hat_area VALUES (2138,'450804','覃塘区','450800'); INSERT INTO hat_area VALUES (2139,'450821','平南县','450800'); INSERT INTO hat_area VALUES (2140,'450881','桂平市','450800'); INSERT INTO hat_area VALUES (2141,'450901','市辖区','450900'); INSERT INTO hat_area VALUES (2142,'450902','玉州区','450900'); INSERT INTO hat_area VALUES (2143,'450921','容 县','450900'); INSERT INTO hat_area VALUES (2144,'450922','陆川县','450900'); INSERT INTO hat_area VALUES (2145,'450923','博白县','450900'); INSERT INTO hat_area VALUES (2146,'450924','兴业县','450900'); INSERT INTO hat_area VALUES (2147,'450981','北流市','450900'); INSERT INTO hat_area VALUES (2148,'451001','市辖区','451000'); INSERT INTO hat_area VALUES (2149,'451002','右江区','451000'); INSERT INTO hat_area VALUES (2150,'451021','田阳县','451000'); INSERT INTO hat_area VALUES (2151,'451022','田东县','451000'); INSERT INTO hat_area VALUES (2152,'451023','平果县','451000'); INSERT INTO hat_area VALUES (2153,'451024','德保县','451000'); INSERT INTO hat_area VALUES (2154,'451025','靖西县','451000'); INSERT INTO hat_area VALUES (2155,'451026','那坡县','451000'); INSERT INTO hat_area VALUES (2156,'451027','凌云县','451000'); INSERT INTO hat_area VALUES (2157,'451028','乐业县','451000'); INSERT INTO hat_area VALUES (2158,'451029','田林县','451000'); INSERT INTO hat_area VALUES (2159,'451030','西林县','451000');

INSERT INTO hat_area VALUES (2160,'451031','隆林各族自治县','451000'); INSERT INTO hat_area VALUES (2161,'451101','市辖区','451100'); INSERT INTO hat_area VALUES (2162,'451102','八步区','451100'); INSERT INTO hat_area VALUES (2163,'451121','昭平县','451100'); INSERT INTO hat_area VALUES (2164,'451122','钟山县','451100');

INSERT INTO hat_area VALUES (2165,'451123','富川瑶族自治县','451100'); INSERT INTO hat_area VALUES (2166,'451201','市辖区','451200'); INSERT INTO hat_area VALUES (2167,'451202','金城江区','451200'); INSERT INTO hat_area VALUES (2168,'451221','南丹县','451200'); INSERT INTO hat_area VALUES (2169,'451222','天峨县','451200'); INSERT INTO hat_area VALUES (2170,'451223','凤山县','451200'); INSERT INTO hat_area VALUES (2171,'451224','东兰县','451200');

INSERT INTO hat_area VALUES (2172,'451225','罗城仫佬族自治县','451200');

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

INSERTINTOhat_areaVALUES(1953,'440282','南雄市','440200');INSERTINTOhat_areaVALUES(1954,'440301','市辖区','440300');INSERTINTOhat_areaVALUES(1955,'440303','罗湖区','440300');INSERTINTOhat_a
推荐度:
点击下载文档文档为doc格式
6nfrw8csng55t2h95zwz
领取福利

微信扫码领取福利

微信扫码分享