27.6 Using Views

27.6.1 View Syntax

27.6.2 View Processing Algorithms

27.6.3 Updatable and Insertable Views

27.6.4 The View WITH CHECK OPTION Clause

27.6.5 View Metadata

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 9.1 FAQ: Views”.

• There are some restrictions on the use of views; see Section 27.10, “Restrictions on Views”.