PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
Stopword processing is controlled by the configuration options innodb_ft_enable_stopword, innodb_ft_server_stopword_table, and innodb_ft_user_stopword_table for InnoDB search indexes, and ft_stopword_file for MyISAM ones. | ... By default or with ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
If you set this option on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. For example: mysql> STOP ...These ... The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Aa' mysql> SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Dd' EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) Returns a string such that for every bit set in the value bits, you get an on string and ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
NDB Cluster imposes a maximum length of 63 characters for names of databases and tables. Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each ...The sizes of the identifier string columns in the grant tables are measured in ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. This is common for options that you want ...List the options in an option file that the program reads when it ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. | ...This is generally useful when a search ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write access to MySQL database directories. For files used by tables for other storage engines, you may get strange ...Do ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-mapping.html
For the basic structure, MySQL represents each database as a directory in the data directory, and each table by one or more files in the appropriate database directory. This occurs on all platforms for portability of the corresponding database ...If ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ...--defaults-extra-file=file_name, --extra-file=file_name, -e file_name Read this option file after the global option file but (on Unix) before the user option ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The permitted range of IDs for user-defined collations is given in Section 10.14.2, “Choosing a Collation ID”. General ...To ...The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so that it can be indexed as a word ...