SQL视图

视图
1、创建女生全部信息的视图
create or replace view v_falesyu as select * from student where ssex='女'with check option 
操作 select * from v_falesyu 
drop view v_falesyu
desc v_falesyu
show table status like 'v_falesyu'
show create view v_falesyu
select * from information_schema.VIEWS
INSERT into v_falesyu value ('111','rose','女',20,'01')
问题 with option
insert into v_falesyu value ('111','smith','女',20，'01')
2、创建接口原理这门课程所有学生成绩视图
CREATE or replace view v_jkylsc as select * from score where cno=(select cno from course where cname='接口原理')with check option 
3、创建每一门课的平均成绩视图
create or replace view v_avgrade as select  cno,avg(grade)pjcj from score group by cno
问题：计算的不可以被修改
update v_avgrade  set pjcj=70 where cno='A001' 
4、创建计算机学院所有学生基本信息的视图
create or replace view v_jsjstu as select * from student where deptno=(select deptno from sdept where dname='计算机与信息工程学院')with CHECK option  
select * from v_jsjstu