Mega Code Archive

 
Categories / MySQL / Function
 

Convert network integer to an IP address by using the following function

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