1.简述
inet_aton:将ip地址转换成数字型 (ip_net_address_to_number)
inet_ntoa:将数字型转换成ip地址 (ip_net_number_to_address)
2.例子
SELECT INET_ATON('254.161.167.28');
-> 4272006940
SELECT INET_NTOA(4272006940);
-> '254.161.167.28'
![](https://img.haomeiwen.com/i3018070/ff50821adabe9fa9.png)
![](https://img.haomeiwen.com/i3018070/6f3a56664cb597d6.png)
参考文章链接:https://blog.csdn.net/fujian9544/article/details/90550274
网友评论