MySQL 8.4 Release Notes
A.6 MySQL 8.4 常见问题解答：视图
- 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 have table snapshots?
- A.6.5. Does MySQL 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 have table snapshots? |
|
No. |
|
|
A.6.5. |
Does MySQL 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. |