Search Results
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-functions.html
This occurs, for example, if a function does not support a specified algorithm, a key length is too short or long, or a string expected to be a key string in PEM format is not a valid key. The function accepts digests but does not require them, as ... MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-functions.html
This section provides examples of stored functions (see Chapter 27, 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/8.4/en/stored-programs-logging.html
However, if logging occurs at the statement level, there are certain binary logging issues with respect to stored programs (stored procedures and functions, triggers, and events): In some cases, a statement might affect different sets of rows on ...
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/extending-mysql/8.4/en/adding-native-function.html
In item_func.h, declare a class inheriting from Item_num_func or Item_str_func, depending on whether your function returns a number or a string. For ::str() object functions, these additional considerations apply: The String *str argument provides a ... To add a native MySQL function, use the procedure described here, which requires that you use a source ...If you migrate to another ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
HEX(N_or_S) This function can be used to obtain a hexadecimal representation of a decimal number or a string; the manner in which it does so varies according to the argument's type. See this function's description in Section 14.8, “String ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-management-server-connections.html
ndb_mgm_get_connectstring() ndb_mgm_get_configuration_nodeid() ndb_mgm_get_connected_port() ndb_mgm_get_connected_host() ndb_mgm_get_version() ndb_mgm_is_connected() ndb_mgm_check_connection() ndb_mgm_number_of_mgmd_in_connect_string() ... This ...A ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation occurs is called the current row. The query rows related to the current ...The second OVER clause partitions rows by country, producing a sum per partition (per ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. The CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...