mysql:storing_ip
This is an old revision of the document!
MySQL - Storing IP
mysql> SELECT INET_ATON('192.168.10.50');
+----------------------------+
| INET_ATON('192.168.10.50') |
+----------------------------+
| 3232238130 |
+----------------------------+
1 row in set (0.00 sec)
mysql> SELECT INET_NTOA('3232238130');
+-------------------------+
| INET_NTOA('3232238130') |
+-------------------------+
| 192.168.10.50 |
+-------------------------+
1 row in set (0.00 sec)
mysql/storing_ip.1467420034.txt.gz · Last modified: 2020/07/15 09:30 (external edit)