MySQL视图

合集 - MySQL学习笔记(11)

1.Linux安装MySQL2024-04-162.MySQL登录2024-04-16

3.MySQL视图2024-04-16

4.MySQL索引2024-04-165.MySQL存储过程与函数2024-04-176.MySQL游标2024-04-177.MySQL触发器2024-04-178.MySQL体系结构2024-04-179.MySQL存储引擎2024-04-1710.使用mysqlclient库连接mysql2024-04-2011.MySQL日志2024-08-23

收起

MySQL视图

创建或修改视图

创建视图

CREATE [OR REPLACE] [ALGORITHM = {UNIFINED | MERGE | TEMPLATE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

修改视图

ALTER [ALGORITHM = {UNIFINED | MERGE | TEMPLATE}]
VIEW view_name [(column_list)]\
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

WITH [CASCADED | LOCAL] CHECK OPTION决定了是否允许更新数据使记录不再满足视图的条件。

• LOCAL：只要满足本视图的条件就可以更新。
• CASDED：必须满足所有针对该视图的所有视图的条件才可以更新。

查看视图

show tables;可以查看表和视图

show table status;既可以查看表也可以查看视图信息。

删除视图

DROP VIEW [IF EXISTS] view_name [, view_name] ...[RESTRICT | CASCADE];