PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
If you really need to search for such common words, it would be better to search using IN BOOLEAN MODE instead, which does not observe the 50% threshold. Modifying Boolean Full-Text Search Operators To change the operators used for boolean full-text ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
SELECT COUNT(*) FROM articles WHERE MATCH(title,body) AGAINST('データベース管理' IN NATURAL LANGUAGE MODE); For boolean mode search, the search term is converted to a search phrase. SELECT COUNT(*) FROM articles WHERE MATCH(title,body) ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
mysql> SELECT INTERVAL(23, 1, 15, 17, 30, 44, 200); -> 3 mysql> SELECT INTERVAL(10, 1, 10, 100, 1000); -> 2 mysql> SELECT INTERVAL(22, 23, 30, 44, 200); -> 0 IS boolean_value Tests a value against a boolean value, where boolean_value can be TRUE, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html
in_start_fresh BOOLEAN: Whether to reset all Performance Schema data before tracing. in_auto_setup BOOLEAN: Whether to disable all other threads and enable all instruments and consumers. Dumps all Performance Schema data for an instrumented thread ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...
https://dev.mysql.com/doc/refman/5.7/en/index-hints.html
For boolean mode searches, index hints with FOR ORDER BY or FOR GROUP BY are silently ignored. Index hints give the optimizer information about how to choose indexes during query processing. Index hints, described here, differ from optimizer hints, ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
--ssl, --skip-ssl Command-Line Format --ssl Disabled by skip-ssl Type Boolean Default Value FALSE Command-Line Format --skip-ssl Note The client-side --ssl option is deprecated as of MySQL 5.7.11 and is removed in MySQL 8.0. --ssl-verify-server-cert ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are ...
https://dev.mysql.com/doc/refman/5.7/en/json.html
BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE NULL For JSON values of the same precedence, the comparison rules are type specific: BLOB The first N bytes of the two values are compared, where N is the number of bytes ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/5.7/en/comp-err.html
--help, -? Command-Line Format --help Type Boolean Default Value false Display a help message and exit. --debug-info, -T Command-Line Format --debug-info Type Boolean Default Value false Print some debugging information when the program exits.
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ... This section describes the server options and system variables that you can use on replication source ...