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/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...If explicit COLLATE Y and COLLATE Z occur, raise an ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
The first value is a non-NULL string and the second is NULL. For example, the handler maps the NULL insert to an empty-string insert and displays the result. Within a stored procedure p(), we attempt to insert two values into a table that contains a ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
Important Because each SQL node using connection pooling occupies multiple API node slots—each slot having its own node ID in the cluster—you must not use a node ID as part of the cluster connection string when starting any mysqld process that ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-desc.html
Usage ndb_desc -c connection_string tbl_name -d db_name [options] ndb_desc -c connection_string index_name -d db_name -t tbl_name Additional options that can be used with ndb_desc are listed later in this section. --connect-string Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
This section discusses these optimizations, particularly with regard to the challenges that NULL values present. That is, the “pushdown” strategy works as long as both of these conditions are true: outer_expr and inner_expr cannot be NULL.
https://dev.mysql.com/doc/refman/5.7/en/replace-utility.html
The replace utility program changes strings in place in files or on the standard input. < file_name from represents a string to look for and to represents its replacement. Use the -- option to indicate where the string-replacement list ends and the ...Note The replace utility is deprecated as of MySQL 5.7.18 and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Valid XML characters are: #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF] The following elements are mandatory in every <AUDIT_RECORD> element: <NAME> A string representing the type of instruction that generated the audit ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-character.html
For character and string columns, follow these guidelines: Use binary collation order for fast comparison and sort operations, when you do not need language-specific collation features. When comparing values from different columns, declare those ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. If the plugin column is empty, the server authenticates the account as follows: ...