Documentation Home
MySQL 8.0 参考手册  / 第 26 章 INFORMATION_SCHEMA 表  / 26.4 INFORMATION_SCHEMA InnoDB 表  /  24.4.10 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表

24.4.10 INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表

INNODB_FT_DEFAULT_STOPWORD表包含在表上创建索引 时默认使用 的停用词列表 。有关默认 停用词列表以及如何定义您自己的停用词列表的信息,请参阅第 12.10.4 节,“全文停用词”FULLTEXTInnoDBInnoDB

有关相关的使用信息和示例,请参阅 第 14.16.4 节,“InnoDB INFORMATION_SCHEMA FULLTEXT 索引表”

INNODB_FT_DEFAULT_STOPWORD表有以下列:

例子

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)

笔记