Miscellaneous Functions

TiDB supports most of the miscellaneous functions available in MySQL 5.7.

Supported functions

Name	Description
ANY_VALUE()	Suppress `ONLY_FULL_GROUP_BY` value rejection
BIN_TO_UUID()	Convert UUID from binary format to text format
DEFAULT()	Returns the default value for a table column
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
NAME_CONST()	Can be used to rename a column name
SLEEP()	Sleep for a number of seconds. Note that for TiDB Serverless clusters, the `SLEEP()` function has a limitation wherein it can only support a maximum sleep time of 300 seconds.
UUID()	Return a Universal Unique Identifier (UUID)
UUID_TO_BIN()	Convert UUID from text format to binary format
VALUES()	Defines the values to be used during an INSERT

Name	Description
UUID_SHORT()	Provides a UUID that is unique given certain assumptions not present in TiDB TiDB #4620
MASTER_WAIT_POS()	Relates to MySQL replication