INET6_NTOA
INET6_NTOA
INET6_NTOA
description
Syntax
VARCHAR INET6_NTOA(VARCHAR ipv6_num)
接受字符串类型的二进制格式的IPv6地址。以文本格式返回此地址的字符串。 IPv6映射的IPv4地址以::ffff:111.222.33。
example
mysql> select inet6_ntoa(unhex('2A0206B8000000000000000000000011')) as addr;
+--------------+
| addr |
+--------------+
| 2a02:6b8::11 |
+--------------+
1 row in set (0.01 sec)
keywords
INET6_NTOA, IP
