28.4.16 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表
The INNODB_FT_DEFAULT_STOPWORD
table holds a list of stopwords that are used by default when creating a FULLTEXT
index on InnoDB
tables. For information about the default InnoDB
stopword list and how to define your own stopword lists, see Section 14.9.4, “Full-Text Stopwords”.
For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
The INNODB_FT_DEFAULT_STOPWORD
table has these columns:
-
value
A word that is used by default as a stopword for
FULLTEXT
indexes onInnoDB
tables. This is not used if you override the default stopword processing with either theinnodb_ft_server_stopword_table
or theinnodb_ft_user_stopword_table
system variable.
mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD;
+-------+
| value |
+-------+
| a |
| about |
| an |
| are |
| as |
| at |
| be |
| by |
| com |
| de |
| en |
| for |
| from |
| how |
| i |
| in |
| is |
| it |
| la |
| of |
| on |
| or |
| that |
| the |
| this |
| to |
| was |
| what |
| when |
| where |
| who |
| will |
| with |
| und |
| the |
| www |
+-------+
36 rows in set (0.00 sec)
-
You must have the
PROCESS
privilege to query this table. -
Use the
INFORMATION_SCHEMA
COLUMNS
table or theSHOW COLUMNS
statement to view additional information about the columns of this table, including data types and default values. -
For more information about
InnoDB
FULLTEXT
search, see Section 17.6.2.4, “InnoDB Full-Text Indexes”, and Section 14.9, “Full-Text Search Functions”.