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

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