文章目录
视图
目的:对于复杂的查询,在多个地方被使用,如果需求发生改变,需要更改SQL语句,则需要在多个地方进行修改,维护起来非常麻烦,所以就需要视图来进行封装
视图本身就是对查询的封装
定义视图,建议以v_开头
create view 视图名称 as select语句;
例:
create view v_stu_score_course as
select stu.*, cs.courseNo, cs.name as courseName, sc.score
from students as stu
inner join scores as sc on stu.studentNo=sc.studentNo
inner join courses as cs on cs.courseNo=sc.courseNo;
查看视图
show tables;
select * from 视图名称;
删除视图
drop view 视图名称;