Questions
23.6.1: Does MySQL 5.5 have table snapshots?
23.6.2: Does MySQL 5.5 have materialized views?
23.6.3: What happens to a view if an underlying table is dropped or renamed?
23.6.4: Is there a discussion forum for MySQL Views?
23.6.5: Where can I find documentation covering MySQL Views?
23.6.6: Can you insert into views that are based on joins?
Questions and Answers
23.6.1: Does MySQL 5.5 have table snapshots?
No.
23.6.2: Does MySQL 5.5 have materialized views?
No.
23.6.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
Section 12.4.2.2, “CHECK TABLE
Syntax”.)
23.6.4: Is there a discussion forum for MySQL Views?
Yes. See http://forums.mysql.com/list.php?100
23.6.5: Where can I find documentation covering MySQL Views?
See Section 18.5, “Using Views”.
23.6.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 is only one table involved.
You cannot insert into multiple tables with a single insert on a view.
User Comments
Add your own comment.