视图

Submitted by yejr on 周四, 2006/11/16 - 17:20

A.6. MySQL 5.0 FAQ — 视图

Questions

  • 26.6.1: 在哪里有MySQL视图的文档?

    Where can I find documentation for MySQL Views?

  • 26.6.2:
    在哪里有关于MySQL视图的讨论?

    Is there a discussion forum for MySQL Views?

  • 26.6.3:
    如果数据表被删除或改名了,则它之下的视图会发生什么情况?

    What happens to a view if an underlying table is dropped or renamed?

  • 26.6.4:
    MySQL 5.0有表快照吗?

    Does MySQL 5.0 have table snapshots?

  • 26.6.5:
    MySQL 5.0有实际存在的视图吗?

    Does MySQL 5.0 have materialized views?

  • 26.6.6:
    能否往视图中插入基于表连接的数据?

    Can you insert into views that are based on joins?

Questions and Answers

26.6.1:
Where can I find documentation for MySQL Views?

详情请看 Chapter 19, Views.

See Chapter 19, Views.

26.6.2:
Is there a discussion forum for MySQL Views?

是的.详情请看 http://forums.mysql.com/list.php?100.

Yes. See
http://forums.mysql.com/list.php?100

26.6.3:
What happens to a view if an underlying table is dropped or
renamed?

视图创建之后,由于引用的定义,可能会发生删除/修改数据表/视图的行为.想要检查这种定义下的视图会发生什么问题,请使用 CHECK TABLE 语句来检查.详情请看 Section 13.5.2.3, “CHECK TABLE Syntax”.

After a view has been created, it is possible to drop or
alter a table or view to which the definition refers. To
check a view definition for problems of this kind, use the
CHECK TABLE statement. (See
Section 13.5.2.3, “CHECK TABLE Syntax”.)

26.6.4:
Does MySQL 5.0 have table snapshots?

没有.

No.

26.6.5:
Does MySQL 5.0 have materialized views?

没有.

No.

26.6.6:
Can you insert into views that are based on joins?

可能,如果你的 INSERT 语句指定了字段列表,明确地只包含一个数据表.

你 无法 通过向视图中插入一条记录达到多表插入的目的.

It is possible, provided that your INSERT
statement has a column list that makes it clear there's only
one table involved.

You cannot insert into multiple tables
with a single insert on a view.

技术相关: