跳到主要内容

INET_ATON

Converts an IPv4 address to a 32-bit integer.

Syntax​

INET_ATON ( <ip> )

Arguments​

ArgumentsDescription
<ip>a dotted-quad IP address string, eg “1.2.3.4”

Return Type​

Integer

Examples​

SELECT INET_ATON('1.2.3.4');
+----------------------+
| INET_ATON('1.2.3.4') |
+----------------------+
|             16909060 |
+----------------------+


SELECT INET_ATON('127.0.0.1');
+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
|             2130706433 |
+------------------------+