<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="insert-delayed">
      </a>
      15.2.7.3 INSERT DELAYED Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045182050400">
  </a>
  <a class="indexterm" name="idm46045182049360">
  </a>
  <a class="indexterm" name="idm46045182048288">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa14702674"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">INSERT</span> <span class="token keyword">DELAYED</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
  <p>
   The
   <code class="literal">
    DELAYED
   </code>
   option for the
   <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
    <code class="literal">
     INSERT
    </code>
   </a>
   statement is a MySQL
        extension to standard SQL. In previous versions of MySQL, it can
        be used for certain kinds of tables (such as
   <code class="literal">
    MyISAM
   </code>
   ), such that when a client uses
   <a class="link" href="insert-delayed.html" title="15.2.7.3 INSERT DELAYED Statement">
    <code class="literal">
     INSERT DELAYED
    </code>
   </a>
   , it gets an okay
        from the server at once, and the row is queued to be inserted
        when the table is not in use by any other thread.
  </p>
  <p>
   <code class="literal">
    DELAYED
   </code>
   inserts and replaces were deprecated
        in MySQL 5.6. In MySQL 8.4,
   <code class="literal">
    DELAYED
   </code>
   is not supported. The server
        recognizes but ignores the
   <code class="literal">
    DELAYED
   </code>
   keyword,
        handles the insert as a nondelayed insert, and generates an
   <a class="ulink" href="/doc/mysql-errors/8.4/en/server-error-reference.html#error_er_warn_legacy_syntax_converted" target="_top">
    <code class="literal">
     ER_WARN_LEGACY_SYNTAX_CONVERTED
    </code>
   </a>
   warning:
   <span class="errortext">
    INSERT DELAYED is no longer supported. The
        statement was converted to INSERT
   </span>
   . The
   <code class="literal">
    DELAYED
   </code>
   keyword is scheduled for removal in a
        future release.
  </p>
 </div>
 <br/>
</div>
