в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:36Z

1 версия

Новая страница

== INET_ATON() also understands short-form IP addresses==



<source lang="sql">
mysql>
mysql> SELECT INET_ATON("127.0.0.1"), INET_ATON("127.1");
+------------------------+--------------------+
| INET_ATON("127.0.0.1") | INET_ATON("127.1") |
+------------------------+--------------------+
| 2130706433 | 2130706433 |
+------------------------+--------------------+
1 row in set (0.00 sec)
mysql></source>

== INET_ATON(expr): Given a network address, returns an integer that represents the numeric value of the address.==

<p>The generated number is always in network byte order.</p>
<p>The number is calculated as 68*256^3 + 207*256^2 + 224*256 + 40.</p>



<source lang="sql">
mysql>
mysql> SELECT INET_ATON("68.207.224.40");
+----------------------------+
| INET_ATON("68.207.224.40") |
+----------------------------+
| 1154474024 |
+----------------------------+
1 row in set (0.00 sec)
mysql>
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/Miscellaneous Functions/INET ATON - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия