Where can I find documentation covering MySQL Views?
See *note views::.
You may also find the MySQL User Forums (https://forums.mysql.com/list.php?20) to be helpful.
Is there a discussion forum for MySQL Views?
See the MySQL User Forums (https://forums.mysql.com/list.php?20).
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 note 'CHECK TABLE': check-table. statement. (See note check-table::.)
Does MySQL have table snapshots?
No.
Does MySQL have materialized views?
No.
Can you insert into views that are based on joins?
It is possible, provided that your *note 'INSERT': 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.
File: manual.info.tmp, Node: faqs-information-schema, Next: faqs-migration, Prev: faqs-views, Up: faqs