Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
INET_
On this page
Converts an IPv4 address to a 32-bit integer.
Syntax
INET_ATON ( ip )
Arguments
-
ip: a dotted-quad IP address, eg
1.
2. 3. 4
Return Type
Integer, or NULL if the IP address cannot be parsed.
Note
This function does not handle IPv6 addresses.
Examples
SELECT INET_ATON('1.2.3.4');
+----------------------+
| INET_ATON('1.2.3.4') |
+----------------------+
| 16909060 |
+----------------------+SELECT INET_ATON('127.1');
+--------------------+
| INET_ATON('127.1') |
+--------------------+
| 2130706433 |
+--------------------+SELECT INET_ATON('127.0.0.1');
+------------------------+
| INET_ATON('127.0.0.1') |
+------------------------+
| 2130706433 |
+------------------------+SELECT INET_ATON('2a03:2880:10:1f02:face:b00c::25');
+----------------------------------------------+
| INET_ATON('2a03:2880:10:1f02:face:b00c::25') |
+----------------------------------------------+
| NULL |
+----------------------------------------------+Related Topics
Last modified: April 4, 2023