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/audit-log-filter-definitions.html
The args item must satisfy these conditions: If the function takes no arguments, no args item should be given. If the function does take arguments, an args item is needed, and the arguments must be given in the order listed in the function ...For ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
Strings are automatically converted to numbers and numbers to strings as necessary. Some of the functions in this section return values other than 1 (TRUE), 0 (FALSE), or NULL. LEAST() and GREATEST() are examples of such functions; Section 12.3, ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-usage.html
Each of those functions, if successful, returns a binary string indicating what action occurred. The SUPER privilege is required to call any of the Version Token functions, so token list modification is expected to be done by a management or ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-function-reference.html
Table 6.35 MySQL Enterprise Data Masking and De-Identification Functions Name Description gen_blacklist() Perform dictionary term replacement gen_dictionary_drop() Remove dictionary from registry gen_dictionary_load() Load dictionary into registry ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
The functions in this section provide convenience operations on geometry values. If any geometry argument is not a syntactically well-formed geometry byte string, an ER_GIS_INVALID_DATA error occurs. If any argument is not a syntactically ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
SQL:1999 and later permits such nonaggregates per optional feature T301 if they are functionally dependent on GROUP BY columns: If such a relationship exists between name and custid, the query is legal. If the ONLY_FULL_GROUP_BY SQL mode is enabled ... SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-function-reference.html
Table 6.36 MySQL Enterprise Encryption Functions Name Description asymmetric_decrypt() Decrypt ciphertext using private or public key asymmetric_derive() Derive symmetric key from asymmetric keys asymmetric_encrypt() Encrypt cleartext using private ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions-and-modifiers.html
They are often used with a GROUP BY clause to group values into subsets.
https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html
mysql> SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; mysql> SELECT ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)); +-------------------------------------------------+ | ST_AsText(ST_GeometryN(ST_GeomFromText(@gc),1)) | ...
https://dev.mysql.com/doc/refman/5.7/en/gis-point-property-functions.html
A Point consists of X and Y coordinates, which may be obtained using the following functions: ST_X(p) Returns the X-coordinate value for the Point object p as a double-precision number. mysql> SELECT ST_X(Point(56.7, 53.34)); ...