sql全國 省市 聯動級聯

/*添加省份表數據*/  INSERT?intO?Province(Pcode,Pname,NationCode)?VALUES(110000,'北京市',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(120000,'天津市',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(130000,'河北省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(140000,'山西省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(150000,'內蒙古自治區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(210000,'遼寧省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(220000,'吉林省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(230000,'黑龍江',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(310000,'上海市',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(320000,'江蘇省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(330000,'浙江省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(340000,'安徽省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(350000,'福建省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(360000,'江西省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(370000,'山東省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(410000,'河南省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(420000,'湖北省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(430000,'湖南省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(440000,'廣東省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(450000,'廣西壯族自治區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(460000,'海南省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(500000,'重慶市',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(510000,'四川省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(520000,'貴州省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(530000,'云南省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(540000,'西藏自治區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(610000,'陜西省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(620000,'甘肅省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(630000,'青海省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(640000,'寧夏回族自治區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(650000,'新疆維吾爾自治區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(710000,'臺灣省',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(810000,'香港特別行政區',100000)  INSERT?INTO?Province(Pcode,Pname,NationCode)?VALUES(820000,'澳門特別行政區',100000)
? 版權聲明
THE END
喜歡就支持一下吧
點贊12 分享