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/adding-collation.html
The WEIGHT_STRING() function can be used to see the weights for the characters in a string. A collation is a set of rules that defines how to compare and sort character strings. The value that it returns to indicate weights is a binary string, so ...Every character set has at least one collation, and most have two or more ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. See String Type Storage Requirements for storage requirements for the SET type. See ...SET ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string return values, the maximum length in bytes. CHARACTER_SET_NAME For stored function character ...
https://dev.mysql.com/doc/refman/5.7/en/charset-general.html
To use these features effectively, you must know what character sets and collations are available, how to change the defaults, and how they affect the behavior of string operators and functions. Suppose that we want to compare two string values, A ... A character set is a set of symbols and ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
The full-text search syntax described in Section 12.9, “Full-Text Search Functions” applies to the ngram parser plugin. For example, with a token size of 2, the ngram parser parses the string “abc def” into four tokens: “ab”, “bc”, ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-install-db.html
Note mysql_install_db is deprecated as of MySQL 5.7.6 because its functionality has been integrated into mysqld, the MySQL server. --admin-auth-plugin=plugin_name Command-Line Format --admin-auth-plugin=plugin_name Type String The authentication ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
For more information about how NDB stores columns of blob types, see String Type Storage Requirements. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. The CONNECTION string contains the information required to connect to the remote server containing the table used for physical ...For ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
When to Use Compression In general, compression works best on tables that include a reasonable number of character string columns and where the data is read far more often than it is written. Recall that compression works by identifying repeated ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
This includes user-defined variables having a string value because they are treated as BLOB or TEXT columns, depending on whether their value is a binary or nonbinary string, respectively. Presence of any string column with a maximum length larger ... In some cases, the server creates internal temporary tables while processing ...