Important
You are viewing the documentation of an older version of the TiDB database (TiDB v5.4). 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 |
|---|---|
GET_LOCK() | Get a named lock TiDB #10929 |
RELEASE_LOCK() | Releases the named lock TiDB #10929 |
UUID_SHORT() | Provides a UUID that is unique given certain assumptions not present in TiDB TiDB #4620 |
MASTER_WAIT_POS() | Relates to MySQL replication |