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/replication-features-functions.html
Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based ...
https://dev.mysql.com/doc/refman/5.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. Special characters in string scalars and key names are escaped employing the same rules used by the JSON_QUOTE() function. In the case ...The value supplied must be a JSON value or a valid string representation of a JSON ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
This function also works with a string that can be parsed as a JSON value. This function also accepts a valid string representation of a JSON document. The functions described in Section 12.16.4, “Functions That Create Geometry Values from WKB ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
The functions in this section modify JSON values and return the result. This function was renamed to JSON_ARRAY_APPEND() in MySQL 5.7.9; the alias JSON_APPEND() is now deprecated in MySQL 5.7, and is removed in MySQL 8.0. Raises an error if at ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
A warning is logged if you use this function when binlog_format is set to STATEMENT. A different locking interface is available as either a plugin service or a set of loadable functions. This interface provides lock namespaces and distinct read and ...While held by one session, other sessions cannot obtain a lock of the same ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
A function is nondeterministic if, given fixed values for its arguments, it can return different results for different invocations. If a function is tagged nondeterministic, a reference to it in a WHERE clause is evaluated for every row (when ...For ...
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/spatial-operator-functions.html
These arguments are byte string values produced by the ST_Buffer_Strategy() function, to be used for point, join, and end strategies: Point strategies apply to Point and MultiPoint geometries. ST_Buffer_Strategy(strategy [, points_per_circle]) This ... OpenGIS proposes a number of functions that can produce ...Buffer() is ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
An extension for MySQL 8.0 changes this cast-to-BIGINT behavior: Bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types), enabling them to take arguments and produce return values larger than 64 bits.
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-installation.html
MySQL Enterprise Encryption functions are located in a loadable function library file installed in the plugin directory (the directory named by the plugin_dir system variable). The function library base name is openssl_udf and the suffix is ...For ...