资源描述:
《sql数据库省市区数据建表和数据》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、--表的结构areaDROPTABLEArea;CREATETABLEArea(IDintNOTNULL,AreaIDintNOTNULL,AreaNamevarchar(200)NOTNULL,FatherIDintNOTNULL,PRIMARYKEY(ID))DROPTABLECity;CREATETABLECity(IDintNOTNULL,CityIDintNOTNULL,CityNamevarchar(200)NOTNULL,FatherIDintNOTNULL,PRIMARYKEY(ID))----导出表中的数据city--------
2、--------------------------------------------------------表的结构province--DROPTABLEProvince;CREATETABLEProvince(IDintNOTNULL,ProvinceIDintNOTNULL,ProvinceNamevarchar(200)NOTNULL,PRIMARYKEY(ID))insertProvince(ID,ProvinceID,ProvinceName)select1,110000,'北京市'unionselect2,120000,'天津市'u
3、nionselect3,130000,'河北省'unionselect4,140000,'山西省'unionselect5,150000,'内蒙古自治区'unionselect6,210000,'辽宁省'unionselect7,220000,'吉林省'unionselect8,230000,'黑龙江省'unionselect9,310000,'上海市'unionselect10,320000,'江苏省'unionselect11,330000,'浙江省'unionselect12,340000,'安徽省'unionselect13,350000,
4、'福建省'unionselect14,360000,'江西省'unionselect15,370000,'山东省'unionselect16,410000,'河南省'unionselect17,420000,'湖北省'unionselect18,430000,'湖南省'unionselect19,440000,'广东省'unionselect20,450000,'广西壮族自治区'unionselect21,460000,'海南省'unionselect22,500000,'重庆市'unionselect23,510000,'四川省'unionsel
5、ect24,520000,'贵州省'unionselect25,530000,'云南省'unionselect26,540000,'西藏自治区'unionselect27,610000,'陕西省'unionselect28,620000,'甘肃省'unionselect29,630000,'青海省'unionselect30,640000,'宁夏回族自治区'unionselect31,650000,'新疆维吾尔自治区'unionselect32,710000,'台湾省'unionselect33,810000,'香港特别行政区'unionselec
6、t34,820000,'澳门特别行政区'INSERTCity(ID,CityID,CityName,FatherID)select1,110100,'市辖区',110000unionselect2,110200,'县',110000unionselect3,120100,'市辖区',120000unionselect4,120200,'县',120000unionselect5,130100,'石家庄市',130000unionselect6,130200,'唐山市',130000unionselect7,130300,'秦皇岛市',130000u
7、nionselect8,130400,'邯郸市',130000unionselect9,130500,'邢台市',130000unionselect10,130600,'保定市',130000unionselect11,130700,'张家口市',130000unionselect12,130800,'承德市',130000unionselect13,130900,'沧州市',130000unionselect14,131000,'廊坊市',130000unionselect15,131100,'衡水市',130000unionselect16,1
8、40100,'太原市',140000unionselect17,140200,'大同市',140000unionselec