sql索引，视图

mysql> alter table student modify sage smallint;
mysql> show create table course\G

mysql> create unique index sc_index on sc (sno asc,cno asc);
mysql> create view stu_info as select sname,ssex,cname,score from student join sc on student.sno=sc.sno  join course on sc.cno=course.cno;