Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-masking-deindentification-functions.html
The following table shows data masking and de-identification functions supported by MySQL HeatWave.
https://dev.mysql.com/doc/refman/8.4/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. For a table describing the available ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...
https://dev.mysql.com/doc/refman/8.4/en/gis-format-conversion-functions.html
There are also functions to convert a string from WKT or WKB format to internal geometry format. MySQL supports the functions listed in this section for converting geometry values from internal geometry format to WKT or WKB format, or for swapping ...Another way to produce an empty geometry collection is by calling GeometryCollection() with no ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-functional-dependence.html
The following discussion provides several examples of the ways in which MySQL detects functional dependencies. The examples use this notation: {X} -> {Y} Understand this as “X uniquely determines Y,” which also means that Y is functionally ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
The VARLEN Support column identifies functions that support variable-length encoded string columns. Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of ...As of MySQL 8.4.0, HyperLogLog, HLL(), is available in the MySQL HeatWave primary and secondary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encryption-compression-functions.html
Table 5.6 Encryption and Compression Functions Name Description COMPRESS() Return the result as a binary string. Note Deprecated as of MySQL 9.4.0 and scheduled for removal in a future release. Note Deprecated as of MySQL 9.4.0 and scheduled for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns. Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... Yes Check whether a value is not within a ...