//创建、修改视图
create or replace view view_temp
as
select name, age from temp;
//通常不对视图的数据做修改操作,因为视图是一张虚拟的表,它并不存储实际数据。如果想让视图不被修改,可以用with check option来完成限制。
create or replace view view_temp
as
select *from temp
with check option;
//删除视图
drop view view_temp;
//显示创建语法
show create view v_temp;
显示学生成绩单的视图
1
2
3
4
mysql> create view student_cj as select students.number,students.name,course.math,course.english,course.chinese
-> from students,course
-> where students.number=course.number;
Query OK, 0 rows affected (0.00 sec)