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/functions.html
Expressions can be written using values from several sources, such as literal values, column values, NULL, variables, built-in functions and operators, loadable functions, and stored functions (a type of stored object). This chapter describes the ...
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/stored-program-restrictions.html
Thus, stored functions and triggers cannot use dynamic SQL (where you construct statements as strings and then execute them). Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions.
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
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/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-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/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/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.