很簡單用數據工具打開表,倒入數據,或者編寫段小程序倒入數據。
Ⅱ 求全國行政區劃代碼表,最好是數據導出成sql語句形式 例如:insert t_* into ('110000','北京','100000'
中國省市區三級聯動
Ⅲ mysql資料庫存儲行政代碼用什麼類型
html那個pasword為*是可以輸出來的,
如果要在mysql裡面存儲密碼,可以考慮用字元串類型 char(32) 32位,然後將前台html裡面輸入的密碼用MD5多加密幾次(加密一次很容易破解)
然後將加密後的密碼(32位)插入到資料庫中。
如果以後要實現登陸驗證功能,可以把用戶登陸的密碼MD5後再跟資料庫比較..
Ⅳ sql語句,根據地區ID編號取對應的地區名稱。
1:
select
a.UserName,
a.CountryID,
nvl(b.AreaName,'未選擇') as CountryName,
a.ProvID,
nvl(c.AreaName,'未選擇') as ProvName,
a.CityID,
nvl(d.AreaName,'未選擇') as CityName
from 用戶的地區信息 a left join 地區信息表 b on a.CountryID=b.AreaID
left join 地區信息表 c on a.ProvID=b.AreaID
left join 地區信息表 d on a.CityID=c.AreaID;
2、--有點麻煩。
---
以上,希望對你有所幫助。
Ⅳ 求:全國省份、城市SQL資料庫表。或文本導入及方式。
已經上傳,滿意請採納。
Ⅵ 求中華人民共和國行政區劃代碼資料庫,要GB/T 2260-1982 版的
我仔細看過圖書館中的藏品,發覺對實際有用的中華人民共和國國家標准GB 2260~《中華人民共和國行政區劃代碼》,只有從GB 2260-84的版本及以後的版本對我國的社會事務起作用,從GB 2260-84《中華人民共和國行政區劃代碼》將地級市的市轄區首次賦予的行政區劃代碼,前兩個版本好像作為試驗性的,實際這部標准為公安部用於頒發第一代居民身份證作為最初辦證時的行政區劃,以後隨著國家對縣級以上行政區劃的調整都從GB 2260-84版本的基礎上修訂的。建議你只要關注中華人民共和國國家標准 GB 2260-84《中華人民共和國行政區劃代碼》。
Ⅶ 求一個sql或access 的中國省市資料庫
全國省市縣無刷新多級關聯菜單[網頁特效JS代碼]-
2006-3-21 22:56:27
<html>
<head>
<title>省市縣關聯菜單</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body,select
{
font-size:9pt;
font-family:Verdana;
}
a
{
color:red;
text-decoration:none;
}
a:hover{
text-decoration:underline;
}
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function Dsy()
{
this.Items = {};
}
Dsy.prototype.add = function(id,iArray)
{
this.Items[id] = iArray;
}
Dsy.prototype.Exists = function(id)
{
if(typeof(this.Items[id]) == "undefined") return false;
return true;
}
function change(v){
var str="0";
for(i=0;i<v;i++){ str+=("_"+(document.getElementById(s[i]).selectedIndex-1));};
var ss=document.getElementById(s[v]);
with(ss){
length = 0;
options[0]=new Option(opt0[v],opt0[v]);
if(v && document.getElementById(s[v-1]).selectedIndex>0 || !v)
{
if(dsy.Exists(str)){
ar = dsy.Items[str];
for(i=0;i<ar.length;i++)options[length]=new Option(ar[i],ar[i]);
if(v)options[1].selected = true;
}
}
if(++v<s.length){change(v);}
}
}
var dsy = new Dsy();
dsy.add("0",["安徽","北京","福建","甘肅","廣東","廣西","貴州","海南","河北","河南","黑龍江","湖北","湖南","吉林","江蘇","江西","遼寧","內蒙古","寧夏","青海","山東","山西","陝西","上海","四川","天津","西藏","新疆","雲南","浙江","重慶"]);
dsy.add("0_0",["安慶","蚌埠","巢湖","池州","滁州","阜陽","合肥","淮北","淮南","黃山","六安","馬鞍山","宿州","銅陵","蕪湖","宣城","亳州"]);
dsy.add("0_0_0",["安慶市","懷寧縣","潛山縣","宿松縣","太湖縣","桐城市","望江縣","岳西縣","樅陽縣"]);
dsy.add("0_0_1",["蚌埠市","固鎮縣","懷遠縣","五河縣"]);
dsy.add("0_0_2",["巢湖市","含山縣","和縣","廬江縣","無為縣"]);
dsy.add("0_0_3",["池州市","東至縣","青陽縣","石台縣"]);
dsy.add("0_0_4",["滁州市","定遠縣","鳳陽縣","來安縣","明光市","全椒縣","天長市"]);
dsy.add("0_0_5",["阜南縣","阜陽市","界首市","臨泉縣","太和縣","穎上縣"]);
dsy.add("0_0_6",["長豐縣","肥東縣","肥西縣"]);
dsy.add("0_0_7",["淮北市","濉溪縣"]);
dsy.add("0_0_8",["鳳台縣","淮南市"]);
dsy.add("0_0_9",["黃山市","祁門縣","休寧縣","歙縣","黟縣"]);
dsy.add("0_0_10",["霍邱縣","霍山縣","金寨縣","六安市","壽縣","舒城縣"]);
dsy.add("0_0_11",["當塗縣","馬鞍山市"]);
dsy.add("0_0_12",["靈璧縣","宿州市","蕭縣","泗縣","碭山縣"]);
dsy.add("0_0_13",["銅陵市","銅陵縣"]);
dsy.add("0_0_14",["繁昌縣","南陵縣","蕪湖市","蕪湖縣"]);
dsy.add("0_0_15",["廣德縣","績溪縣","郎溪縣","寧國市","宣城市","涇縣","旌德縣"]);
dsy.add("0_0_16",["利辛縣","蒙城縣","渦陽縣","亳州市"]);
dsy.add("0_1",["北京"]);
dsy.add("0_1_0",["北京市","密雲縣","延慶縣"]);
dsy.add("0_2",["福州","龍岩","南平","寧德","莆田","泉州","三明","廈門","漳州"]);
dsy.add("0_2_0",["長樂市","福清市","福州市","連江縣","羅源縣","閩侯縣","閩清縣","平潭縣","永泰縣"]);
dsy.add("0_2_1",["長汀縣","連城縣","龍岩市","上杭縣","武平縣","永定縣","漳平市"]);
dsy.add("0_2_2",["光澤縣","建陽市","建甌市","南平市","浦城縣","邵武市","順昌縣","松溪縣","武夷山市","政和縣"]);
dsy.add("0_2_3",["福安市","福鼎市","古田縣","寧德市","屏南縣","壽寧縣","霞浦縣","周寧縣","柘榮縣"]);
dsy.add("0_2_4",["莆田市","仙游縣"]);
dsy.add("0_2_5",["安溪縣","德化縣","惠安縣","金門縣","晉江市","南安市","泉州市","石獅市","永春縣"]);
dsy.add("0_2_6",["大田縣","建寧縣","將樂縣","明溪縣","寧化縣","清流縣","三明市","沙縣","泰寧縣","永安市","尤溪縣"]);
dsy.add("0_2_7",["廈門市"]);
dsy.add("0_2_8",["長泰縣","東山縣","華安縣","龍海市","南靖縣","平和縣","雲霄縣","漳浦縣","漳州市","詔安縣"]);
dsy.add("0_3",["白銀","定西","甘南藏族自治州","嘉峪關","金昌","酒泉","蘭州","臨夏回族自治州","隴南","平涼","慶陽","天水","武威","張掖"]);
dsy.add("0_3_0",["白銀市","會寧縣","景泰縣","靖遠縣"]);
dsy.add("0_3_1",["定西縣","臨洮縣","隴西縣","通渭縣","渭源縣","漳縣","岷縣"]);
dsy.add("0_3_2",["迭部縣","合作市","臨潭縣","碌曲縣","瑪曲縣","夏河縣","舟曲縣","卓尼縣"]);
dsy.add("0_3_3",["嘉峪關市"]);
dsy.add("0_3_4",["金昌市","永昌縣"]);
dsy.add("0_3_5",["阿克塞哈薩克族自治縣","安西縣","敦煌市","金塔縣","酒泉市","肅北蒙古族自治縣","玉門市"]);
dsy.add("0_3_6",["皋蘭縣","蘭州市","永登縣","榆中縣"]);
dsy.add("0_3_7",["東鄉族自治縣","廣河縣","和政縣","積石山保安族東鄉族撒拉族自治縣","康樂縣","臨夏市","臨夏縣","永靖縣"]);
dsy.add("0_3_8",["成縣","徽縣","康縣","禮縣","兩當縣","文縣","武都縣","西和縣","宕昌縣"]);
dsy.add("0_3_9",["崇信縣","華亭縣","靜寧縣","靈台縣","平涼市","庄浪縣","涇川縣"]);
dsy.add("0_3_10",["合水縣","華池縣","環縣","寧縣","慶城縣","慶陽市","鎮原縣","正寧縣"]);
dsy.add("0_3_11",["甘谷縣","秦安縣","清水縣","天水市","武山縣","張家川回族自治縣"]);
dsy.add("0_3_12",["古浪縣","民勤縣","天祝藏族自治縣","武威市"]);
dsy.add("0_3_13",["高台縣","臨澤縣","民樂縣","山丹縣","肅南裕固族自治縣","張掖市"]);
dsy.add("0_4",["潮州","東莞","佛山","廣州","河源","惠州","江門","揭陽","茂名","梅州","清遠","汕頭","汕尾","韶關","深圳","陽江","雲浮","湛江","肇慶","中山","珠海"]);
dsy.add("0_4_0",["潮安縣","潮州市","饒平縣"]);
dsy.add("0_4_1",["東莞市"]);
dsy.add("0_4_2",["佛山市"]);
dsy.add("0_4_3",["從化市","廣州市","增城市"]);
dsy.add("0_4_4",["東源縣","和平縣","河源市","連平縣","龍川縣","紫金縣"]);
dsy.add("0_4_5",["博羅縣","惠東縣","惠陽市","惠州市","龍門縣"]);
dsy.add("0_4_6",["恩平市","鶴山市","江門市","開平市","台山市"]);
dsy.add("0_4_7",["惠來縣","揭東縣","揭西縣","揭陽市","普寧市"]);
dsy.add("0_4_8",["電白縣","高州市","化州市","茂名市","信宜市"]);
dsy.add("0_4_9",["大埔縣","豐順縣","蕉嶺縣","梅縣","梅州市","平遠縣","五華縣","興寧市"]);
dsy.add("0_4_10",["佛岡縣","連南瑤族自治縣","連山壯族瑤族自治縣","連州市","清新縣","清遠市","陽山縣","英德市"]);
dsy.add("0_4_11",["潮陽市","澄海市","南澳縣","汕頭市"]);
dsy.add("0_4_12",["海豐縣","陸豐市","陸河縣","汕尾市"]);
dsy.add("0_4_13",["樂昌市","南雄市","曲江縣","仁化縣","乳源瑤族自治縣","韶關市","始興縣","翁源縣","新豐縣"]);
dsy.add("0_4_14",["深圳市"]);
dsy.add("0_4_15",["陽春市","陽東縣","陽江市","陽西縣"]);
dsy.add("0_4_16",["羅定市","新興縣","鬱南縣","雲安縣","雲浮市"]);
dsy.add("0_4_17",["雷州市","廉江市","遂溪縣","吳川市","徐聞縣","湛江市"]);
dsy.add("0_4_18",["德慶縣","封開縣","高要市","廣寧縣","懷集縣","四會市","肇慶市"]);
dsy.add("0_4_19",["中山市"]);
dsy.add("0_4_20",["珠海市"]);
dsy.add("0_5",["百色","北海","崇左","防城港","桂林","貴港","河池","賀州","來賓","柳州","南寧","欽州","梧州","玉林"]);
dsy.add("0_5_0",["百色市","德保縣","靖西縣","樂業縣","凌雲縣","隆林各族自治縣","那坡縣","平果縣","田東縣","田林縣","田陽縣","西林縣"]);
dsy.add("0_5_1",["北海市","合浦縣"]);
dsy.add("0_5_2",["崇左市","大新縣","扶綏縣","龍州縣","寧明縣","憑祥市","天等縣"]);
dsy.add("0_5_3",["東興市","防城港市","上思縣"]);
dsy.add("0_5_4",["恭城瑤族自治縣","灌陽縣","桂林市","荔浦縣","臨桂縣","靈川縣","龍勝各族自治縣","平樂縣","全州縣","興安縣","陽朔縣","永福縣","資源縣"]);
dsy.add("0_5_5",["桂平市","貴港市","平南縣"]);
dsy.add("0_5_6",["巴馬瑤族自治縣","大化瑤族自治縣","東蘭縣","都安瑤族自治縣","鳳山縣","河池市","環江毛南族自治縣","羅城仡佬族自治縣","南丹縣","天峨縣","宜州市"]);
dsy.add("0_5_7",["富川瑤族自治縣","賀州市","昭平縣","鍾山縣"]);
dsy.add("0_5_8",["合山市","金秀瑤族自治縣","來賓市","武宣縣","象州縣","忻城縣"]);
dsy.add("0_5_9",["柳城縣","柳江縣","柳州市","鹿寨縣","融安縣","融水苗族自治縣","三江侗族自治縣"]);
dsy.add("0_5_10",["賓陽縣","橫縣","隆安縣","馬山縣","南寧市","上林縣","武鳴縣","邕寧縣"]);
dsy.add("0_5_11",["靈山縣","浦北縣","欽州市"]);
dsy.add("0_5_12",["蒼梧縣","蒙山縣","藤縣","梧州市","岑溪市"]);
dsy.add("0_5_13",["北流市","博白縣","陸川縣","容縣","興業縣","玉林市"]);
dsy.add("0_6",["安順","畢節","貴陽","六盤水","黔東南苗族侗族自治州","黔南布依族苗族自治州","黔西南布依族苗族自治州","銅仁","遵義"]);
dsy.add("0_6_0",["安順市","關嶺布依族苗族自治縣","平壩縣","普定縣","鎮寧布依族苗族自治縣","紫雲苗族布依族自治縣"]);
dsy.add("0_6_1",["畢節市","大方縣","赫章縣","金沙縣","納雍縣","黔西縣","威寧彝族回族苗族自治縣","織金縣"]);
dsy.add("0_6_2",["貴陽市","開陽縣","清鎮市","息烽縣","修文縣"]);
dsy.add("0_6_3",["六盤水市","六枝特區","盤縣","水城縣"]);
dsy.add("0_6_4",["從江縣","丹寨縣","黃平縣","劍河縣","錦屏縣","凱里市","雷山縣","黎平縣","麻江縣","三穗縣","施秉縣","台江縣","天柱縣","鎮遠縣","岑鞏縣","榕江縣"]);
dsy.add("0_6_5",["長順縣","都勻市","獨山縣","福泉市","貴定縣","惠水縣","荔波縣","龍里縣","羅甸縣","平塘縣","三都水族自治縣","甕安縣"]);
dsy.add("0_6_6",["安龍縣","冊亨縣","普安縣","晴隆縣","望謨縣","興仁縣","興義市","貞豐縣"]);
dsy.add("0_6_7",["德江縣","江口縣","石阡縣","思南縣","松桃苗族自治縣","銅仁市","萬山特區","沿河土家族自治縣","印江土家族苗族自治縣","玉屏侗族自治縣"]);
dsy.add("0_6_8",["赤水市","道真仡佬族苗族自治縣","鳳岡縣","仁懷市","綏陽縣","桐梓縣","務川仡佬族苗族自治縣","習水縣","余慶縣","正安縣","遵義市","遵義縣","湄潭縣"]);
dsy.add("0_7",["白沙黎族自治縣","保亭黎族苗族自治縣","昌江黎族自治縣","澄邁縣","定安縣","東方","海口","樂東黎族自治縣","臨高縣","陵水黎族自治縣","瓊海","瓊中黎族苗族自治縣","三亞","屯昌縣","萬寧","文昌","五指山","儋州"]);
dsy.add("0_7_0",["白沙黎族自治縣"]);
dsy.add("0_7_1",["保亭黎族苗族自治縣"]);
dsy.add("0_7_2",["昌江黎族自治縣"]);
dsy.add("0_7_3",["澄邁縣"]);
dsy.add("0_7_4",["定安縣"]);
dsy.add("0_7_5",["東方市"]);
dsy.add("0_7_6",["海口市"]);
dsy.add("0_7_7",["樂東黎族自治縣"]);
dsy.add("0_7_8",["臨高縣"]);
dsy.add("0_7_9",["陵水黎族自治縣"]);
dsy.add("0_7_10",["瓊海市"]);
dsy.add("0_7_11",["瓊中黎族苗族自治縣"]);
dsy.add("0_7_12",["三亞市"]);
dsy.add("0_7_13",["屯昌縣"]);
dsy.add("0_7_14",["萬寧市"]);
dsy.add("0_7_15",["文昌市"]);
dsy.add("0_7_16",["五指山市"]);
dsy.add("0_7_17",["儋州市"]);
dsy.add("0_8",["保定","滄州","承德","邯鄲","衡水","廊坊","秦皇島","石家莊","唐山","邢台","張家口"]);
dsy.add("0_8_0",["安國市","安新縣","保定市","博野縣","定興縣","定州市","阜平縣","高碑店市","高陽縣","滿城縣","清苑縣","曲陽縣","容城縣","順平縣","唐縣","望都縣","雄縣","徐水縣","易縣","淶水縣","淶源縣","涿州市","蠡縣"]);
dsy.add("0_8_1",["泊頭市","滄縣","滄州市","東光縣","海興縣","河間市","黃驊市","孟村回族自治縣","南皮縣","青縣","任丘市","肅寧縣","吳橋縣","獻縣","鹽山縣"]);
dsy.add("0_8_2",["承德市","承德縣","豐寧滿族自治縣","寬城滿族自治縣","隆化縣","灤平縣","平泉縣","圍場滿族蒙古族自治縣","興隆縣"]);
dsy.add("0_8_3",["成安縣","磁縣","大名縣","肥鄉縣","館陶縣","廣平縣","邯鄲市","邯鄲縣","雞澤縣","臨漳縣","邱縣","曲周縣","涉縣","魏縣","武安市","永年縣"]);
dsy.add("0_8_4",["安平縣","阜城縣","故城縣","衡水市","冀州市","景縣","饒陽縣","深州市","武強縣","武邑縣","棗強縣"]);
dsy.add("0_8_5",["霸州市","大廠回族自治縣","大城縣","固安縣","廊坊市","三河市","文安縣","香河縣","永清縣"]);
dsy.add("0_8_6",["昌黎縣","撫寧縣","盧龍縣","秦皇島市","青龍滿族自治縣"]);
dsy.add("0_8_7",["高邑縣","晉州市","井陘縣","靈壽縣","鹿泉市","平山縣","深澤縣","石家莊市","無極縣","辛集市","新樂市","行唐縣","元氏縣","贊皇縣","趙縣","正定縣","藁城市","欒城縣"]);
dsy.add("0_8_8",["樂亭縣","灤南縣","灤縣","遷安市","遷西縣","唐海縣","唐山市","玉田縣","遵化市"]);
dsy.add("0_8_9",["柏鄉縣","廣宗縣","巨鹿縣","臨城縣","臨西縣","隆堯縣","南宮市","南和縣","內丘縣","寧晉縣","平鄉縣","清河縣","任縣","沙河市","威縣","新河縣","邢台市","邢台縣"]);
dsy.add("0_8_10",["赤城縣","崇禮縣","沽源縣","懷安縣","懷來縣","康保縣","尚義縣","萬全縣","蔚縣","宣化縣","陽原縣","張北縣","張家口市","涿鹿縣"]);
dsy.add("0_9",["安陽","鶴壁","濟源","焦作","開封","洛陽","南陽","平頂山","三門峽","商丘","新鄉","信陽","許昌","鄭州","周口","駐馬店","漯河","濮陽"]);
dsy.add("0_9_0",["安陽市","安陽縣","滑縣","林州市","內黃縣","湯陰縣"]);
dsy.add("0_9_1",["","鶴壁市","浚縣","淇縣"]);
dsy.add("0_9_2",["濟源市"]);
dsy.add("0_9_3",["博愛縣","焦作市","孟州市","沁陽市","溫縣","武陟縣","修武縣"]);
dsy.add("0_9_4",["開封市","開封縣","蘭考縣","通許縣","尉氏縣","杞縣"]);
dsy.add("0_9_5",["洛寧縣","洛陽市","孟津縣","汝陽縣","新安縣","伊川縣","宜陽縣","偃師市","嵩縣","欒川縣"]);
dsy.add("0_9_6",["鄧州市","方城縣","南陽市","南召縣","內鄉縣","社旗縣","唐河縣","桐柏縣","西峽縣","新野縣","鎮平縣","淅川縣"]);
dsy.add("0_9_7",["寶豐縣","魯山縣","平頂山市","汝州市","舞鋼市","葉縣","郟縣"]);
dsy.add("0_9_8",["靈寶市","盧氏縣","三門峽市","陝縣","義馬市","澠池縣"]);
dsy.add("0_9_9",["民權縣","寧陵縣","商丘市","夏邑縣","永城市","虞城縣","柘城縣","睢縣"]);
dsy.add("0_9_10",["長垣縣","封丘縣","輝縣市","獲嘉縣","衛輝市","新鄉市","新鄉縣","延津縣","原陽縣"]);
dsy.add("0_9_11",["固始縣","光山縣","淮濱縣","羅山縣","商城縣","息縣","新縣","信陽市","潢川縣"]);
dsy.add("0_9_12",["長葛市","襄城縣","許昌市","許昌縣","禹州市","鄢陵縣"]);
dsy.add("0_9_13",["登封市","鞏義市","新密市","新鄭市","鄭州市","中牟縣","滎陽市"]);
dsy.add("0_9_14",["鄲城縣","扶溝縣","淮陽縣","鹿邑縣","商水縣","沈丘縣","太康縣","西華縣","項城市","周口市"]);
dsy.add("0_9_15",["泌陽縣","平輿縣","確山縣","汝南縣","上蔡縣","遂平縣","西平縣","新蔡縣","正陽縣","駐馬店市"]);
dsy.add("0_9_16",["臨潁縣","舞陽縣","郾城縣","漯河市"]);
dsy.add("0_9_17",["范縣","南樂縣","清豐縣","台前縣","濮陽市","濮陽縣"]);
dsy.add("0_10",["大慶","大興安嶺","哈爾濱","鶴崗","黑河","雞西","佳木斯","牡丹江","七台河","齊齊哈爾","雙鴨山","綏化","伊春"]);
dsy.add("0_10_0",["大慶市","杜爾伯特蒙古族自治縣","林甸縣","肇源縣","肇州縣"]);
dsy.add("0_10_1",["呼瑪縣","漠河縣","塔河縣"]);
dsy.add("0_10_2",["阿城市","巴彥縣","賓縣","方正縣","哈爾濱市","呼蘭縣","木蘭縣","尚志市","雙城市","通河縣","五常市","延壽縣","依蘭縣"]);
dsy.add("0_10_3",["鶴崗市","蘿北縣","綏濱縣"]);
dsy.add("0_10_4",["北安市","黑河市","嫩江縣","孫吳縣","五大連池市","遜克縣"]);
dsy.add("0_10_5",["虎林市","雞東縣","雞西市","密山市"]);
dsy.add("0_10_6",["撫遠縣","富錦市","佳木斯市","湯原縣","同江市","樺川縣","樺南縣"]);
dsy.add("0_10_7",["東寧縣","海林市","林口縣","牡丹江市","穆棱市","寧安市","綏芬河市"]);
dsy.add("0_10_8",["勃利縣","七台河市"]);
dsy.add("0_10_9",["拜泉縣","富裕縣","甘南縣","克東縣","克山縣","龍江縣","齊齊哈爾市","泰來縣","依安縣","訥河市"]);
dsy.add("0_10_10",["寶清縣","集賢縣","饒河縣","雙鴨山市","友誼縣"]);
dsy.add("0_10_11",["安達市","海倫市","蘭西縣","明水縣","青岡縣","慶安縣","綏化市","綏棱縣","望奎縣","肇東市"]);
dsy.add("0_10_12",["嘉蔭縣","鐵力市","伊春市"]);
dsy.add("0_11",["鄂州","恩施土家族苗族自治州","黃岡","黃石","荊門","荊州","潛江","神農架林區","十堰","隨州","天門","武漢","仙桃","咸寧","襄樊","孝感","宜昌"]);
dsy.add("0_11_0",["鄂州市"]);
dsy.add("0_11_1",["巴東縣","恩施市","鶴峰縣","建始縣","來鳳縣","利川市","咸豐縣","宣恩縣"]);
dsy.add("0_11_2",["紅安縣","黃岡市","黃梅縣","羅田縣","麻城市","團風縣","武穴市","英山縣","蘄春縣","浠水縣"]);
dsy.add("0_11_3",["大冶市","黃石市","陽新縣"]);
dsy.add("0_11_4",["荊門市","京山縣","沙洋縣","鍾祥市"]);
dsy.add("0_11_5",["公安縣","洪湖市","監利縣","江陵縣","荊州市","石首市","松滋市"]);
dsy.add("0_11_6",["潛江市"]);
dsy.add("0_11_7",["神農架林區"]);
dsy.add("0_11_8",["丹江口市","房縣","十堰市","鄖西縣","鄖縣","竹山縣","竹溪縣"]);
dsy.add("0_11_9",["廣水市","隨州市"]);
dsy.add("0_11_10",["天門市"]);
dsy.add("0_11_11",["武漢市"]);
dsy.add("0_11_12",["仙桃市"]);
dsy.add("0_11_13",["赤壁市","崇陽縣","嘉魚縣","通城縣","通山縣","咸寧市"]);
dsy.add("0_11_14",["保康縣","谷城縣","老河口市","南漳縣","襄樊市","宜城市","棗陽市"]);
dsy.add("0_11_15",["安陸市","大悟縣","漢川市","孝昌縣","孝感市","應城市","雲夢縣"]);
dsy.add("0_11_16",["長陽土家族自治縣","當陽市","五峰土家族自治縣","興山縣","宜昌市","宜都市","遠安縣","枝江市","秭歸縣"]);
dsy.add("0_12",["常德","長沙","郴州","衡陽","懷化","婁底","邵陽","湘潭","湘西土家族苗族自治州","益陽","永州","岳陽","張家界","株洲"]);
dsy.add("0_12_0",["安鄉縣","常德市","漢壽縣","津市市","臨澧縣","石門縣","桃源縣","澧縣"]);
dsy.add("0_12_1",["長沙市","長沙縣","寧鄉縣","望城縣","瀏陽市"]);
dsy.add("0_12_2",["安仁縣","郴州市","桂東縣","桂陽縣","嘉禾縣","臨武縣","汝城縣","宜章縣","永興縣","資興市"]);
dsy.add("0_12_3",["常寧市","衡東縣","衡南縣","衡山縣","衡陽市","衡陽縣","祁東縣","耒陽市"]);
dsy.add("0_12_4",["辰溪縣","洪江市","懷化市","會同縣","靖州苗族侗族自治縣","麻陽苗族自治縣","通道侗族自治縣","新晃侗族自治縣","中方縣","芷江侗族自治縣","沅陵縣","漵浦縣"]);
dsy.add("0_12_5",["冷水江市","漣源市","婁底市","雙峰縣","新化縣"]);
dsy.add("0_12_6",["城步苗族自治縣","洞口縣","隆回縣","邵東縣","邵陽市","邵陽縣","綏寧縣","武岡市","新寧縣","新邵縣"]);
dsy.add("0_12_7",["韶山市","湘潭市","湘潭縣","湘鄉市"]);
dsy.add("0_12_8",["保靖縣","鳳凰縣","古丈縣","花垣縣","吉首市","龍山縣","永順縣","瀘溪縣"]);
dsy.add("0_12_9",["安化縣","南縣","桃江縣","益陽市","沅江市"]);
dsy.add("0_12_10",["道縣","東安縣","江華瑤族自治縣","江永縣","藍山縣","寧遠縣","祁陽縣","雙牌縣","新田縣","永州市"]);
dsy.add("0_12_11",["華容縣","臨湘市","平江縣","湘陰縣","岳陽市","岳陽縣","汨羅市"]);
dsy.add("0_12_12",["慈利縣","桑植縣","張家界市"]);
dsy.add("0_12_13",["茶陵縣","炎陵縣","株洲市","株洲縣","攸縣","醴陵市"]);
dsy.add("0_13",["白城","白山","長春","吉林","遼源","四平","松原","通化","延邊朝鮮族自治州"]);
dsy.add("0_13_0",["白城市","大安市","通榆縣","鎮賚縣","洮南市"]);
dsy.add("0_13_1",["白山市","長白朝鮮族自治縣","撫松縣","江源縣","靖宇縣","臨江市"]);
dsy.add("0_13_2",["長春市","德惠市","九台市","農安縣","榆樹市"]);
dsy.add("0_13_3",["吉林市","磐石市","舒蘭市","永吉縣","樺甸市","蛟河市"]);
dsy.add("0_13_4",["東豐縣","東遼縣","遼源市"]);
dsy.add("0_13_5",["公主嶺市","梨樹縣","雙遼市","四平市","伊通滿族自治縣"]);
dsy.add("0_13_6",["長嶺縣","扶余縣","乾安縣","前郭爾羅斯蒙古族自治縣","松原市"]);
dsy.add("0_13_7",["輝南縣","集安市","柳河縣","梅河口市","通化市","通化縣"]);
dsy.add("0_13_8",["安圖縣","敦化市","和龍市","龍井市","圖們市","汪清縣","延吉市","琿春市"]);
dsy.add("0_14",["常州","淮安","連雲港","南京","南通","蘇州","宿遷","泰州","無錫","徐州","鹽城","揚州","鎮江"]);
dsy.add("0_14_0",["常州市","金壇市","溧陽市"]);
dsy.add("0_14_1",["洪澤縣","淮安市","金湖縣","漣水縣","盱眙縣"]);
dsy.add("0_14_2",["東海縣","贛榆縣","灌南縣","灌雲縣","連雲港市"]);
dsy.add("0_14_3",["高淳縣","南京市","溧水縣"]);
dsy.add("0_14_4",["海安縣","海門市","南通市","啟東市","如東縣","如皋市","通州市"]);
dsy.add("0_14_5",["常熟市","崑山市","蘇州市","太倉市","吳江市","張家港市"]);
dsy.add("0_14_6",["宿遷市","宿豫縣","沭陽縣","泗洪縣","泗陽縣"]);
dsy.add("0_14_7",["姜堰市","靖江市","泰興市","泰州市","興化市"]);
dsy.add("0_14_8",["江陰市","無錫市","宜興市"]);
dsy.add("0_14_9",["豐縣","沛縣","銅山縣","新沂市","徐州市","邳州市","睢寧縣"]);
dsy.add("0_14_10",["濱海縣","大豐市","東台市","阜寧縣","建湖縣","射陽縣","響水縣","鹽城市","鹽都縣"]);
dsy.add("0_14_11",["寶應縣","高郵市","江都市","揚州市","儀征市"]);
dsy.add("0_14_12",["丹陽市","句容市","揚中市","鎮江市"]);
dsy.add("0_15",["撫州","贛州","吉安","景德鎮","九江","南昌","萍鄉","上饒","新余","宜春","鷹潭"]);
dsy.add("0_15_0",["崇仁縣","東鄉縣","撫州市","廣昌縣","金溪縣","樂安縣","黎川縣","南城縣","南豐縣","宜黃縣","資溪縣"]);
dsy.add("0_15_1",["安遠縣","崇義縣","大余縣","定南縣","贛縣","贛州市","會昌縣","龍南縣","南康市","寧都縣","全南縣","瑞金市","上猶縣","石城縣","信豐縣","興國縣","尋烏縣","於都縣"]);
dsy.add("0_15_2",["安福縣","吉安市","吉安縣","吉水縣","井岡山市","遂川縣","泰和縣","萬安縣","峽江縣","新干縣","永豐縣","永新縣"]);
dsy.add("0_15_3",["浮梁縣","景德鎮市","樂平市"]);
dsy.add("0_15_4",["德安縣","都昌縣","湖口縣","九江市","九江縣","彭澤縣","瑞昌市","武寧縣","星子縣","修水縣","永修縣"]);
dsy.add("0_15_5",["安義縣","進賢縣","南昌市","南昌縣","新建縣"]);
dsy.add("0_15_6",["蓮花縣","蘆溪縣","萍鄉市","上栗縣"]);
dsy.add("0_15_7",["波陽縣","德興市","廣豐縣","橫峰縣","鉛山縣","上饒市","上饒縣","萬年縣","余干縣","玉山縣","弋陽縣","婺源縣"]);
dsy.add("0_15_8",["分宜縣","新余市"]);
dsy.add("0_15_9",["豐城市","奉新縣","高安市","靖安縣","上高縣","銅鼓縣","萬載縣","宜春市","宜豐縣","樟樹市"]);
dsy.add("0_15_10",["貴溪市","鷹潭市","余江縣"]);
dsy.add("0_16",["鞍山","本溪","朝陽","大連","丹東","撫順","阜新","葫蘆島","錦州","遼陽","盤錦","沈陽","鐵嶺","營口"]);
dsy.add("0_16_0",["鞍山市","海城市","台安縣","岫岩滿族自治縣"]);
dsy.add("0_16_1",["本溪滿族自治縣","本溪市","桓仁滿族自治縣"]);
dsy.add("0_
Ⅷ 中國區域簡稱的代碼或數字
中華人民共和國行政區劃代碼
中華人民共和國行政區劃代碼:
國家基礎地理信息系統地形資料庫境界和居民地要素執行國家標准《中華人民共和國行政區劃代碼》(GB
2260-1995),並根據需要擴充了部分代碼。代碼的結構如下:
全國省級行政區劃代碼一覽表:
代碼省(自治區、直轄市)
110000北京市
120000天津市
130000河北省
140000山西省
150000內蒙古自治區
210000遼寧省
220000吉林省
230000黑龍江省
310000上海市
320000江蘇省
330000浙江省
340000安徽省
350000福建省
360000江西省
370000山東省
410000河南省
420000湖北省
430000湖南省
440000廣東省
450000廣西壯族自治區
460000海南省
500000重慶市
510000四川省
520000貴州省
530000雲南省
540000西藏自治區
610000陝西省
620000甘肅省
630000青海省
640000寧夏回族自治區
650000新疆維吾爾自治區
710000台灣省
810000香港特別行政區
910000澳門特別行政區(國家基礎地理信息系統擴充代碼)
北京市(京)
A B(計程車) C E F G(遠郊區縣)天津市(津)
A B C E(計程車)河北省(冀)
A 石家莊市 B 唐山市 C 秦皇島市 D 邯鄲市 E 邢台市 F 保定市 G 張家口市 H 承德市 J 滄州市 R 廊坊市 T 衡水市
山西省(晉)
A 太原市 B 大同市 C 陽泉市 D 長治市 E 晉城市 F 朔州市 H 忻州市 J 呂梁地區 K 晉中市 L 臨汾市 M 運城市
內蒙古自治區(蒙)
A 呼和浩特市B 包頭市 C 烏海市 D 赤峰市 E 呼倫貝爾市F 興安盟 G 通遼市 H 錫林郭勒盟 J 烏蘭察布盟 K 鄂爾多斯市L 巴彥淖爾盟 M 阿拉善盟
遼寧省(遼)
A 沈陽市 B 大連市 C 鞍山市 D 撫順市 E 本溪市 F 丹東市 G 錦州市 H 營口市 J 阜新市 K 遼陽市 L 盤錦市 M 鐵嶺市 N 朝陽市 P 葫蘆島市 V 省直機關
吉林省(吉)
A 長春市 B 吉林市 C 四平市 D 遼源市 E 通化市 F 白山市 G 白城市 H 延邊朝鮮族自治州 J 松原市黑龍江省(黑)
A 哈爾濱市 B 齊齊哈爾市C 牡丹江市D 佳木斯市 E 大慶市 F 伊春市 G 雞西市 H 鶴崗市 J 雙鴨山市 K 七台河市L 松花江地區(已並入哈爾濱市,車牌未改)M 綏化市 N 黑河市 P 大興安嶺地區 R 農墾系統上海市(滬)
A B C (遠郊區縣) D江蘇省(蘇)
A 南京市 B 無錫市 C 徐州市 D 常州市 E 蘇州市 F 南通市 G 連雲港市 H 淮安市 J 鹽城市 K 揚州市 L 鎮江市 M 泰州市 N 宿遷市
浙江省(浙)
A 杭州市 B 寧波市 C 溫州市 D 紹興市 E 湖州市 F 嘉興市 G 金華市 H 衢州市 J 台州市 K 麗水市L 舟山市
安徽省(皖)
A 合肥市 B蕪湖市 C 蚌埠市 D 淮南市 E 馬鞍山市 F 淮北市 G 銅陵市 H 安慶市 J 黃山市 K 阜陽市 L 宿州市 M 滁州市 N 六安市 P 宣城市 Q 巢湖市 R 池州市 S 亳州市
福建省(閩)
A 福州市 B 莆田市 C 泉州市 D 廈門市 E 漳州市 F 龍岩市 G 三明市 H 南平市 J 寧德市 K 省直系統
江西省(贛)
A 南昌市 B 贛州市 C 宜春市 D 吉安市 E 上饒市 F 撫州市 G 九江市 H 景德鎮市 J 萍鄉市 K 新余市 L 鷹潭市 M 南昌,省直系統
山東省(魯)
A 濟南市 B 青島市 C 淄博市 D 棗庄市 E 東營市 F 煙台市 G 濰坊市 H 濟寧市 J 泰安市 K 威海市 L 日照市 M 濱州市 N 德州市 P 聊城市 Q 臨沂市 R 菏澤市 S 萊蕪市 U青島市增補 V濰坊市增補
河南省(豫)
A 鄭州市 B 開封市 C 洛陽市 D 平頂山市 E 安陽市 F 鶴壁市 G 新鄉市 H 焦作市 J 濮陽市 K 許昌市 L 漯河市 M 三門峽市 N 商丘市 P 周口市 Q 駐馬店市 R 南陽市 S 信陽市 U 濟源市
湖北省(鄂)
A 武漢市 B 黃石市 C 十堰市 D 荊州市 E 宜昌市 F 襄樊市 G 鄂州市 H 荊門市 J 黃岡市 K 孝感市 L 咸寧市 M 仙桃市 N 潛江市 P 神農架林區 Q 恩施土家族苗族自治州 R 天門市 S 隨州市
湖南省(湘)
A 長沙市 B 株洲市 C 湘潭市 D 衡陽市 E 邵陽市 F 岳陽市 G 張家界市 H 益陽市 J 常德市 K 婁底市 L 郴州市 M 永州市 N 懷化市 U 湘西土家族苗族自治州
廣東省(粵)
A 廣州市 B 深圳市 C 珠海市 D 汕頭市 E 佛山市 F 韶關市 G 湛江市 H 肇慶市 J 江門市 K 茂名市 L 惠州市 M 梅州市 N 汕尾市 P 河源市 Q 陽江市 R 清遠市 S 東莞市 T 中山市 U 潮州市 V 揭陽市 W 雲浮市 X 順德區 Y 南海區 Z 入境港澳機動車輛
廣西壯族自治區(桂)
A 南寧市 B 柳州市 C 桂林市 D 梧州市 E 北海市 F 南寧地區(部分劃入南寧市,其它部分成立崇左市)G 柳州地區(部分劃入柳州市,其它部分成立來賓市)H 桂林地區(已並入桂林市) J 賀州市 K 玉林市 L百色市 M 河池市 N 欽州市 P 防城港市
R 貴港市
海南省(瓊)
A 海口市 B 三亞市 C 瓊北車輛管理所:瓊山市(已並入海口市)、儋州市、瓊海市、萬寧市、文昌市、澄邁縣、屯昌縣、定安縣、臨高縣D 瓊南車輛管理所:五指山市、東方市、白沙黎族自治縣、昌江黎族自治縣、陵水黎族自治縣、樂東黎族自治縣、保亭黎族苗族自治縣、瓊中黎族苗族自治縣E 洋浦開發區重慶市(渝)
A 直屬車輛管理所 B 江南車輛管理分所 C 永川車輛管理所:永川市、江津市、合川市、潼南縣、銅梁縣、壁山縣、大足縣、綦江縣、榮昌縣 F 萬州車輛管理所:萬州區、梁平縣、城口縣、巫山縣、巫溪縣、忠縣、開縣、奉節縣、雲陽縣 G 涪陵車輛管理所:涪陵區、南川市、墊江縣、豐都縣、武隆縣 H 黔江車輛管理所:黔江區、石柱土家族自治縣、秀山土家族苗族自治縣、酉陽土家族苗族自治縣、彭水苗族土家族自治縣
四川省(川)
A 成都市 B 綿陽市 C 自貢市 D 攀枝花市 E 瀘州市 F 德陽市 H 廣元市 J 遂寧市 K 內江市 L 樂山市 M 資陽市 Q 宜賓市 R 南充市 S 達州市 T 雅安市 U 阿壩藏族羌族自治州 V 甘孜藏族自治州 W 涼山彝族自治州 X 廣安市 Y 巴中市 Z 眉山市川O省交警總隊車管所管理的車牌。但是沒有川I。V甘孜,W涼山。目前沒有N
貴州省(貴)
A 貴陽市 B 六盤水市 C 遵義市 D 銅仁地區 E 黔西南布依族苗族自治州 F 畢節地區 G 安順市 H 黔東南苗族侗族自治州 J 黔南布依族苗族自治州雲南省(雲)
A 昆明市 C 昭通市 D 曲靖市 E 楚雄彝族自治州 F 玉溪市 G 紅河哈尼族彝族自治州 H 文山壯族苗族自治州 J 思茅地區 K 西雙版納傣族自治州 L 大理白族自治州 M 保山市
N 德宏傣族景頗族自治州 P 麗江市 Q 怒江僳僳族自治州 R 迪慶藏族自治州 S 臨滄地區
西藏自治區(藏)
A 拉薩市 B 昌都地區 C 山南地區 D 日喀則地區E 那曲地區 F 阿里地區 G 林芝地區
H自治區駐四川天全車管所J自治區駐青海格爾木車管所
陝西省(陝)
A 西安市 B 銅川市 C 寶雞市 D 咸陽市 E 渭南市 F 漢中市 G 安康市 H 商洛市 J 延安市 K 榆林市 U 省直系統(已取消) V 楊凌高新農業示範區
甘肅省(甘)
A 蘭州市 B 嘉峪關市 C 金昌市 D 白銀市 E 天水市 F 酒泉市 G 張掖市 H 武威市 J 定西地區 K 隴南地區 L 平涼市 M 慶陽市 N 臨夏回族自治州 P 甘南藏族自治州
青海省(青)
A 西寧市 B 海東地區 C 海北藏族自治州 D 黃南藏族自治州 E 海南藏族自治州 F 果洛藏族自治州 G 玉樹藏族自治州 H 海西蒙古族藏族自治州
寧夏回族自治區(寧)
A 銀川市 B 石嘴山市 C 吳忠市 D 固原市
新疆維吾爾自治區(新)
A 烏魯木齊市 B 昌吉回族自治州 C 石河子市 D 奎屯市 E 博爾塔拉蒙古自治州 F 伊犁哈薩克自治州直轄縣、縣級市(原伊寧地區) G 塔城地區 H 阿勒泰地區 J 克拉瑪依市 K 吐魯番地區 L 哈密地區 M 巴音郭楞蒙古自治州 N 阿克蘇地區 P 克孜勒蘇柯爾克孜自治州Q 喀什地區 R 和田地區
Ⅸ 求全國所有城市名稱的sql腳本或者資料庫表
DROP
TABLE
IF
EXISTS
`dict_province`;
CREATE
TABLE
`dict_province`
(
`N_PROVID`
int(10)
unsigned
NOT
NULL
default
'0',
`S_PROVNAME`
varchar(30)
NOT
NULL,
`S_TYPE`
varchar(1)
default
NULL
COMMENT
'1
-
直轄市\r\n2
-
行政省\r\n3
-
自治區\r\n4
-
特別行政區\r\n5
-
其他國家\r\n見全局數據字典[省份類型]
\r\n',
`S_STATE`
varchar(1)
default
NULL
COMMENT
'0
-
禁用\r\n1
-
啟用',
PRIMARY
KEY
(`N_PROVID`)
)
ENGINE=InnoDB
DEFAULT
CHARSET=utf8;
LOCK
TABLES
`dict_province`
WRITE;
/*!40000
ALTER
TABLE
`dict_province`
DISABLE
KEYS
*/;
INSERT
INTO
`dict_province`
VALUES
(1,'國外','5','1'),(10,'北京','1','1'),(11,'上海','1','1'),(12,'天津','1','1'),(13,'重慶','1','1'),(14,'河北','2','1'),(15,'山西','2','1'),(16,'內蒙古','3','1'),(17,'遼寧','2','1'),(18,'吉林','2','1'),(19,'黑龍江','2','1'),(20,'江蘇','2','1'),(21,'浙江','2','1'),(22,'安徽','2','1'),(23,'福建','2','1'),(24,'江西','2','1'),(25,'山東','2','1'),(26,'河南','2','1'),(27,'湖北','2','1'),(28,'湖南','2','1'),(29,'廣東','2','1'),(30,'廣西','3','1'),(31,'海南','2','1'),(32,'四川','2','1'),(33,'貴州','2','1'),(34,'雲南','2','1'),(35,'西藏','3','1'),(36,'陝西','2','1'),(37,'甘肅','2','1'),(38,'青海','2','1'),(39,'寧夏','3','1'),(40,'新疆','3','1'),(41,'香港','4','1'),(42,'澳門','4','1'),(43,'台灣','2','1');
/*!40000
ALTER
TABLE
`dict_province`
ENABLE
KEYS
*/;
UNLOCK
TABLES;
Ⅹ 求中國行政區劃代碼
中華人民共和國行政區劃代碼
中華人民共和國行政區劃代碼:
國家基礎地理信息系統地形資料庫境界和居民地要素執行國家標准《中華人民共和國行政區劃代碼》(GB
2260-1995),並根據需要擴充了部分代碼。代碼的結構如下:
全國省級行政區劃代碼一覽表:
代碼省(自治區、直轄市)
110000北京市
120000天津市
130000河北省
140000山西省
150000內蒙古自治區
210000遼寧省
220000吉林省
230000黑龍江省
310000上海市
320000江蘇省
330000浙江省
340000安徽省
350000福建省
360000江西省
370000山東省
410000河南省
420000湖北省
430000湖南省
440000廣東省
450000廣西壯族自治區
460000海南省
500000重慶市
510000四川省
520000貴州省
530000雲南省
540000西藏自治區
610000陝西省
620000甘肅省
630000青海省
640000寧夏回族自治區
650000新疆維吾爾自治區
710000台灣省
810000香港特別行政區
910000澳門特別行政區(國家基礎地理信息系統擴充代碼)