MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
- 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.0 have table snapshots?
- A.6.5. Does MySQL 8.0 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? |
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? |
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.0 have table snapshots? |
No. | |
A.6.5. | Does MySQL 8.0 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. |