Conversion

INET_ATON

MySQL

Mengkonversi IPv4 address string ke unsigned integer. Berguna untuk storage dan range queries.

Tipe hasil: BIGINT UNSIGNEDDiperbarui: 7 Jan 2026

Syntax

SQL

INET_ATON(ip_string)

ip_stringVARCHARwajib

IPv4 address dalam format dotted-decimal

SQL

1 SELECT INET_ATON('192.168.1.100') AS ip_int;

Konversi IP ke integer.

Hasil

ip_int: 3232235876

SQL

1 INSERT INTO ip_logs (ip_address, access_time)
2 VALUES (INET_ATON('10.0.0.1'), NOW());

Store IP sebagai integer.

Hasil

(IP stored as integer)

SQL

1 SELECT * FROM access_logs
2 WHERE ip_address BETWEEN 
3   INET_ATON('192.168.1.0') AND 
4   INET_ATON('192.168.1.255');

Query range IP addresses.

Hasil

(all IPs in 192.168.1.x subnet)

1	INSERT INTO ip_logs (ip_address, access_time)
2	VALUES (INET_ATON('10.0.0.1'), NOW());