Movatterモバイル変換

TheINNODB_FT_DEFAULT_STOPWORD table holds a list ofstopwords that are used by default when creating aFULLTEXT index onInnoDB tables. For information about the defaultInnoDB stopword list and how to define your own stopword lists, seeSection 12.9.4, “Full-Text Stopwords”.

For related usage information and examples, seeSection 14.16.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”.

TheINNODB_FT_DEFAULT_STOPWORD table has these columns:

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