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

SQL×¢Èë½Ì³ÌÖ®½ø½×ƪ

ÔÚÈëÃÅÆª£¬ÎÒÃÇѧ»áÁˣӣѣÌ×¢ÈëµÄÅжϷ½·¨£¬µ«ÕæÕýÒªÄõ½ÍøÕ¾µÄ±£ÃÜÄÚÈÝ£¬ÊÇÔ¶Ô¶²»¹»µÄ¡£½ÓÏÂÀ´£¬ÎÒÃǾͼÌÐøÑ§Ï°ÈçºÎ´ÓÊý¾Ý¿âÖлñÈ¡ÏëÒª»ñµÃµÄÄÚÈÝ£¬Ê×ÏÈ£¬ÎÒÃÇÏÈ¿´¿´£Ó£Ñ£Ì×¢ÈëµÄÒ»°ã²½Ö裺
µÚÒ»½Ú¡¢£Ó£Ñ£Ì×¢ÈëµÄÒ»°ã²½Öè
¡¡¡¡Ê×ÏÈ£¬Åжϻ·¾³£¬Ñ°ÕÒ×¢Èëµã£¬ÅжÏÊý¾Ý¿âÀàÐÍ£¬ÕâÔÚÈëÃÅÆªÒѾ­½²¹ýÁË¡£
¡¡¡¡Æä´Î£¬¸ù¾Ý×¢Èë²ÎÊýÀàÐÍ£¬ÔÚÄÔº£ÖÐÖØ¹¹SQLÓï¾äµÄԭò£¬°´²ÎÊýÀàÐÍÖ÷Òª·ÖΪÏÂÃæÈýÖÖ£º
¡¡¡¡(A) ID=49 ÕâÀà×¢ÈëµÄ²ÎÊýÊÇÊý×ÖÐÍ£¬SQLÓï¾äԭò´óÖÂÈçÏ£º
Select * from ±íÃû where ×Ö¶Î=49
¡¡¡¡×¢ÈëµÄ²ÎÊýΪID=49 And [²éѯÌõ¼þ]£¬¼´ÊÇÉú³ÉÓï¾ä£º
Select * from ±íÃû where ×Ö¶Î=49 And [²éѯÌõ¼þ]
¡¡¡¡(B) Class=Á¬Ðø¾ç ÕâÀà×¢ÈëµÄ²ÎÊýÊÇ×Ö·ûÐÍ£¬SQLÓï¾äԭò´óÖ¸ÅÈçÏ£º
Select * from ±íÃû where ×Ö¶Î=’Á¬Ðø¾ç’
¡¡¡¡×¢ÈëµÄ²ÎÊýΪClass=Á¬Ðø¾ç’ and [²éѯÌõ¼þ] and ‘’=’ £¬¼´ÊÇÉú³ÉÓï¾ä£º
¡¡¡¡(C) ËÑË÷ʱû¹ýÂ˲ÎÊýµÄ£¬Èçkeyword=¹Ø¼ü×Ö£¬SQLÓï¾äԭò´óÖÂÈçÏ£º
Select * from ±íÃû where ×Ö¶Îlike ’%¹Ø¼ü×Ö%’
¡¡¡¡×¢ÈëµÄ²ÎÊýΪkeyword=’ and [²éѯÌõ¼þ] and ‘%25’=’£¬ ¼´ÊÇÉú³ÉÓï¾ä£º
Select * from ±íÃû where×Ö¶Îlike ’%’ and [²éѯÌõ¼þ] and ‘%’=’%’
¡¡¡¡½Ó×Å£¬½«²éѯÌõ¼þÌæ»»³ÉSQLÓï¾ä£¬²Â½â±íÃû£¬ÀýÈ磺
ID=49 And (Select Count(*) from Admin)>=0
¡¡¡¡Èç¹ûÒ³Ãæ¾ÍÓëID=49µÄÏàͬ£¬ËµÃ÷¸½¼ÓÌõ¼þ³ÉÁ¢£¬¼´±íAdmin´æÔÚ£¬·´Ö®£¬¼´²»´æÔÚ£¨ÇëÀμÇÕâÖÖ·½·¨£©¡£Èç´ËÑ­»·£¬Ö±ÖÁ²Âµ½±íÃûΪֹ¡£
¡¡¡¡±íÃû²Â³öÀ´ºó£¬½«Count(*)Ìæ»»³ÉCount(×Ö¶ÎÃû)£¬ÓÃͬÑùµÄÔ­Àí²Â½â×Ö¶ÎÃû¡£
¡¡¡¡ÓÐÈË»á˵£ºÕâÀïÓÐһЩżȻµÄ³É·Ö£¬Èç¹û±íÃûÆðµÃºÜ¸´ÔÓû¹æÂɵģ¬ÄǸù±¾¾ÍûµÃÍæÏÂÈ¥ÁË¡£ËµµÃºÜ¶Ô£¬ÕâÊÀ½ç¸ù±¾¾Í²»´æÔÚ100%³É¹¦µÄºÚ¿Í¼¼Êõ£¬²ÔÓ¬²»¶£ÎÞ·ìµÄµ°£¬ÎÞÂ۶༼Êõ¶à¸ßÉîµÄºÚ¿Í£¬¶¼ÊÇÒòΪ±ðÈ˵ijÌÐòдµÃ²»ÑÏÃÜ»òʹÓÃÕß±£ÃÜÒâʶ²»¹»£¬²ÅÓеÃÏÂÊÖ¡£
¡¡¡¡ÓеãÅÜÌâÁË£¬»°Ëµ»ØÀ´£¬¶ÔÓÚSQLServerµÄ¿â£¬»¹ÊÇÓа취ÈóÌÐò¸æËßÎÒÃDZíÃû¼°×Ö¶ÎÃûµÄ£¬ÎÒÃÇÔڸ߼¶ÆªÖлá×ö½éÉÜ¡£
¡¡¡¡×îºó£¬ÔÚ±íÃûºÍÁÐÃû²Â½â³É¹¦ºó£¬ÔÙʹÓÃSQLÓï¾ä£¬µÃ³ö×ֶεÄÖµ£¬ÏÂÃæ½éÉÜÒ»ÖÖ×î³£Óõķ½·¨£­AsciiÖð×Ö½âÂë·¨£¬ËäÈ»ÕâÖÖ·½·¨ËٶȺÜÂý£¬µ«¿Ï¶¨ÊÇ¿ÉÐеķ½·¨¡£
¡¡¡¡ÎÒÃǾٸöÀý×Ó£¬ÒÑÖª±íAdminÖдæÔÚusername×ֶΣ¬Ê×ÏÈ£¬ÎÒÃÇÈ¡µÚÒ»Ìõ¼Ç¼£¬²âÊÔ³¤¶È£º
http:/


