{"id":6351,"date":"2014-05-31T17:04:20","date_gmt":"2014-05-31T09:04:20","guid":{"rendered":"http:\/\/jpuyy.com\/?p=6351"},"modified":"2014-08-02T20:54:55","modified_gmt":"2014-08-02T12:54:55","slug":"mysql-ip-address-function","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=6351","title":{"rendered":"mysql\u5185\u7f6eip\u8f6c\u6362\u51fd\u6570"},"content":{"rendered":"

\u5c06\u5341\u8fdb\u5236\u6570\u8f6c\u6362\u4e3aipv4\u5730\u5740<\/p>\n

MariaDB [(none)]> select inet_aton('192.168.1.23');\r\n+---------------------------+\r\n| inet_aton('192.168.1.23') |\r\n+---------------------------+\r\n|                3232235799 |\r\n+---------------------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n
\u5c06ipv4\u5730\u5740\u8f6c\u6362\u4e3a\u5341\u8fdb\u5236\u6570<\/p>\n
MariaDB [(none)]> select inet_ntoa(3232235799);\r\n+-----------------------+\r\n| inet_ntoa(3232235799) |\r\n+-----------------------+\r\n| 192.168.1.23          |\r\n+-----------------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n
\u81ea\u5df1\u5e38\u7528\u7684\u51e0\u4e2a\u503c<\/p>\n
10.0.0.0    167772160
\n10.255.255.255    184549375
\n192.168.0.0    3232235520
\n192.168.255.255    3232301055<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5c06\u5341\u8fdb\u5236\u6570\u8f6c\u6362\u4e3aipv4\u5730\u5740 MariaDB [(none)]> select inet_aton(‘192.168.1.23’); +—————————+ | inet_aton(‘192.168.1.23’) | +—————————+ | 3232235799 | +—————————+ 1 row in set (0.00 sec) \u5c06ipv4\u5730\u5740\u8f6c\u6362\u4e3a\u5341\u8fdb\u5236\u6570 MariaDB [(none)]> select inet_ntoa(3232235799); +———————–+ | inet_ntoa(3232235799) | +———————–+ | 192.168.1.23 | +———————–+ 1 row in set (0.00 sec) \u81ea\u5df1\u5e38\u7528\u7684\u51e0\u4e2a\u503c 10.0.0.0 167772160 10.255.255.255 184549375 192.168.0.0 3232235520 192.168.255.255 3232301055<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-6351","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6351"}],"version-history":[{"count":7,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6351\/revisions"}],"predecessor-version":[{"id":6561,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/6351\/revisions\/6561"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}