ÇóÒ»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>
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬ ×îºÃÓÐÔ´´úÂ룬лл Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º ½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
090929 18:14:02 [Note] Plugin 'FEDERATED' is disabled. 090929 18:14:02 [Note] Plugin 'InnoDB' is disabled. D:\mysql5.1\bin\mysqld: Too many arguments (first extra is 'd:/mysq ......
ÔÚÒ»¸ö±íÖÐÎÒÉèÖõ½autoidΪ×Ô¶¯Ôö³¤ÁÐ ÀýÈçÓÐÈçÏÂÊý¾Ý 1 ÕÅÈý ÄÐ 20 2 ÍõÎå ÄÐ 22 3 ÀîËÄ ÄÐ 25 4 ³Â´ó ÄÐ 19 ÏÖÔÚÎÒ°Ñ autoid=3 ºÍ autoid=4 µÄÁ½Ìõ¼Ç¼ɾ³ý È»ºóÎÒÔÙ²åÈëÒ»ÌõÊý¾Ý,À ......
Ï뽫mysqlÒ»¸öÊý¾Ý¿âÉϵÄһЩ±íÓ³Éäµ½Äڴ棬ÒÔÌá¸ß·ÃÎÊËٶȡ£¶øÇÒÕâЩ±í»áÓвåÈ롢ɾ³ýºÍ¸üеIJÙ×÷¡£ ÔÚmysqlÉÏÔõô×ö£¿ÄÜ·ñ¾ßÌå˵Ã÷Ôõô×ö£¿ mysql ĬÈϾÍÊÇ´ÓÄÚ´æÖжÁÈ¡±íÊý¾Ý½øÐвÙ×÷µÄ°¡ ÓÅ»¯²é ......