ÇóÒ»MYSQL´æ´¢¹ý³Ì

±í½á¹¹ÈçÏ£º

begin_ip          end_ip                add1            add2
------------------------------------------------------------------------
194.77.0.0        194.77.255.255        µÂ¹ú            ÎÞ¾ßÌåµØµã
194.78.99.80      194.78.99.95          ±ÈÀûʱ          BOSTON UNIVERSITY
......

³õÉæmysql,ÇóÒ»´æ´¢¹ý³Ì£¬¸ù¾Ý´«ÈëµÄIP£¬ÕÒ³ö¶ÔÓ¦µÄµØÖ·£¨add1+add2)£¬±íÖÐbegin_ip±íʾÆðʼIP£¬end_ip±íʾÖÕÖ¹IP £¬Á½Õß×é³ÉÒ»¸öIP¶Î¡£
±ÈÈç´«ÈëµÄÊÇ 194.77.0.123£¬ÄÇô·µ»ØÖµ¾ÍÊÇ ¡°µÂ¹ú ÎÞ¾ßÌåµØµã¡±£¬Èç¹û´«ÈëµÄÊÇ 194.78.99.85 ÄÇô·µ»ØÖµÊÇ ¡°±ÈÀûʱBOSTON UNIVERSITY¡±£¬Èç¹û´«ÈëµÄIPûÕÒµ½£¬¾Í·µ»Ø¡°ÔÝÎÞ´ËIPÐÅÏ¢¡±
²»ÖªµÀÎҵıíÊöÊÇ·ñÇå³þ£¬»¹Çë¸÷λ¸ßÊִͽ̣¡Ð»Ð»

---

INET_ATON

º¹ ±È½ÏipµÄ

---

ÒýÓÃ

ÔÚMYSQLÖв»ÐèÒªÓô洢¹ý³Ì£¬Ö±½ÓÓÃSQLÓï¾ä¼ÓÉÏMYSQLµÄÄÚÖú¯Êý¾ÍÐÐÁË¡£

SQL codemysql>select*from t_yyhakusu;+--------------+----------------+--------+------------+| begin_ip| end_ip| add1| add2|+--------------+----------------+--------+------------+|194.77.0.0|194.77.255.255| µÂ¹ú| ÎÞ¾ßÌåµØµã||194.78.99.80|194.78.99.95| ±ÈÀûʱ| BOSTON|+--------------+----------------+--------+------------+2 rowsinset (0.11 sec)

mysql>