<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="differences-from-ansi">
      </a>
      1.7.2 MySQL Differences from Standard SQL
     </h3>
    </div>
   </div>
  </div>
  <div class="toc">
   <dl class="toc">
    <dt>
     <span class="section">
      <a href="ansi-diff-select-into-table.html">
       1.7.2.1 SELECT INTO TABLE Differences
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="ansi-diff-update.html">
       1.7.2.2 UPDATE Differences
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="ansi-diff-foreign-keys.html">
       1.7.2.3 FOREIGN KEY Constraint Differences
      </a>
     </span>
    </dt>
    <dt>
     <span class="section">
      <a href="ansi-diff-comments.html">
       1.7.2.4 '--' as the Start of a Comment
      </a>
     </span>
    </dt>
   </dl>
  </div>
  <a class="indexterm" name="idm46045333288048">
  </a>
  <p>
   We try to make MySQL Server follow the ANSI SQL standard and the
        ODBC SQL standard, but MySQL Server performs operations
        differently in some cases:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      There are several differences between the MySQL and standard
            SQL privilege systems. For example, in MySQL, privileges for
            a table are not automatically revoked when you delete a
            table. You must explicitly issue a
      <a class="link" href="revoke.html" title="15.7.1.8 REVOKE Statement">
       <code class="literal">
        REVOKE
       </code>
      </a>
      statement to revoke
            privileges for a table. For more information, see
      <a class="xref" href="revoke.html" title="15.7.1.8 REVOKE Statement">
       Section 15.7.1.8, “REVOKE Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      The
      <a class="link" href="cast-functions.html#function_cast">
       <code class="literal">
        CAST()
       </code>
      </a>
      function does not
            support cast to
      <a class="link" href="floating-point-types.html" title="13.1.4 Floating-Point Types (Approximate Value) - FLOAT, DOUBLE">
       <code class="literal">
        REAL
       </code>
      </a>
      or
      <a class="link" href="integer-types.html" title="13.1.2 Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT">
       <code class="literal">
        BIGINT
       </code>
      </a>
      . See
      <a class="xref" href="cast-functions.html" title="14.10 Cast Functions and Operators">
       Section 14.10, “Cast Functions and Operators”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
