Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  /  Stored Objects  /  Using Views

27.6 Using Views

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”.

Additional Resources