Name | Description | 例子 |
---|---|---|
ANY_VALUE() | Suppress ONLY_FULL_GROUP_BY value rejection | |
BIN_TO_UUID() | Convert binary UUID to string | |
DEFAULT() | Return the default value for a table column | |
GROUPING() | Distinguish super-aggregate ROLLUP rows from regular rows | |
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 | |
IS_UUID() | Whether argument is a valid UUID | |
MASTER_POS_WAIT() | Block until the slave has read and applied all updates up to the specified position | |
NAME_CONST() | Cause the column to have the given name | |
SLEEP() | Sleep for a number of seconds | |
UUID() | 返回UUID | |
UUID_SHORT() | Return an integer-valued universal identifier | |
UUID_TO_BIN() | Convert string UUID to binary | |
VALUES() | Define the values to be used during an INSERT |
参考:
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html