IP_Liulang±íµÄÊý¾ÝÈ磺
id ip IP_datetime IP_url
749 127.0.0.1 2009-11-17 11:48:01.967 Index.aspx
750 127.0.0.1 2009-11-17 11:48:03.403 ChatRoom
751 127.0.0.1 2009-11-17 11:48:04.543 Task
752 127.0.0.1 2009-11-17 11:48:11.780 VFClassroom
753 127.0.0.1 2009-11-17 11:48:12.717 Game
754 127.0.0.1 2009-11-17 11:48:13.717 Zsy
755 127.0.0.1 2009-11-17 11:48:14.733 CoursewareManagement
756 127.0.0.1 2009-11-17 11:48:16.000 friend
757 127.0.0.1 2009-11-17 11:48:18.687 http://localhost:1147/ttxs/user/RefLog.aspx
758 127.0.0.1 2009-11-17 11:48:19.047 http://localhost:1147/ttxs/user/ValidateCode.aspx
759 127.0.0.1 2009-11-17 11:48:20.750 http://localhost:1147/ttxs/index.aspx
760 127.0.0.1 2009-11-17 11:48:22.530 friend
761 127.0.0.1 2009-11-17 11:48:23.937 VFClassroom
762 127.0.0.1 2009-11-17 11:48:25.043 Task
763 127.0.0.1 2009-11-17 11:48:27.750 ChatRoom
764 127.0.0.1 2009-11-17 11:48:29.357 http://localhost:1147/ttxs/about/help.aspx
765 127.0.0.1 2009-11-17 11:48:33.187 CoursewareManagement
766 127.0.0.1 2009-11-17 11:48:34.403 http://localhost:1147/ttxs/index.aspx
ÎÒҪʵÏÖµÄÊÇ£¬Í¬Ò»ÌìÄÚÓжàÉÙ¸ö²»Í¬µÄip·ÃÎʹý Ò»ÏÂÖ¸¶¨µÄÒ³Ãæ¡££¨ÊDz»Í¬IPÔÚͬһÌìµÄ×ÜÊý£©
²åÈëµ½ÈçÏÂ±í£º
IP_page±í½á¹¹ÈçÏ£º
´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡
Óû§ÃûÊÇΨһµÄ
±íA ×Ö¶Î
Óû§Ãû£ºName ,ÓÊÏ䣺Ema ......