在MySQL中存储IP地址的最有效方法 [英] Most efficient way to store IP Address in MySQL

问题描述

在MySQL中存储和检索IP地址的最有效方法是什么?现在我正在做:

What is the most efficient way to store and retrieve IP addresses in MySQL? Right now I'm doing:

SELECT * FROM logins WHERE ip = '1.2.3.4'

其中ip是VARCHAR(15)字段.

有更好的方法吗?

推荐答案

对于 IPv4地址，您可能需要存储它们作为int unsigned并使用 INET_ATON() 和 INET_NTOA() 函数从其返回IP地址数值，反之亦然.

For IPv4 addresses, you may want to store them as an int unsigned and use the INET_ATON() and INET_NTOA() functions to return the IP address from its numeric value, and vice versa.

示例:

SELECT INET_ATON('127.0.0.1');

+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
|             2130706433 | 
+------------------------+
1 row in set (0.00 sec)


SELECT INET_NTOA('2130706433');

+-------------------------+
| INET_NTOA('2130706433') |
+-------------------------+
| 127.0.0.1               | 
+-------------------------+
1 row in set (0.02 sec)

这篇关于在MySQL中存储IP地址的最有效方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！