Information Schema INNODB_FT_DEFAULT_STOPWORD Table
The Information Schema INNODB_FT_DEFAULT_STOPWORD table contains a list of default stopwords used when creating an InnoDB fulltext index.
The PROCESS privilege is required to view the table.
It has the following column:
| Column | Description |
|---|---|
VALUE | Default stopword for an InnoDB fulltext index. Setting either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable will override this. |
Example
SELECT * FROM information_schema.INNODB_FT_DEFAULT_STOPWORD\G *************************** 1. row *************************** value: a *************************** 2. row *************************** value: about *************************** 3. row *************************** value: an *************************** 4. row *************************** value: are ... *************************** 36. row *************************** value: www
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
