Last active
June 23, 2016 15:29
-
-
Save imchao9/0b5ee39052e2aca2867eda86c12a8a45 to your computer and use it in GitHub Desktop.
mysql ip转数字 数字转ip
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #ip转数字 | |
| update tbl_mc_server s set s.`ip`= inet_aton("183.16.194.104") | |
| #数字转ip | |
| select inet_ntoa(ip) from tbl_mc_server |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment