MySQL Miscellaneous Functions(ip uuid方法)

NameDescription例子
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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值