A.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
「CHECK TABLE 構文」.)
A.7.4:
Does MySQL 5.1 have table snapshots?
No.
A.7.5:
Does MySQL 5.1 have materialized views?
No.
A.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.
© 2013, Oracle Corporation and/or its affiliates
