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