12.18 Miscellaneous Functions

Table 12.23 Miscellaneous Functions

NameDescription
DEFAULT()Return the default value for a table column
GET_LOCK()Get a named lock
INET_ATON()Return the numeric value of an IP address
INET_NTOA()Return the IP address from a numeric value
INET6_ATON()Return the numeric value of an IPv6 address
INET6_NTOA()Return the IPv6 address from a numeric value
IS_FREE_LOCK()Checks whether the named lock is free
IS_IPV4_COMPAT()Return true if argument is an IPv4-compatible address
IS_IPV4_MAPPED()Return true if argument is an IPv4-mapped address
IS_IPV4()Return true if argument is an IPv4 address
IS_IPV6()Return true if argument is an IPv6 address
IS_USED_LOCK()Checks whether the named lock is in use. Return connection identifier if true.
MASTER_POS_WAIT()Block until the slave has read and applied all updates up to the specified position
NAME_CONST()Causes the column to have the given name
RAND()Return a random floating-point value
RELEASE_LOCK()Releases the named lock
SLEEP()Sleep for a number of seconds
UUID_SHORT()Return an integer-valued universal identifier
UUID()Return a Universal Unique Identifier (UUID)
VALUES()Defines the values to be used during an INSERT