versioned_docs/version-3.0/sql-manual/sql-functions/ip-functions/ipv4-to-ipv6.md

{ “title”: “IPV4_TO_IPV6”, “language”: “en” }

IPV4_TO_IPV6

IPV4_TO_IPV6

Description

Syntax

IPV6 IPV4_TO_IPV6(IPV4 ipv4)

accept an IPv4 type address and return the converted IPv6 type address.

Example

mysql [(none)]>select ipv6_num_to_string(ipv4_to_ipv6(to_ipv4('192.168.0.1')));
+----------------------+
| '::ffff:192.168.0.1' |
+----------------------+
| ::ffff:192.168.0.1   |
+----------------------+
1 row in set (0.02 sec)

Keywords

IPV4_TO_IPV6, IP