Conversion

INET6_NTOA

MySQL

Mengkonversi binary IP address ke string format. Kebalikan dari INET6_ATON().

Tipe hasil: VARCHARDiperbarui: 7 Jan 2026

Syntax

SQL

INET6_NTOA(binary_ip)

binary_ipVARBINARY(16)wajib

IP address dalam format binary

SQL

1 SELECT INET6_NTOA(INET6_ATON('192.168.1.1')) AS ip_str;

Round-trip konversi IPv4.

Hasil

ip_str: 192.168.1.1

SQL

1 SELECT INET6_NTOA(client_ip) AS ip_address
2 FROM connections;

Display stored IP addresses.

Hasil

(readable IP addresses)

SQL

1 SELECT 
2   INET6_NTOA(ip) AS ip_str,
3   CASE WHEN LENGTH(ip) = 4 THEN 'IPv4' ELSE 'IPv6' END AS ip_type
4 FROM ips;

Detect IP version dari binary length.

Hasil

(IP with type)

1	SELECT INET6_NTOA(client_ip) AS ip_address
2	FROM connections;

1	SELECT
2	INET6_NTOA(ip) AS ip_str,
3	CASE WHEN LENGTH(ip) = 4 THEN 'IPv4' ELSE 'IPv6' END AS ip_type
4	FROM ips;