MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

12.24 Miscellaneous Functions

Table 12.30 Miscellaneous Functions

Name Description
ANY_VALUE() Suppress ONLY_FULL_GROUP_BY value rejection
BIN_TO_UUID() Convert binary UUID to string
DEFAULT() Return the default value for a table column
GROUPING() Distinguish super-aggregate ROLLUP rows from regular rows
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_IPV4() Whether argument is an IPv4 address
IS_IPV4_COMPAT() Whether argument is an IPv4-compatible address
IS_IPV4_MAPPED() Whether argument is an IPv4-mapped address
IS_IPV6() Whether argument is an IPv6 address
IS_UUID() Whether argument is a valid UUID
MASTER_POS_WAIT() Block until the slave has read and applied all updates up to the specified position
NAME_CONST() Cause the column to have the given name
SLEEP() Sleep for a number of seconds
UUID() Return a Universal Unique Identifier (UUID)
UUID_SHORT() Return an integer-valued universal identifier
UUID_TO_BIN() Convert string UUID to binary
VALUES() Define the values to be used during an INSERT