Convert network integer to an IP address by using the following function: INET_NTOA() : INET_ATON « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. INET_ATON

Convert network integer to an IP address by using the following function: INET_NTOA()

       
mysql>
mysql>
mysql> SELECT INET_NTOA(2130706433);
+-----------------------+
| INET_NTOA(2130706433) |
+-----------------------+
| 127.0.0.1             |
+-----------------------+
1 row in set (0.00 sec)

mysql>
mysql>








Related examples in the same category

1.To convert a network address to a numeric value, use INET_ATON() function: INET_ATON()
2.Sort the IP values using the INET_ATON( ) function, which converts a network address directly to its underlyin