<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h2 class="title">
      <a name="extended-show">
      </a>
      28.8 Extensions to SHOW Statements
     </h2>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045075919456">
  </a>
  <a class="indexterm" name="idm46045075918416">
  </a>
  <a class="indexterm" name="idm46045075917344">
  </a>
  <p>
   Some extensions to
   <a class="link" href="show.html" title="15.7.7 SHOW Statements">
    <code class="literal">
     SHOW
    </code>
   </a>
   statements
      accompany the implementation of
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   :
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="show.html" title="15.7.7 SHOW Statements">
       <code class="literal">
        SHOW
       </code>
      </a>
      can be used to get
          information about the structure of
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      itself.
     </p>
    </li>
    <li class="listitem">
     <p>
      Several
      <a class="link" href="show.html" title="15.7.7 SHOW Statements">
       <code class="literal">
        SHOW
       </code>
      </a>
      statements accept
          a
      <code class="literal">
       WHERE
      </code>
      clause that provides more
          flexibility in specifying which rows to display.
     </p>
    </li>
   </ul>
  </div>
  <p>
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   is an information database,
      so its name is included in the output from
   <a class="link" href="show-databases.html" title="15.7.7.15 SHOW DATABASES Statement">
    <code class="literal">
     SHOW DATABASES
    </code>
   </a>
   . Similarly,
   <a class="link" href="show-tables.html" title="15.7.7.39 SHOW TABLES Statement">
    <code class="literal">
     SHOW TABLES
    </code>
   </a>
   can be used with
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   to obtain a list of its
      tables:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa90213689"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">TABLES</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Tables_in_INFORMATION_SCHEMA          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> CHARACTER_SETS                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> COLLATIONS                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> COLLATION_CHARACTER_SET_APPLICABILITY <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> COLUMNS                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> COLUMN_PRIVILEGES                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ENGINES                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> EVENTS                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> FILES                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> KEY_COLUMN_USAGE                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PARTITIONS                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PLUGINS                               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> PROCESSLIST                           <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> REFERENTIAL_CONSTRAINTS               <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ROUTINES                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> SCHEMATA                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> SCHEMA_PRIVILEGES                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> STATISTICS                            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLES                                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE_CONSTRAINTS                     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TABLE_PRIVILEGES                      <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> TRIGGERS                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> USER_PRIVILEGES                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> VIEWS                                 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   <a class="link" href="show-columns.html" title="15.7.7.6 SHOW COLUMNS Statement">
    <code class="literal">
     SHOW COLUMNS
    </code>
   </a>
   and
   <a class="link" href="describe.html" title="15.8.1 DESCRIBE Statement">
    <code class="literal">
     DESCRIBE
    </code>
   </a>
   can display information
      about the columns in individual
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   tables.
  </p>
  <p>
   <a class="link" href="show.html" title="15.7.7 SHOW Statements">
    <code class="literal">
     SHOW
    </code>
   </a>
   statements that accept a
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause to limit the rows
      displayed also permit a
   <code class="literal">
    WHERE
   </code>
   clause that
      specifies more general conditions that selected rows must satisfy:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30284363"><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">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span>
<span class="token keyword">SHOW</span> <span class="token keyword">COLLATION</span>
<span class="token keyword">SHOW</span> <span class="token keyword">COLUMNS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">DATABASES</span>
<span class="token keyword">SHOW</span> <span class="token keyword">FUNCTION</span> <span class="token keyword">STATUS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">INDEX</span>
<span class="token keyword">SHOW</span> <span class="token keyword">OPEN</span> <span class="token keyword">TABLES</span>
<span class="token keyword">SHOW</span> <span class="token keyword">PROCEDURE</span> <span class="token keyword">STATUS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">STATUS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">TABLE</span> <span class="token keyword">STATUS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">TABLES</span>
<span class="token keyword">SHOW</span> <span class="token keyword">TRIGGERS</span>
<span class="token keyword">SHOW</span> <span class="token keyword">VARIABLES</span></code></pre>
  </div>
  <p>
   The
   <code class="literal">
    WHERE
   </code>
   clause, if present, is evaluated
      against the column names displayed by the
   <a class="link" href="show.html" title="15.7.7 SHOW Statements">
    <code class="literal">
     SHOW
    </code>
   </a>
   statement. For example, the
   <a class="link" href="show-character-set.html" title="15.7.7.4 SHOW CHARACTER SET Statement">
    <code class="literal">
     SHOW CHARACTER SET
    </code>
   </a>
   statement
      produces these output columns:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa98509662"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Charset  <span class="token punctuation">|</span> Description                 <span class="token punctuation">|</span> Default collation   <span class="token punctuation">|</span> Maxlen <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> big5     <span class="token punctuation">|</span> Big5 Traditional Chinese    <span class="token punctuation">|</span> big5_chinese_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dec8     <span class="token punctuation">|</span> DEC West European           <span class="token punctuation">|</span> dec8_swedish_ci     <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cp850    <span class="token punctuation">|</span> DOS West European           <span class="token punctuation">|</span> cp850_general_ci    <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> hp8      <span class="token punctuation">|</span> HP West European            <span class="token punctuation">|</span> hp8_english_ci      <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> koi8r    <span class="token punctuation">|</span> KOI8<span class="token punctuation">-</span>R Relcom Russian       <span class="token punctuation">|</span> koi8r_general_ci    <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> latin1   <span class="token punctuation">|</span> cp1252 West European        <span class="token punctuation">|</span> latin1_swedish_ci   <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> latin2   <span class="token punctuation">|</span> ISO 8859<span class="token punctuation">-</span>2 Central European <span class="token punctuation">|</span> latin2_general_ci   <span class="token punctuation">|</span>      1 <span class="token punctuation">|</span></span>
