Conversion

INET6_ATON

MySQL

Mengkonversi IPv4 atau IPv6 address string ke binary format. Support kedua format IP.

Tipe hasil: VARBINARY(16)Diperbarui: 7 Jan 2026

Syntax

SQL

INET6_ATON(ip_string)

ip_stringVARCHARwajib

IPv4 atau IPv6 address string

SQL

1 SELECT HEX(INET6_ATON('192.168.1.1')) AS ip_hex;

Konversi IPv4 ke binary.

Hasil

ip_hex: C0A80101

SQL

1 SELECT HEX(INET6_ATON('2001:db8::1')) AS ip_hex;

Konversi IPv6 ke binary.

Hasil

ip_hex: 20010DB8000000000000000000000001

SQL

1 INSERT INTO connections (client_ip)
2 VALUES (INET6_ATON('::ffff:192.168.1.1'));

Store IPv4-mapped IPv6 address.

Hasil

(IP stored as binary)

1	INSERT INTO connections (client_ip)
2	VALUES (INET6_ATON('::ffff:192.168.1.1'));