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/charset-gb18030.html
Supports comparison between gb18030 strings, and between gb18030 strings and strings of other character sets. In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Error Message Elements When an error occurs, error information includes several elements: an error code, SQLSTATE value, and message string. SQLSTATE value: This value is a five-character string (for example, '42S02'). Message string: This string ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. Specify the search words within a double-quoted string immediately before the @distance operator, for example, MATCH(col1) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
The index also can be used for LIKE comparisons if the argument to LIKE is a constant string that does not start with a wildcard character. LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. ORDINAL_POSITION is ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
For strings, it may be shorter than the full length of the indexed column, because you can index a prefix of a string column. For long indexed strings that have similar leftmost parts, this can significantly reduce the space used. To obtain a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mysqld.html
The mysqld parameter ndb-connectstring is used to specify the connection string either on the command line when starting mysqld or in my.cnf. The connection string contains the host name or IP address where the management server can be found, as ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
Note that string '/BACKUP' is always appended to this setting, so that *effective* default is FileSystemPath/BACKUP. StringMemory: Default size of string memory (0 to 100 = % of maximum, 101+ = actual bytes). Default is empty string; see ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html
For comparisons between nonbinary string columns, both columns should use the same character set. Comparison of dissimilar columns (comparing a string column to a temporal or numeric column, for example) may prevent use of indexes if values cannot ... Indexes are used to find rows with specific column values ...