Ïà¹ØÎĵµ£º

SQLѧϰ(һ)

ÒÔǰѧϰÁËSQLÏà¹Ø·½ÃæµÄ֪ʶ£¬¶ÔÒ²ÄÜÏà¶ÔÊìÁ·Ê¹ÓÃSQL£¬µ«Ëæ×ŽøÒ»²½µÄʹÓ㬷¢ÏÖ×Ô¼ºËƺõÓÖʲô¶¼²»¶®£¬ÒòΪ×Ô¼ºÖ»ÖªµÀÈçºÎʹÓ㬲»ÖªµÀʹÓõÄÊÇʲôԭÀí£¬ÕâÑùµÄÒ²Ö»ÄÜ˵ÊÇÒ»¸öÊìÁ·Ê¹Óù¤£¬ÏÖÔÚÖØÐÂѧϰһ±é£¬Ï£ÍûÔÚ±ðÈËÎÊÎÒÖ®ËùÒÔÈ»µÄʱºò£¬Ò²Äܻشð¸öÒ»¶þÈý¡£
Ò»¡¢Çø±ðÊÂÎñÓëÆÕͨ³ÌÐòµÄÌØÕ÷ͨ³£ËõдΪACIDÐÔÖÊ
Ô­×ÓÐÔ ......

SQL code

C = CHECK Ô¼Êø
D = ĬÈÏÖµ»ò DEFAULT Ô¼Êø
F = FOREIGN KEY Ô¼Êø
FN = ±êÁ¿º¯Êý
IF = ÄÚǶ±íº¯Êý
K = PRIMARY KEY »ò UNIQUE Ô¼Êø
L = ÈÕÖ¾
P = ´æ´¢¹ý³Ì
R = ¹æÔò
RF = ¸´ÖÆÉ¸Ñ¡´æ´¢¹ý³Ì
S = ϵͳ±í
TF = ±íº¯Êý
TR = ´¥·¢Æ÷
U = Óû§±í
V = ÊÓͼ
X = À©Õ¹´æ´¢¹ý³Ì
......

Oracle ²éѯ²¢É¾³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä


²éѯ¼°É¾³ýÖØ¸´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)
 
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......

ADO.NETÖÐSQL ServerÊý¾Ý¿âÁ¬½Ó³Ø


Á¬½Óµ½Êý¾Ý¿â·þÎñÆ÷ͨ³£Óɼ¸¸öÐèÒªºÜ³¤Ê±¼äµÄ²½Öè×é³É¡£ ±ØÐ뽨Á¢ÎïÀíͨµÀ£¨ÀýÈçÌ×½Ó×Ö»òÃüÃû¹ÜµÀ£©£¬±ØÐëÓë·þÎñÆ÷½øÐгõ´ÎÎÕÊÖ£¬±ØÐë·ÖÎöÁ¬½Ó×Ö·û´®ÐÅÏ¢£¬±ØÐëÓÉ·þÎñÆ÷¶ÔÁ¬½Ó½øÐÐÉí·ÝÑéÖ¤£¬±ØÐëÔËÐмì²éÒÔ±ãÔÚµ±Ç°ÊÂÎñÖеǼǣ¬µÈµÈ¡£
ʵ¼ÊÉÏ£¬´ó¶àÊýÓ¦ÓóÌÐò½öʹÓÃÒ»¸ö»ò¼¸¸ö²»Í¬µÄÁ¬½ÓÅäÖᣠÕâÒâζ×ÅÔÚÖ´ÐÐÓ¦ÓóÌÐòÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