MySQL【知识改变命运】12

# 语法
CREATE VIEW view_name [(column_list)] AS select_statement
create view//创建视图关键词
view_name// 视图名
column_list//视图包含的列
select_statement//视图所依赖的查询语句

# 使⽤真实表进⾏查询
select s.name, sum(sc.score) total from student s, score sc 
where s.id = sc.student_id
group by sc.student_id order by s.id;

# 如果使⽤真实表，在查询列表中随时可以加上学号字段

# 创建视图
create view v_student_total_points as
select s.id, s.name, sum(sc.score) total from student s, score sc 
where s.id = sc.student_id 
group by s.id order by s.id;
# 使⽤视图查询，只能查到学⽣姓名和总分，不能再添加查询字段

select * from v_student_total_points v, student s where v.id = s.id;

语法：
drop view view_name;