<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="faqs-views">
      </a>
      A.6 MySQL 8.4 FAQ: Views
     </h2>
    </div>
   </div>
  </div>
  <div class="qandaset">
   <a name="idm46045056174800">
   </a>
   <dl>
    <dt>
     A.6.1.
     <a href="faqs-views.html#faq-mysql-where-docs-views">
      Where can I find documentation covering MySQL Views?
     </a>
    </dt>
    <dt>
     A.6.2.
     <a href="faqs-views.html#faq-mysql-where-views-forum">
      Is there a discussion forum for MySQL Views?
     </a>
    </dt>
    <dt>
     A.6.3.
     <a href="faqs-views.html#faq-mysql-where-view-dropped-table">
      What happens to a view if an underlying table is dropped or
        renamed?
     </a>
    </dt>
    <dt>
     A.6.4.
     <a href="faqs-views.html#faq-mysql-have-table-snapshots">
      Does MySQL have table snapshots?
     </a>
    </dt>
    <dt>
     A.6.5.
     <a href="faqs-views.html#faq-mysql-have-materialized-views">
      Does MySQL have materialized views?
     </a>
    </dt>
    <dt>
     A.6.6.
     <a href="faqs-views.html#faq-mysql-can-insert-joins-views">
      Can you insert into views that are based on joins?
     </a>
    </dt>
   </dl>
   <table border="0" style="width: 100%;">
    <colgroup>
     <col align="left" width="1%"/>
     <col/>
    </colgroup>
    <tbody>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-where-docs-views">
       </a>
       <a name="idm46045056174032">
       </a>
       <p>
        <b>
         A.6.1.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        Where can I find documentation covering MySQL Views?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        See
        <a class="xref" href="views.html" title="27.5 Using Views">
         Section 27.5, “Using Views”
        </a>
        .
       </p>
       <p>
        You may also find the
        <a class="ulink" href="https://forums.mysql.com/list.php?20" target="_blank">
         MySQL User Forums
        </a>
        to be helpful.
       </p>
      </td>
     </tr>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-where-views-forum">
       </a>
       <a name="idm46045056170080">
       </a>
       <p>
        <b>
         A.6.2.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        Is there a discussion forum for MySQL Views?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        See the
        <a class="ulink" href="https://forums.mysql.com/list.php?20" target="_blank">
         MySQL User
        Forums
        </a>
        .
       </p>
      </td>
     </tr>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-where-view-dropped-table">
       </a>
       <a name="idm46045056167296">
       </a>
       <p>
        <b>
         A.6.3.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        What happens to a view if an underlying table is dropped or
        renamed?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        After a view has been created, it is possible to drop or alter a
        table or view to which the definition refers. To check a view
        definition for problems of this kind, use the
        <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
         <code class="literal">
          CHECK TABLE
         </code>
        </a>
        statement. (See
        <a class="xref" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
         Section 15.7.3.2, “CHECK TABLE Statement”
        </a>
        .)
       </p>
      </td>
     </tr>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-have-table-snapshots">
       </a>
       <a name="idm46045056163120">
       </a>
       <p>
        <b>
         A.6.4.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        Does MySQL have table snapshots?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        No.
       </p>
      </td>
     </tr>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-have-materialized-views">
       </a>
       <a name="idm46045056161168">
       </a>
       <p>
        <b>
         A.6.5.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        Does MySQL have materialized views?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        No.
       </p>
      </td>
     </tr>
     <tr class="question">
      <td align="left" valign="top">
       <a name="faq-mysql-can-insert-joins-views">
       </a>
       <a name="idm46045056159152">
       </a>
       <p>
        <b>
         A.6.6.
        </b>
       </p>
      </td>
      <td align="left" valign="top">
       <p>
        Can you insert into views that are based on joins?
       </p>
      </td>
     </tr>
     <tr class="answer">
      <td align="left" valign="top">
      </td>
      <td align="left" valign="top">
       <p>
        It is possible, provided that your
        <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
         <code class="literal">
          INSERT
         </code>
        </a>
        statement has a column
        list that makes it clear there is only one table involved.
       </p>
       <p>
        You
        <span class="emphasis">
         <em>
          cannot
         </em>
        </span>
        insert into multiple tables with
        a single insert on a view.
       </p>
      </td>
     </tr>
    </tbody>
   </table>
  </div>
 </div>
 <br/>
</div>
