Mysql创建和管理视图

建立和使用视图
在teacher表上创建一个简单的视图，视图名称为v_teacher。

mysql> create view v_teacher
    -> as select *from teacher;

mysql> select *from v_teacher;

查看视图定义情况。

mysql>show create view stu_score;

⑤修改视图v_teach，统计材料学院的教师中的教授和副教授的教师号、教师名、和专业，并在视图名后面指明视图列名称。

mysql> alter view  v_teach (教师号,教师名,专业)
-> as select  teacherno, tname, major
-> from  teach_view1
-> where  prof  like  '%教授'  and  department='材料学院' ;
mysql> select  * from  v_teach;

⑥ 删除视图v_teach命令：

mysql> drop view v_teach;