Miscellaneous Functions

NameDescription
ANY_VALUE()Suppress ONLY_FULL_GROUP_BY value rejection
SLEEP()Sleep for a number of seconds
UUID()Return a Universal Unique Identifier (UUID)
VALUES()Defines the values to be used during an INSERT
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
GET_LOCK()Get a named lock
RELEASE_LOCK()Releases the named lock