<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysqlbinlog-row-events">
      </a>
      6.6.9.2 mysqlbinlog Row Event Display
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045303509664">
  </a>
  <p>
   The following examples illustrate how
   <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
    <span class="command">
     <strong>
      mysqlbinlog
     </strong>
    </span>
   </a>
   displays row events that specify
        data modifications. These correspond to events with the
   <code class="literal">
    WRITE_ROWS_EVENT
   </code>
   ,
   <code class="literal">
    UPDATE_ROWS_EVENT
   </code>
   , and
   <code class="literal">
    DELETE_ROWS_EVENT
   </code>
   type codes. The
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_base64-output">
    <code class="option">
     --base64-output=DECODE-ROWS
    </code>
   </a>
   and
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   options may be
        used to affect row event output.
  </p>
  <p>
   Suppose that the server is using row-based binary logging and
        that you execute the following sequence of statements:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa12226755"><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">CREATE</span> <span class="token keyword">TABLE</span> t
<span class="token punctuation">(</span>
  id   <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
  <span class="token keyword">name</span> <span class="token datatype">VARCHAR</span><span class="token punctuation">(</span><span class="token number">20</span><span class="token punctuation">)</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
  <span class="token datatype">date</span> <span class="token datatype">DATE</span> <span class="token boolean">NULL</span>
<span class="token punctuation">)</span> <span class="token keyword">ENGINE</span> <span class="token operator">=</span> InnoDB<span class="token punctuation">;</span>

