MySQL
inet_aton函数
inet_aton(expr)
mysql> SELECT INET_ATON('192.168.1.88') address_number;
+----------------+
| address_number |
+----------------+
| 3232235864 |
+----------------+
1 row in set (0.00 sec)
上例中数字按照 192 × 25 6 3 + 168 × 25 6 2 + 1 × 25 6 1 + 88 × 25 6 0 192\times256^3 + 168\times256^2 + 1\times256^1 + 88\times256^0 192×