<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="views">
      </a>
      27.5 Using Views
     </h2>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="view-syntax.html">
       27.5.1 View Syntax
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="view-algorithms.html">
       27.5.2 View Processing Algorithms
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="view-updatability.html">
       27.5.3 Updatable and Insertable Views
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="view-check-option.html">
       27.5.4 The View WITH CHECK OPTION Clause
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="view-metadata.html">
       27.5.5 View Metadata
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045081912128">
  </a>
  <p>
   MySQL supports views, including updatable views. Views are stored
    queries that when invoked produce a result set. A view acts as a
    virtual table.
  </p>
  <p>
   The following discussion describes the syntax for creating and
    dropping views, and shows some examples of how to use them.
  </p>
  <h3>
   <a name="idm46045081909968">
   </a>
   Additional Resources
  </h3>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      You may find the
      <a class="ulink" href="https://forums.mysql.com/list.php?20" target="_blank">
       MySQL
        User Forums
      </a>
      helpful when working with views.
     </p>
    </li>
    <li class="listitem">
     <p>
      For answers to some commonly asked questions regarding views in
        MySQL, see
      <a class="xref" href="faqs-views.html" title="A.6 MySQL 8.4 FAQ: Views">
       Section A.6, “MySQL 8.4 FAQ: Views”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      There are some restrictions on the use of views; see
      <a class="xref" href="view-restrictions.html" title="27.9 Restrictions on Views">
       Section 27.9, “Restrictions on Views”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
