4.MYSQL视图

小恐龙观铃

于 2023-12-02 11:14:54 发布

阅读量348

点赞数 9

分类专栏：进阶 Mysql 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/m0_69844818/article/details/134749527

版权

Mysql 同时被 2 个专栏收录

16 篇文章 0 订阅

订阅专栏

进阶

13 篇文章 0 订阅

订阅专栏

create or replace view stu_v_1 as select id,name from student where id <=10;
show create view stu_v_1;select * from stu_v_1;
创建覆盖视图
create or replace view stu_v_1 as select id,name from student where id<=10;

create or replace view stu_v_1 as select id,name from student where id <= 20

create or replace view stu_v_1 as select id,name from student where id <=20;
select * from student;select * from stu_v_1;
insert into stu_v_1 values(6,'Tom');

在某个视图创建的时候增加的 with cascaded check option