Important

You are viewing the archived documentation of TiDB, which no longer receives updates. It is recommended that you use the latest LTS version of the TiDB database.

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
`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

Unsupported functions

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