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/json-search-functions.html
column->path In MySQL 5.7.9 and later, the -> operator serves as an alias for the JSON_EXTRACT() function when used with two arguments, a column identifier on the left and a JSON path (a string literal) on the right that is evaluated against the ...
https://dev.mysql.com/doc/refman/5.7/en/gtid-functions.html
It is important to keep in mind that all of these functions take string representations of GTID sets as arguments. The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT ... The functions ...As such, the GTID sets must always be quoted when used with ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html
Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are strings that contain only characters chosen from "0123456789bcdefghjkmnpqrstuvwxyz". The functions in this section ...
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/function-loading.html
For example: CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.so'; The file base name depends on your platform. Loadable functions, as the name implies, must be loaded into the server before they can be used. MySQL supports automatic ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/5.7/en/flow-control-functions.html
Note There is also an IF statement, which differs from the IF() function described here. If only one of expr2 or expr3 is explicitly NULL, the result type of the IF() function is the type of the non-NULL expression. The default return type of IF() ...The second syntax returns the result for the first condition that is ...
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/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 12.1, “Built-In Function and Operator Reference” For general ...
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.