MYSQL第四次作业

一、第四次作业

 

二、处理表

1、ALTER TABLE Student MODIFY COLUMN Sage SMALLINT;

2、CREATE INDEX idx_Course_Cno ON Course(Cno); SHOW INDEXES FROM Course;

3、ALTER TABLE SC ADD CONSTRAINT PK_SC PRIMARY KEY (Sno, Cno);

4、CREATE VIEW stu_info AS SELECT S.Sname, S.Ssex, C.Cname, SC.Score FROM         Student S JOIN SC ON S.Sno = SC.Sno JOIN Course C ON C.Cno = SC.Cno;

5、ALTER TABLE Course DROP INDEX idx_Course_Cno;