IPv4 address data type. Stores IPv4 addresses as 4-byte binary strings for efficient storage and retrieval.
INET4 is a data type to store IPv4 addresses, as 4-byte binary strings.
Casting from data types to INET6 is permitted, allowing for example comparisons between the two data types, and for INET4 values to be inserted into INET6 columns.
Casting from data types to INET6 is not permitted.
Casting from INET4 to is permitted, allowing direct inserts.
Comparisons are also permitted:
This page is licensed: CC BY-SA / Gnu FDL
INET4CREATE OR REPLACE TABLE t1 (a INET4);
INSERT INTO t1 VALUES('0.0.0.0'), ('255.10.0.0'), ('255.255.255.255');
INSERT INTO t1 VALUES (0xa0000001);
INSERT INTO t1 VALUES (0xf0000000);
INSERT INTO t1 VALUES (0xff000001);
SELECT HEX(a), a FROM t1 ORDER BY a;
+----------+-----------------+
| HEX(a) | a |
+----------+-----------------+
| 00000000 | 0.0.0.0 |
| A0000001 | 160.0.0.1 |
| F0000000 | 240.0.0.0 |
| FF000001 | 255.0.0.1 |
| FF0A0000 | 255.10.0.0 |
| FFFFFFFF | 255.255.255.255 |
+----------+-----------------+CREATE TABLE t1 (a INET6);
INSERT INTO t1 VALUES('0.0.0.0'), ('255.10.0.0'), ('255.255.255.255');
Query OK, 3 rows affected (0.027 sec)CREATE OR REPLACE TABLE t1 (i4 INET4, i6 INET6);
INSERT INTO t1 VALUES('10.10.10.10','::ffff:192.168.0.1');
SELECT LEAST(i4,i6) FROM t1;
+--------------------+
| LEAST(i4,i6) |
+--------------------+
| ::ffff:10.10.10.10 |
+--------------------+CREATE TABLE t1 (a INET6);
INSERT INTO t1 VALUES('0.0.0.0'), ('255.10.0.0'), ('255.255.255.255');
ERROR 1292 (22007): Incorrect inet6 value: '0.0.0.0' for column `test`.`t1`.`a` at row 1