mysql视图文件扩展名_MySQL视图(view)

最新推荐文章于 2022-09-01 10:34:10 发布

吕桂华

最新推荐文章于 2022-09-01 10:34:10 发布

阅读量324

点赞数

文章标签： mysql视图文件扩展名

本文链接：https://blog.csdn.net/weixin_29533307/article/details/113905123

版权

本文介绍了MySQL中视图的概念，从5.0版本开始支持。视图可以是不可插入的，但如果仅更新非派生列，则可更新。例如，创建了一个包含派生列的视图，并展示了不同检查选项（LOCAL和CASCADED）如何影响插入操作。当试图插入不符合底层视图条件的数据时，会触发错误。通过示例展示了如何在v2和v3视图上使用这些选项，说明了LOCAL和CASCADED的区别。

摘要由CSDN通过智能技术生成

view acts as a virtual table. Views are available in binary releases from 5.0.1 and up. 视图是从5.0 开始支持，是一张虚拟

从5.0开始就支持)A view that has a mix of simple column references and derived columns is not insertable, but it can be updatable if you update only those columns that are not derived. Consider this view:

CREATE VIEW v AS SELECT col1, 1 AS col2 FROM t; #col2是派生列

UPDATE v SET col1 = 0;#允许

causes the checks for underlying views to be evaluated as well. When neither keyword is given, the default is CASCADED. Consider the definitions for the following table and set of views:

mysql> CREATE TABLE t1 (a INT);

mysql> CREATE VIEW v1 AS SELECT * FROM t1 WHERE a < 2

-> WITH CHECK OPTION;

mysql> CREATE VIEW v2 AS SELECT * FROM v1 WHERE a > 0

-> WITH LOCAL CHECK OPTION;

mysql> CREATE VIEW v3 AS SELECT * FROM v1 WHERE a > 0

-> WITH CASCADED CHECK OPTION;

Here the v2 and v3 views are defined in terms of another view, v1. v2 has a LOCAL check option, so inserts are tested only against the v2 check. v3 has a CASCADED check option, so inserts are tested not only against its own check, but against those of underlying views. The following statements illustrate these differences:

mysql> INSERT INTO v2 VALUES (2);

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO v3 VALUES (2);ERROR 1369 (HY000): CHECK OPTION failed 'test.v3'

相关阅读：MySQL视图表创建与修改

，