Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/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 14.2, “Loadable Function Reference”. WEEK() Return the ...->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The function can be used on any member of a replication group running in single-primary mode. This function replaces the usual ...
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/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...More ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-cluster-log.html
This section provides information about the functions available in the MGM API for controlling the output of the cluster log. ndb_mgm_get_clusterlog_severity_filter() ndb_mgm_set_clusterlog_severity_filter() ndb_mgm_get_clusterlog_loglevel() ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
Specific functions or groups of functions may have additional or different argument-handling characteristics, as discussed in the sections where those function descriptions occur. Thus, spatial functions that take multiple geometry arguments require ... Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. row *************************** ST_Contains(@g1, @p3): 0 ST_Within(@p3, @g1): 0 MBRContains(@g1, ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
The definition of a window used with a window function can include a frame clause. Aggregate functions used as window functions operate on rows in the current row frame, as do these nonaggregate window functions: FIRST_VALUE() LAST_VALUE() ...A ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-function-reference.html
The following table summarizes all functions available for the MySQL C API.