MySQL :: MySQL 8.0 Reference Manual :: 27.5 Using Views (original) (raw)

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 following discussion describes the syntax for creating and dropping views, and shows some examples of how to use them.

Additional Resources

• 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 8.0 FAQ: Views”.
• There are some restrictions on the use of views; seeSection 27.9, “Restrictions on Views”.