數(shù)據(jù)庫原理與應(yīng)用實驗報告-wenkub.com
2025-07-18 11:27 本頁面
【正文】 P239。一鍵39。天津39。J239。P139。杭州39。紅39。P139。J139。J139。S639。J339。S639。J239。S639。J739。S539。J539。S539。J439。S439。J439。S439。J339。S439。J239。S439。J139。S339。J139。S339。J639。S239。J539。S239。J739。S239。J439。S239。J339。S239。J239。S239。J139。S239。J739。S139。J639。S139。J539。S139。J239。S139。J339。S139。機(jī)械廠39。重慶39。J639。機(jī)床廠39。北京39。J439。拉鏈廠39。廣州39。J239。一鍵39。2839。傳送帶39。1739。齒輪39。5339。螺釘39。2739。螺栓39。1239。螺母39。2539。螺絲39。3439。釘子39。太原39。S639?；?9。上海39。S439。天遠(yuǎn)39。杭州39。S239。利群39。c:\jiangxue\39。c:\jiangxue\39。178。178。對數(shù)據(jù)庫進(jìn)行單表查詢、連接查詢、嵌套查詢、集合查詢和統(tǒng)計查詢。2. 實驗內(nèi)容178。 更改基本表的定義: 增加列，刪除列，修改列的數(shù)據(jù)類型。 刪除基本表的約束、基本表的索引或基本表。,SIZE=10,MAXSIZE=50,FILEGROWTH=5)LOG ON(NAME=39。,SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)2)用SQL語言創(chuàng)建供應(yīng)商表create table jiangxue_S(Sno char(5) primary key,Sname char(20) not null,Status int,City char(20) not null)create table jiangxue_P(Pno char(5) primary key,Pname char(20) not null,Color char(20) not null,Weight int)create table jiangxue_J(Jno char(5) primary key,Jname char(20) not null,City char(20) not null,)create table jiangxue_SPJ(Sno char(5),Pno char(5),Jno char(5),QTY int,primary key(Sno,Pno,Jno),constraint S_SPJ foreign key(Sno) references jiangxue_S,constraint P_SPJ foreign key(Pno) references jiangxue_P,constraint J_SPJ foreign key(Jno) references jiangxue_J) 3)將數(shù)據(jù)插入各表insert into jiangxue_Svalues(39。,30,39。,39。)insert into jiangxue_Svalues(39。,60,39。,39。)insert into jiangxue_Svalues(39。,80,39。,39。)insert into ji
規(guī)章制度相關(guān)推薦
鄂ICP備17016276號-1