Source code editor
What Is Ajax
26.6.1: Where can I find documentation for MySQL Views?
26.6.2: 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: Does MySQL 5.0 have table snapshots?
26.6.5: Does MySQL 5.0 have materialized views?
26.6.6: Can you insert into views that are based on joins?
Questions and Answers
See Chapter 19, Views.
Yes. See http://forums.mysql.com/list.php?100
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 188.8.131.52, “
CHECK TABLE Syntax”.)
It is possible, provided that your
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.
Source code editor What Is Ajax