PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.4Kb
Man Pages (Zip)
- 360.2Kb
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/create-procedure.html
The CREATE FUNCTION statement is also used in MySQL to support loadable functions. A loadable function can be regarded as an external stored function. See Section 9.2.5, “Function Name Parsing and Resolution”, for the rules describing how the ...
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/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Is there a way to view all stored procedures and stored functions in a given database? A.4.7. Is it possible to group stored procedures or stored functions into ...Where can I find the ANSI SQL 2003 specification for stored procedures? ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. If the arguments are not suitable to permit a function to perform the ...
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/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/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. If the value is not a JSON document, or if it cannot be parsed as one, the function fails with an error. Formatting of the output from ...JSON_PRETTY() prints out a JSON value in a format that is easy to ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-operator-functions.html
OpenGIS proposes a number of functions that can produce geometries. These functions support all argument type combinations except those that are inapplicable according to the Open Geospatial Consortium specification. In addition, Section 12.16.7, ...Buffer() is deprecated; expect it to be removed in a future MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
Table 12.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit ...