对于IPv4地址,您可能需要将其存储为,
intunsigned并使用
INET_ATON()和
INET_NTOA()函数从其数字值返回IP地址,反之亦然。
例:
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)


