- A.6.1. Where can I find documentation covering MySQL Views?
- A.6.2. Is there a discussion forum for MySQL Views?
- A.6.3. What happens to a view if an underlying table is dropped or renamed?
- A.6.4. Does MySQL 8.3 have table snapshots?
- A.6.5. Does MySQL 8.3 have materialized views?
- A.6.6. Can you insert into views that are based on joins?
A.6.1. |
Where can I find documentation covering MySQL Views? |
See Section 27.5, “Using Views”. You may also find the MySQL User Forums to be helpful. |
|
A.6.2. |
Is there a discussion forum for MySQL Views? |
See the MySQL User Forums. |
|
A.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 |
|
A.6.4. |
Does MySQL 8.3 have table snapshots? |
No. |
|
A.6.5. |
Does MySQL 8.3 have materialized views? |
No. |
|
A.6.6. |
Can you insert into views that are based on joins? |
It is possible, provided that your You cannot insert into multiple tables with a single insert on a view. |