Skip to content

Latest commit

 

History

History
37 lines (31 loc) · 3.91 KB

miscellaneous-functions.md

File metadata and controls

37 lines (31 loc) · 3.91 KB
title summary aliases
Miscellaneous Functions
Learn about miscellaneous functions in TiDB.
/docs/dev/functions-and-operators/miscellaneous-functions/
/docs/dev/reference/sql/functions-and-operators/miscellaneous-functions/

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