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 |