Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlÓï¾äµÄ¼òµ¥ÎÊÌâ

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±í½á¹¹ÈçÏ£º


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'
ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'
лл
select * from a
where columna like '%/%%' escape '/'

UP

SELECT * from a ......

sql ´æ´¢¹ý³Ì

ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡

Óû§ÃûÊÇΨһµÄ
±íA  ×Ö¶Î
Óû§Ãû£ºName  ,ÓÊÏ䣺Ema ......

ÇóÒ»¸öSQLµÃ²éѯÓï¾ä

ÒÑÖªÒ»¸ö¹©Ó¦Çé¿ö±í SPJ
ÓÐÊôÐÔ ¹©Ó¦É̺ÅÂë SNO
  Áã¼þºÅÂë PNO
  ¹¤³ÌÏîÄ¿ºÅÂë JNO
  Áã¼þÊýÁ¿ QTY
ÇóÂú×ãÏÂÃæÒªÇóµÄ¹©Ó¦É̺ÅÂ룬¸Ã¹©Ó¦É̹©Ó¦¸øÄ³¸ö¹¤³ÌÁã¼þP1 µÄÊýÁ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