
MySQL进阶-视图

1.基本命令
1 | -- 创建视图 |
2.检查选项cascaded
1 | create view v1 as select * from t1 with cascaded check option; |
3.视图的更新
视图必须与基础表一一对应才能增删改
4.视图作用
- 简单 将常用的sql封装成视图 简化操作
- 安全 权限分配
- 数据独立 屏蔽真实的表结构
- Title: MySQL进阶-视图
- Author: Jason
- Created at : 2023-09-07 17:50:02
- Updated at : 2023-09-10 16:00:49
- Link: https://xxxijason1201.github.io/2023/09/07/MySQL/视图/
- License: This work is licensed under CC BY-NC-SA 4.0.
Comments