Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.4/en/json-validation-functions.html
This can be done using either of the functions detailed in this section, both of which take two arguments, a JSON schema, and a JSON document which is validated against the schema. Both functions handle null or invalid input as follows: If at least ... MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/cli-integration-for-api-functions.html
The MySQL Shell provides global objects that expose different functionality, such as dba for InnoDB Cluster and InnoDB ReplicaSet management operations, util for the utility functions, and so on. Global objects provide functions which are called ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-vector-functions.html
It accepts the following arguments: A column of VECTOR data type.
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/performance-schema-functions.html
MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema and require no ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-functions.html
There are three ways to add a new function to MySQL: Create a stored function (a type of stored object). A stored function is written using SQL statements rather than by compiling object code. A native function is added by modifying the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
String functions and operators on columns that are not VARLEN encoded. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() GROUP_CONCAT() ...Rewrite queries that use named time zones with equivalent datetime ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
The functions in this section modify JSON values and return the result. Raises an error if at least one of the documents passed as arguments to this function is not valid. Note For an explanation and example of the differences between this function ...JSON_ARRAY_APPEND(json_doc, path, val[, path, val] ...) Appends values to the end of the indicated arrays within a JSON document and returns the ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-backup.html
This section provides information about the functions provided in the MGM API for starting and stopping NDB Cluster backups. ndb_mgm_start_backup() ndb_mgm_start_backup2() ndb_mgm_start_backup3() ndb_mgm_start_backup4() ndb_mgm_abort_backup() ...A ...