<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
  <p>
   To use a
   <code class="literal">
    WHERE
   </code>
   clause with
   <a class="link" href="show-character-set.html" title="15.7.7.4 SHOW CHARACTER SET Statement">
    <code class="literal">
     SHOW CHARACTER SET
    </code>
   </a>
   , you would refer
      to those column names. As an example, the following statement
      displays information about character sets for which the default
      collation contains the string
   <code class="literal">
    'japanese'
   </code>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa75482124"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> <span class="token keyword">WHERE</span> <span class="token punctuation">`</span><span class="token keyword">Default</span> <span class="token keyword">collation</span><span class="token punctuation">`</span> <span class="token operator">LIKE</span> <span class="token string">'%japanese%'</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Charset <span class="token punctuation">|</span> Description               <span class="token punctuation">|</span> Default collation   <span class="token punctuation">|</span> Maxlen <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> ujis    <span class="token punctuation">|</span> EUC<span class="token punctuation">-</span>JP Japanese           <span class="token punctuation">|</span> ujis_japanese_ci    <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sjis    <span class="token punctuation">|</span> Shift<span class="token punctuation">-</span>JIS Japanese        <span class="token punctuation">|</span> sjis_japanese_ci    <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cp932   <span class="token punctuation">|</span> SJIS for Windows Japanese <span class="token punctuation">|</span> cp932_japanese_ci   <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> eucjpms <span class="token punctuation">|</span> UJIS for Windows Japanese <span class="token punctuation">|</span> eucjpms_japanese_ci <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
  <p>
   This statement displays the multibyte character sets:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa99040863"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CHARACTER</span> <span class="token keyword">SET</span> <span class="token keyword">WHERE</span> Maxlen <span class="token operator">&gt;</span> <span class="token number">1</span><span class="token punctuation">;</span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> Charset <span class="token punctuation">|</span> Description                     <span class="token punctuation">|</span> Default collation   <span class="token punctuation">|</span> Maxlen <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span>
<span class="token output"><span class="token punctuation">|</span> big5    <span class="token punctuation">|</span> Big5 Traditional Chinese        <span class="token punctuation">|</span> big5_chinese_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> cp932   <span class="token punctuation">|</span> SJIS for Windows Japanese       <span class="token punctuation">|</span> cp932_japanese_ci   <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> eucjpms <span class="token punctuation">|</span> UJIS for Windows Japanese       <span class="token punctuation">|</span> eucjpms_japanese_ci <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> euckr   <span class="token punctuation">|</span> EUC<span class="token punctuation">-</span>KR Korean                   <span class="token punctuation">|</span> euckr_korean_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> gb18030 <span class="token punctuation">|</span> China National Standard GB18030 <span class="token punctuation">|</span> gb18030_chinese_ci  <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> gb2312  <span class="token punctuation">|</span> GB2312 Simplified Chinese       <span class="token punctuation">|</span> gb2312_chinese_ci   <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> gbk     <span class="token punctuation">|</span> GBK Simplified Chinese          <span class="token punctuation">|</span> gbk_chinese_ci      <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> sjis    <span class="token punctuation">|</span> Shift<span class="token punctuation">-</span>JIS Japanese              <span class="token punctuation">|</span> sjis_japanese_ci    <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ucs2    <span class="token punctuation">|</span> UCS<span class="token punctuation">-</span>2 Unicode                   <span class="token punctuation">|</span> ucs2_general_ci     <span class="token punctuation">|</span>      2 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> ujis    <span class="token punctuation">|</span> EUC<span class="token punctuation">-</span>JP Japanese                 <span class="token punctuation">|</span> ujis_japanese_ci    <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf16   <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>16 Unicode                  <span class="token punctuation">|</span> utf16_general_ci    <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf16le <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>16LE Unicode                <span class="token punctuation">|</span> utf16le_general_ci  <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf32   <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>32 Unicode                  <span class="token punctuation">|</span> utf32_general_ci    <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb3 <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode                   <span class="token punctuation">|</span> utf8mb3_general_ci  <span class="token punctuation">|</span>      3 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> utf8mb4 <span class="token punctuation">|</span> UTF<span class="token punctuation">-</span>8 Unicode                   <span class="token punctuation">|</span> utf8mb4_0900_ai_ci  <span class="token punctuation">|</span>      4 <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">-</span><span class="token punctuation">+</span></span></code></pre>
  </div>
 </div>
 <br/>
</div>
