IPV4
更新时间：2025-10-17
IPV4
描述
IPv4 类型，以 UInt32 的形式存储在 4 个字节中，用于表示 IPv4 地址。 取值范围是 ['0.0.0.0', '255.255.255.255']。
超出取值范围或者格式非法的输入将返回NULL
举例
建表示例如下：
Plain Text
1CREATE TABLE ipv4_test (
2 `id` int,
3 `ip_v4` ipv4
4) ENGINE=OLAP
5DISTRIBUTED BY HASH(`id`) BUCKETS 4
6PROPERTIES (
7"replication_allocation" = "tag.location.default: 1"
8);插入数据示例：
Plain Text
1insert into ipv4_test values(1, '0.0.0.0');
2insert into ipv4_test values(2, '127.0.0.1');
3insert into ipv4_test values(3, '59.50.185.152');
4insert into ipv4_test values(4, '255.255.255.255');
5insert into ipv4_test values(5, '255.255.255.256'); // invalid data查询数据示例：
Plain Text
1mysql> select * from ipv4_test order by id;
2+------+-----------------+
3| id | ip_v4 |
4+------+-----------------+
5| 1 | 0.0.0.0 |
6| 2 | 127.0.0.1 |
7| 3 | 59.50.185.152 |
8| 4 | 255.255.255.255 |
9| 5 | NULL |
10+------+-----------------+keywords
IPV4