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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). 5.7.13 / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in ...
https://dev.mysql.com/doc/refman/5.7/en/xa-statements.html
gtrid and bqual must be string literals, each up to 64 bytes (not characters) long. You can use a quoted string ('ab'), hex string (X'6162', 0x6162), or bit value (b'nnnn'). To perform XA transactions in MySQL, use the following statements: XA ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
Exception: For string literals that have an introducer such as _utf8mb4 or _latin2, the introducer determines the character set. For comparisons of strings with column values, collation_connection does not matter because columns have their own ... A ...
https://dev.mysql.com/doc/refman/5.7/en/create-server.html
Character literals are UTF-8, support a maximum length of 64 characters and default to a blank (empty) string. CREATE SERVER server_name FOREIGN DATA WRAPPER wrapper_name OPTIONS (option [, option] ...) option: { HOST character-literal | DATABASE ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...