<span class="token keyword">START</span> <span class="token keyword">TRANSACTION</span><span class="token punctuation">;</span>
<span class="token keyword">INSERT</span> <span class="token keyword">INTO</span> t <span class="token keyword">VALUES</span><span class="token punctuation">(</span><span class="token number">1</span><span class="token punctuation">,</span> <span class="token string">'apple'</span><span class="token punctuation">,</span> <span class="token boolean">NULL</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token keyword">UPDATE</span> t <span class="token keyword">SET</span> <span class="token keyword">name</span> <span class="token operator">=</span> <span class="token string">'pear'</span><span class="token punctuation">,</span> <span class="token datatype">date</span> <span class="token operator">=</span> <span class="token string">'2009-01-01'</span> <span class="token keyword">WHERE</span> id <span class="token operator">=</span> <span class="token number">1</span><span class="token punctuation">;</span>
<span class="token keyword">DELETE</span> <span class="token keyword">FROM</span> t <span class="token keyword">WHERE</span> id <span class="token operator">=</span> <span class="token number">1</span><span class="token punctuation">;</span>
<span class="token keyword">COMMIT</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   By default,
   <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
    <span class="command">
     <strong>
      mysqlbinlog
     </strong>
    </span>
   </a>
   displays row events
        encoded as base-64 strings using
   <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
    <code class="literal">
     BINLOG
    </code>
   </a>
   statements. Omitting
        extraneous lines, the output for the row events produced by the
        preceding statement sequence looks like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa9808264"><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-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqlbinlog</span> <em class="replaceable">log_file</em>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 218</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 258   Write_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ<span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">=</span></span>
'/*!*/<span class="token punctuation">;</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 302</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 356   Update_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 400</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 442   Delete_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   To see the row events as comments in the form of
   <span class="quote">
    “
    <span class="quote">
     pseudo-SQL
    </span>
    ”
   </span>
   statements, run
   <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
    <span class="command">
     <strong>
      mysqlbinlog
     </strong>
    </span>
   </a>
   with the
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   or
   <code class="option">
    -v
   </code>
   option. This output level also shows table
        partition information where applicable. The output contains
        lines beginning with
   <code class="literal">
    ###
   </code>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa60465379"><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-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqlbinlog</span> <span class="token property">-v</span> <em class="replaceable">log_file</em>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 218</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 258   Write_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ<span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">=</span></span>
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### INSERT INTO test.t</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='apple'</span>
<span class="token comment" spellcheck="true">###   @3=NULL</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 302</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 356   Update_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### UPDATE test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='apple'</span>
<span class="token comment" spellcheck="true">###   @3=NULL</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='pear'</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01'</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 400</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 442   Delete_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### DELETE FROM test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='pear'</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01'</span></code></pre>
  </div>
  <p>
   Specify
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   or
   <code class="option">
    -v
   </code>
   twice to also display data types and some
        metadata for each column, and informational log events such as
        row query log events if the
   <a class="link" href="replication-options-binary-log.html#sysvar_binlog_rows_query_log_events">
    <code class="literal">
     binlog_rows_query_log_events
    </code>
   </a>
   system variable is set to
   <code class="literal">
    TRUE
   </code>
   . The output
        contains an additional comment following each column change:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa29633186"><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-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqlbinlog</span> <span class="token property">-vv</span> <em class="replaceable">log_file</em>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 218</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 258   Write_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAANoAAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBcBAAAAKAAAAAIBAAAQABEAAAAAAAEAA//8AQAAAAVhcHBsZQ<span class="token attr-value"><span class="token punctuation">=</span><span class="token punctuation">=</span></span>
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### INSERT INTO test.t</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1 /* INT meta=0 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @2='apple' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 302</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 356   Update_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAC4BAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBgBAAAANgAAAGQBAAAQABEAAAAAAAEAA////AEAAAAFYXBwbGX4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### UPDATE test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1 /* INT meta=0 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @2='apple' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @3=NULL /* VARSTRING(20) meta=0 nullable=1 is_null=1 */</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1 /* INT meta=0 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @2='pear' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01' /* DATE meta=0 nullable=1 is_null=0 */</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 400</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 442   Delete_rows: table id 17 flags: STMT_END_F</span>

BINLOG '
fAS3SBMBAAAALAAAAJABAAAAABEAAAAAAAAABHRlc3QAAXQAAwMPCgIUAAQ=
fAS3SBkBAAAAKgAAALoBAAAQABEAAAAAAAEAA//4AQAAAARwZWFyIbIP
'/*!*/<span class="token punctuation">;</span>
<span class="token comment" spellcheck="true">### DELETE FROM test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1 /* INT meta=0 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @2='pear' /* VARSTRING(20) meta=20 nullable=0 is_null=0 */</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01' /* DATE meta=0 nullable=1 is_null=0 */</span></code></pre>
  </div>
  <p>
   You can tell
   <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
    <span class="command">
     <strong>
      mysqlbinlog
     </strong>
    </span>
   </a>
   to suppress the
   <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
    <code class="literal">
     BINLOG
    </code>
   </a>
   statements for row events
        by using the
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_base64-output">
    <code class="option">
     --base64-output=DECODE-ROWS
    </code>
   </a>
   option. This is similar to
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_base64-output">
    <code class="option">
     --base64-output=NEVER
    </code>
   </a>
   but
        does not exit with an error if a row event is found. The
        combination of
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_base64-output">
    <code class="option">
     --base64-output=DECODE-ROWS
    </code>
   </a>
   and
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   provides a
        convenient way to see row events only as SQL statements:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa40096769"><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-terminal"><span class="token prompt">$&gt; </span><span class="token command">mysqlbinlog</span> <span class="token property">-v</span> <span class="token constant">--base64-output</span><span class="token attr-value"><span class="token punctuation">=</span>DECODE-ROWS</span> <em class="replaceable">log_file</em>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 218</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 258   Write_rows: table id 17 flags: STMT_END_F</span>
<span class="token comment" spellcheck="true">### INSERT INTO test.t</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='apple'</span>
<span class="token comment" spellcheck="true">###   @3=NULL</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 302</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 356   Update_rows: table id 17 flags: STMT_END_F</span>
<span class="token comment" spellcheck="true">### UPDATE test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='apple'</span>
<span class="token comment" spellcheck="true">###   @3=NULL</span>
<span class="token comment" spellcheck="true">### SET</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='pear'</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01'</span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>
<span class="token comment" spellcheck="true"># at 400</span>
<span class="token comment" spellcheck="true">#080828 15:03:08 server id 1  end_log_pos 442   Delete_rows: table id 17 flags: STMT_END_F</span>
<span class="token comment" spellcheck="true">### DELETE FROM test.t</span>
<span class="token comment" spellcheck="true">### WHERE</span>
<span class="token comment" spellcheck="true">###   @1=1</span>
<span class="token comment" spellcheck="true">###   @2='pear'</span>
<span class="token comment" spellcheck="true">###   @3='2009:01:01'</span></code></pre>
  </div>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    You should not suppress
    <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
     <code class="literal">
      BINLOG
     </code>
    </a>
    statements if you intend to re-execute
    <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
     <span class="command">
      <strong>
       mysqlbinlog
      </strong>
     </span>
    </a>
    output.
   </p>
  </div>
  <p>
   The SQL statements produced by
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_verbose">
    <code class="option">
     --verbose
    </code>
   </a>
   for row events are
        much more readable than the corresponding
   <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
    <code class="literal">
     BINLOG
    </code>
   </a>
   statements. However, they
        do not correspond exactly to the original SQL statements that
        generated the events. The following limitations apply:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      The original column names are lost and replaced by
      <code class="literal">
       @
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
      , where
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      is a column number.
     </p>
    </li>
    <li class="listitem">
     <p>
      Character set information is not available in the binary
            log, which affects string column display:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         There is no distinction made between corresponding
                binary and nonbinary string types
                (
         <a class="link" href="binary-varbinary.html" title="13.3.3 The BINARY and VARBINARY Types">
          <code class="literal">
           BINARY
          </code>
         </a>
         and
         <a class="link" href="char.html" title="13.3.2 The CHAR and VARCHAR Types">
          <code class="literal">
           CHAR
          </code>
         </a>
         ,
         <a class="link" href="binary-varbinary.html" title="13.3.3 The BINARY and VARBINARY Types">
          <code class="literal">
           VARBINARY
          </code>
         </a>
         and
         <a class="link" href="char.html" title="13.3.2 The CHAR and VARCHAR Types">
          <code class="literal">
           VARCHAR
          </code>
         </a>
         ,
         <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
          <code class="literal">
           BLOB
          </code>
         </a>
         and
         <a class="link" href="blob.html" title="13.3.4 The BLOB and TEXT Types">
          <code class="literal">
           TEXT
          </code>
         </a>
         ). The output uses a
                data type of
         <code class="literal">
          STRING
         </code>
         for fixed-length
                strings and
         <code class="literal">
          VARSTRING
         </code>
         for
                variable-length strings.
        </p>
       </li>
       <li class="listitem">
        <p>
         For multibyte character sets, the maximum number of
                bytes per character is not present in the binary log, so
                the length for string types is displayed in bytes rather
                than in characters. For example,
         <code class="literal">
          STRING(4)
         </code>
         is used as the data type
                for values from either of these column types:
        </p>
        <div class="copytoclipboard-wrapper">
         <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa54335817"><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 datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">4</span><span class="token punctuation">)</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> latin1
