IPV6_NUM_TO_STRING

SinceVersion dev

IPV6_NUM_TO_STRING

description

Syntax

VARCHAR IPV6_NUM_TO_STRING(VARCHAR ipv6_num)

接受字符串类型的二进制格式的IPv6地址。以文本格式返回此地址的字符串。 IPv6映射的IPv4地址以::ffff:111.222.33。

example

  1. mysql> select ipv6_num_to_string(unhex('2A0206B8000000000000000000000011')) as addr;
  2. +--------------+
  3. | addr         |
  4. +--------------+
  5. | 2a02:6b8::11 |
  6. +--------------+
  7. 1 row in set (0.01 sec)

keywords

IPV6_NUM_TO_STRING, IP