Mysql作业（4）

目录 

要求

代码

---

要求

代码 

1、mysql> ALTER TABLE student MODIFY sage smallint;
2、mysql> CREATE INDEX idx_Cno ON Course(Cno);
3、mysql> CREATE UNIQUE INDEX SC_INDEX
    -> ON SC (sno, cno asc)
4、mysql> create view stu_info as
    -> select Sname ,Ssex , sdept,score from student s join sc on s.Sno = sc.sno ;
5、 drop index idx_Cno  on sc  ;
     drop index SC_INDEX  on sc  ;