<span class="token datatype">CHAR</span><span class="token punctuation">(</span><span class="token number">2</span><span class="token punctuation">)</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> ucs2</code></pre>
        </div>
       </li>
       <li class="listitem">
        <p>
         Due to the storage format for events of type
         <code class="literal">
          UPDATE_ROWS_EVENT
         </code>
         ,
         <a class="link" href="update.html" title="15.2.17 UPDATE Statement">
          <code class="literal">
           UPDATE
          </code>
         </a>
         statements are
                displayed with the
         <code class="literal">
          WHERE
         </code>
         clause
                preceding the
         <code class="literal">
          SET
         </code>
         clause.
        </p>
       </li>
      </ul>
     </div>
    </li>
   </ul>
  </div>
  <p>
   Proper interpretation of row events requires the information
        from the format description event at the beginning of the binary
        log. Because
   <a class="link" href="mysqlbinlog.html" title="6.6.9 mysqlbinlog — Utility for Processing Binary Log Files">
    <span class="command">
     <strong>
      mysqlbinlog
     </strong>
    </span>
   </a>
   does not know in
        advance whether the rest of the log contains row events, by
        default it displays the format description event using a
   <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
    <code class="literal">
     BINLOG
    </code>
   </a>
   statement in the initial
        part of the output.
  </p>
  <p>
   If the binary log is known not to contain any events requiring a
   <a class="link" href="binlog.html" title="15.7.8.1 BINLOG Statement">
    <code class="literal">
     BINLOG
    </code>
   </a>
   statement (that is, no row
        events), the
   <a class="link" href="mysqlbinlog.html#option_mysqlbinlog_base64-output">
    <code class="option">
     --base64-output=NEVER
    </code>
   </a>
   option
        can be used to prevent this header from being written.
  </p>
 </div>
 <br/>
</div>
