<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="traceable-statements">
      </a>
      10.15.3 Traceable Statements
     </h3>
    </div>
   </div>
  </div>
  <p>
   Statements which are traceable are listed here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="select.html" title="15.2.13 SELECT Statement">
       <code class="literal">
        SELECT
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="insert.html" title="15.2.7 INSERT Statement">
       <code class="literal">
        INSERT
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="replace.html" title="15.2.12 REPLACE Statement">
       <code class="literal">
        REPLACE
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
       <code class="literal">
        UPDATE
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="delete.html" title="15.2.2 DELETE Statement">
       <code class="literal">
        DELETE
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="explain.html" title="15.8.2 EXPLAIN Statement">
       <code class="literal">
        EXPLAIN
       </code>
      </a>
      with any of the
          preceding statements
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="set-statement.html" title="15.7.6 SET Statements">
       <code class="literal">
        SET
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="do.html" title="15.2.3 DO Statement">
       <code class="literal">
        DO
       </code>
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="declare.html" title="15.6.3 DECLARE Statement">
       <code class="literal">
        DECLARE
       </code>
      </a>
      ,
      <a class="link" href="case.html" title="15.6.5.1 CASE Statement">
       <code class="literal">
        CASE
       </code>
      </a>
      ,
      <a class="link" href="if.html" title="15.6.5.2 IF Statement">
       <code class="literal">
        IF
       </code>
      </a>
      , and
      <a class="link" href="return.html" title="15.6.5.7 RETURN Statement">
       <code class="literal">
        RETURN
       </code>
      </a>
      as used in stored
          routines
     </p>
    </li>
    <li class="listitem">
     <p>
      <a class="link" href="call.html" title="15.2.1 CALL Statement">
       <code class="literal">
        CALL
       </code>
      </a>
     </p>
    </li>
   </ul>
  </div>
  <p>
   Tracing is supported for both
   <code class="literal">
    INSERT
   </code>
   and
   <code class="literal">
    REPLACE
   </code>
   statements using
   <code class="literal">
    VALUES
   </code>
   ,
   <code class="literal">
    VALUES ROW
   </code>
   , or
   <code class="literal">
    SELECT
   </code>
   .
  </p>
  <p>
   Traces of multi-table
   <code class="literal">
    UPDATE
   </code>
   and
   <code class="literal">
    DELETE
   </code>
   statements are supported.
  </p>
  <p>
   Tracing of
   <code class="literal">
    SET optimizer_trace
   </code>
   is not
      supported.
  </p>
  <p>
   For statements which are prepared and executed in separate steps,
      preparation and execution are traced separately.
  </p>
 </div>
 <br/>
</div>
