- A Frequently Asked Questions About MySQL 5.1
- A.1 MySQL 5.1 FAQ — General
- A.2 MySQL 5.1 FAQ — Storage Engines
- A.3 MySQL 5.1 FAQ — Server SQL Mode
- A.4 MySQL 5.1 FAQ — Stored Procedures
- A.5 MySQL 5.1 FAQ — Triggers
- A.6 MySQL 5.1 FAQ — Stored Routines, Triggers, and Replication
- A.7 MySQL 5.1 FAQ — Views
- A.8 MySQL 5.0 FAQ — INFORMATION_SCHEMA
- A.9 MySQL 5.1 FAQ — Migration
- A.10 MySQL 5.1 FAQ — Security
- A.11 MySQL 5.1 FAQ — MySQL Cluster
- A.12 MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets
- A.13 MySQL 5.1 FAQ — Connectors & APIs
Questions
26.7.1: Where can I find documentation covering MySQL Views?
26.7.2: Is there a discussion forum for MySQL Views?
26.7.3: What happens to a view if an underlying table is dropped or renamed?
26.7.4: Does MySQL 5.1 have table snapshots?
26.7.5: Does MySQL 5.1 have materialized views?
26.7.6: Can you insert into views that are based on joins?
Questions and Answers
26.7.1: Where can I find documentation covering MySQL Views?
See 章 20. ビュー.
26.7.2: Is there a discussion forum for MySQL Views?
Yes. See http://forums.mysql.com/list.php?100
26.7.3: What happens to a view if an underlying table is dropped or renamed?
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
項12.5.2.3. 「CHECK TABLE 構文」.)
26.7.4: Does MySQL 5.1 have table snapshots?
No.
26.7.5: Does MySQL 5.1 have materialized views?
No.
26.7.6: Can you insert into views that are based on joins?
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.
