Miscellaneous Functions
Miscellaneous functions include DEFAULT, GET_LOCK, SLEEP, UUID, etc.
-
FORMAT_BYTES
Returns a string consisting of a value and the units in a human-readable format. -
GET_LOCK
Obtain LOCK. -
INET6_ATON
Given an IPv6 or IPv4 network address, returns a VARBINARY numeric value. -
INET6_NTOA
Given an IPv6 or IPv4 network address, returns the address as a nonbinary string. -
INET_ATON
Returns numeric value of IPv4 address. -
INET_NTOA
Returns dotted-quad representation of IPv4 address. -
IS_FREE_LOCK
Checks whether lock is free to use. -
IS_IPV4
Whether or not an expression is a valid IPv4 address. -
IS_IPV4_COMPAT
Whether or not an IPv6 address is IPv4-compatible. -
IS_IPV4_MAPPED
Whether an IPv6 address is a valid IPv4-mapped address. -
IS_IPV6
Whether or not an expression is a valid IPv6 address. -
IS_USED_LOCK
Check if lock is in use. -
MASTER_GTID_WAIT
Wait until slave reaches the GTID position. -
MASTER_POS_WAIT
Blocks until the replica has applied all specified updates. -
NAME_CONST
Returns the given value. -
RELEASE_ALL_LOCKS
Releases all named locks held by the current session. -
RELEASE_LOCK
Releases lock obtained with GET_LOCK(). -
SLEEP
Pauses for the given number of seconds. -
SYS_GUID
Returns a globally unique identifier (GUID). -
UUID
Returns a Universal Unique Identifier v1. -
UUID_SHORT
Return short universal identifier. -
UUID_v4
Returns a Universal Unique Identifier v4. -
UUID_v7
Returns a Universal Unique Identifier v7. -
VALUES / VALUE
Refer to columns in INSERT ... ON DUPLICATE KEY UPDATE.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
