资源描述：
《sql数据库区数据建表和数据》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、--表的结构areaDROPTABLEarea;CREATETABLEarea(idintNOTNULL,areaIDintNOTNULL,areavarchar(200)NOTNULL,fatherIDintNOTNULL,PRIMARYKEY(id))DROPTABLEcity;CREATETABLEcity(idintNOTNULL,cityIDintNOTNULL,cityvarchar(200)NOTNULL,fatherIDintNOTNULL,PRIMARYKEY(id))----导出表中的数据city------
2、----------------------------------------------------------表的结构province--DROPTABLEprovince;CREATETABLEprovince(idintNOTNULL,provinceIDintNOTNULL,provincevarchar(200)NOTNULL,PRIMARYKEY(id))insertprovince(id,provinceID,province)select1,110000,'北京市'unionselect2,120000,'天
3、津市'unionselect3,130000,'河北省'union82/82select4,140000,'山西省'unionselect5,150000,'内蒙古自治区'unionselect6,210000,'辽宁省'unionselect7,220000,'吉林省'unionselect8,230000,'黑龙江省'unionselect9,310000,'上海市'unionselect10,320000,'江苏省'unionselect11,330000,'浙江省'unionselect12,340000,'安徽省'un
4、ionselect13,350000,'福建省'unionselect14,360000,'江西省'unionselect15,370000,'山东省'unionselect16,410000,'河南省'unionselect17,420000,'湖北省'unionselect18,430000,'湖南省'unionselect19,440000,'广东省'unionselect20,450000,'广西壮族自治区'unionselect21,460000,'海南省'unionselect22,500000,'重庆市'union
5、select23,510000,'四川省'unionselect24,520000,'贵州省'unionselect25,530000,'云南省'unionselect26,540000,'西藏自治区'unionselect27,610000,'陕西省'unionselect28,620000,'甘肃省'unionselect29,630000,'青海省'unionselect30,640000,'宁夏回族自治区'unionselect31,650000,'新疆维吾尔自治区'unionselect32,710000,'台湾省'u
6、nionselect33,810000,'香港特别行政区'unionselect34,820000,'澳门特别行政区'INSERTcity(id,cityID,city,fatherID)select1,110100,'市辖区',110000unionselect2,110200,'县',110000unionselect3,120100,'市辖区',120000unionselect4,120200,'县',120000unionselect5,130100,'石家庄市',130000unionselect6,130200,'
7、唐山市',130000unionselect7,130300,'秦皇岛市',130000unionselect8,130400,'邯郸市',130000unionselect9,130500,'邢台市',130000unionselect10,130600,'保定市',130000union82/82select11,130700,'张家口市',130000unionselect12,130800,'承德市',130000unionselect13,130900,'沧州市',130000unionselect14,131000,
8、'廊坊市',130000unionselect15,131100,'衡水市',130000unionselect16,140100,'太原市',140000unionselect17,140200,'大同市',140000unionselect18,140300
