<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-innodb-ft-default-stopword-table">
      </a>
      28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045076884160">
  </a>
  <p>
   The
   <a class="link" href="information-schema-innodb-ft-default-stopword-table.html" title="28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">
    <code class="literal">
     INNODB_FT_DEFAULT_STOPWORD
    </code>
   </a>
   table
      holds a list of
   <a class="link" href="glossary.html#glos_stopword" title="stopword">
    stopwords
   </a>
   that are used by default when creating a
   <code class="literal">
    FULLTEXT
   </code>
   index on
   <code class="literal">
    InnoDB
   </code>
   tables. For information about the default
   <code class="literal">
    InnoDB
   </code>
   stopword list and how to define your own
      stopword lists, see
   <a class="xref" href="fulltext-stopwords.html" title="14.9.4 Full-Text Stopwords">
    Section 14.9.4, “Full-Text Stopwords”
   </a>
   .
  </p>
  <p>
   For related usage information and examples, see
   <a class="xref" href="innodb-information-schema-fulltext_index-tables.html" title="17.15.4 InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables">
    Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”
   </a>
   .
  </p>
  <p>
   The
   <a class="link" href="information-schema-innodb-ft-default-stopword-table.html" title="28.4.16 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table">
    <code class="literal">
     INNODB_FT_DEFAULT_STOPWORD
    </code>
   </a>
   table
      has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       value
      </code>
     </p>
     <p>
      A word that is used by default as a stopword for
      <code class="literal">
       FULLTEXT
      </code>
      indexes on
      <code class="literal">
       InnoDB
      </code>
      tables. This is not used if you
          override the default stopword processing with either the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_ft_server_stopword_table">
       <code class="literal">
        innodb_ft_server_stopword_table
       </code>
      </a>
      or the
      <a class="link" href="innodb-parameters.html#sysvar_innodb_ft_user_stopword_table">
       <code class="literal">
        innodb_ft_user_stopword_table
       </code>
      </a>
      system variable.
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045076867680">
   </a>
   Example
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa30159755"><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">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>INNODB_FT_DEFAULT_STOPWORD<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>
<span class="token output"><span class="token punctuation">|</span> value <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>
<span class="token output"><span class="token punctuation">|</span> a     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> about <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> an    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> are   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> as    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> at    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> be    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> by    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> com   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> de    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> en    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> for   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> from  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> how   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> i     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> in    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> is    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> it    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> la    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> of    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> on    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> or    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> that  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> the   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> this  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> to    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> was   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> what  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> when  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> where <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> who   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> will  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> with  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> und   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> the   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> www   <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>
<span class="token output">36 rows in set (0.00 sec)</span></code></pre>
  </div>
  <h4>
   <a name="idm46045076864880">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      You must have the
      <a class="link" href="privileges-provided.html#priv_process">
       <code class="literal">
        PROCESS
       </code>
      </a>
      privilege to query this table.
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      <a class="link" href="information-schema-columns-table.html" title="28.3.8 The INFORMATION_SCHEMA COLUMNS Table">
       <code class="literal">
        COLUMNS
       </code>
      </a>
      table or the
      <a class="link" href="show-columns.html" title="15.7.7.6 SHOW COLUMNS Statement">
       <code class="literal">
        SHOW COLUMNS
       </code>
      </a>
      statement to view
          additional information about the columns of this table,
          including data types and default values.
     </p>
    </li>
    <li class="listitem">
     <p>
      For more information about
      <code class="literal">
       InnoDB
      </code>
      <code class="literal">
       FULLTEXT
      </code>
      search, see
      <a class="xref" href="innodb-fulltext-index.html" title="17.6.2.4 InnoDB Full-Text Indexes">
       Section 17.6.2.4, “InnoDB Full-Text Indexes”
      </a>
      , and
      <a class="xref" href="fulltext-search.html" title="14.9 Full-Text Search Functions">
       Section 14.9, “Full-Text Search Functions”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
