INNODB_FT_DEFAULT_STOPWORD 表保存了在 InnoDB 表上创建 FULLTEXT 索引时默认使用的停用词列表。有关默认 InnoDB 停用词列表以及如何定义自己的停用词列表的信息,请参见 第 14.9.4 节,“全文停用词”。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”.
有关相关的使用信息和示例,请参见 第 17.15.4 节,“InnoDB INFORMATION_SCHEMA FULLTEXT 索引表”。For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.
INNODB_FT_DEFAULT_STOPWORD 表包含以下列:The INNODB_FT_DEFAULT_STOPWORD table
has these columns:
value一个默认用作
FULLTEXT索引停止词的单词,用于InnoDB表。如果使用innodb_ft_server_stopword_table或innodb_ft_user_stopword_table系统变量覆盖默认停止词处理,则不会使用此单词。A word that is used by default as a stopword forFULLTEXTindexes onInnoDBtables. This is not used if you override the default stopword processing with either theinnodb_ft_server_stopword_tableor theinnodb_ft_user_stopword_tablesystem variable.
示例Example
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)
注意事项Notes
你必须拥有
PROCESS权限才能查询此表。You must have thePROCESSprivilege to query this table.使用
INFORMATION_SCHEMACOLUMNS表或SHOW COLUMNS语句查看关于此表列的更多信息,包括数据类型和默认值。Use theINFORMATION_SCHEMACOLUMNStable or theSHOW COLUMNSstatement to view additional information about the columns of this table, including data types and default values.有关
InnoDBFULLTEXT搜索的更多信息,请参见 第 17.6.2.4 节,“InnoDB 全文索引”,以及 第 14.9 节,“全文搜索函数”。For more information aboutInnoDBFULLTEXTsearch, see Section 17.6.2.4, “InnoDB Full-Text Indexes”, and Section 14.9, “Full-Text Search Functions”.