Doc Menu
Important

You are viewing the documentation of an older version of the TiDB database (TiDB v2.1).

It is recommended that you use the latest stable version of the TiDB database.

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