MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4
MySQL supports views, including updatable views. Views are stored queries that when invoked produce a result set. A view acts as a virtual table.
The next few sections describe the syntax for creating and dropping views, and show some examples of how to use them.
This section discusses SQL views, which are created using the
CREATE VIEW statement. MySQL
9.4 also supports JSON duality views, which are created
using the CREATE JSON DUALITY VIEW
statement; for information about these, see
Section 27.7, “JSON Duality Views”.
You may find the MySQL User Forums helpful when working with views.
For answers to some commonly asked questions regarding views in MySQL, see Section A.6, “MySQL 9.4 FAQ: Views”.
There are some restrictions on the use of views; see Section 27.11, “Restrictions on Views”.