PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Most full-text variables described in this section must be set at server startup time. For ...Modifying the default behavior in most cases can actually decrease ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
To address this limitation for Japanese, MySQL provides a MeCab full-text parser plugin. In addition to tokenizing text into meaningful words, MeCab indexes are typically smaller than ngram indexes, and MeCab full-text searches are generally faster.
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. To make this search case-sensitive, make sure that one of the operands has a case-sensitive or binary collation. For nonbinary strings (CHAR, ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
For example: SET GLOBAL innodb_ft_aux_table = 'test/t1'; After you set this variable to a name in the format db_name/table_name, the INFORMATION_SCHEMA tables INNODB_FT_INDEX_TABLE, INNODB_FT_INDEX_CACHE, INNODB_FT_CONFIG, INNODB_FT_DELETED, and ...
https://dev.mysql.com/doc/refman/8.0/en/ldap-pluggable-authentication.html
Simple LDAP Authentication (Without Proxying) The procedure outlined in this section requires that authentication_ldap_simple_group_search_attr be set to an empty string, like this: SET GLOBAL.authentication_ldap_simple_group_search_attr=''; ...This ... Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html
If a secondary index is used in a search and the index record locks to be set are exclusive, InnoDB also retrieves the corresponding clustered index records and sets locks on them. For SERIALIZABLE level, the search sets shared next-key locks on the ... A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-find.html
MySQL provides the following operators to specify search conditions: OR (||), AND (&&), XOR, IS, NOT, BETWEEN, IN, LIKE, !=, <>, >, >=, <, <=, &, |, <<, >>, +, -, *, /, ~, and %. Find All Documents in a Collection To return all documents in a ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-find.html
MySQL provides the following operators to specify search conditions: OR (||), AND (&&), XOR, IS, NOT, BETWEEN, IN, LIKE, !=, <>, >, >=, <, <=, &, |, <<, >>, +, -, *, /, ~, and %. Find All Documents in a Collection To return all documents in a ...
https://dev.mysql.com/doc/refman/8.0/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Example: HELP 'fake' Yields: Nothing found Please try to run 'help contents' for a list of all accessible topics Result set containing a single row ...The HELP statement searches the help tables for the given search string and displays the result of the ...Its proper operation requires that the help tables in the ...