SqlÊý¾ÝÓÅ»¯·½°¸
1¡¢Ê¹ÓÃË÷ÒýÀ´¸ü¿ìµØ±éÀú±í¡£
ȱʡÇé¿öϽ¨Á¢µÄË÷ÒýÊÇ·ÇȺ¼¯Ë÷Òý£¬µ«ÓÐʱËü²¢²»ÊÇ×î¼ÑµÄ¡£ÔÚ·ÇȺ¼¯Ë÷ÒýÏ£¬Êý¾ÝÔÚÎïÀíÉÏËæ»ú´æ·ÅÔÚÊý¾ÝÒ³ÉÏ¡£ºÏÀíµÄË÷ÒýÉè¼ÆÒª½¨Á¢ÔÚ¶Ô¸÷ÖÖ²éѯµÄ·ÖÎöºÍÔ¤²âÉÏ¡£
Ò»°ãÀ´Ëµ£º
a.ÓдóÁ¿Öظ´Öµ¡¢ÇÒ¾³£Óз¶Î§²éѯ£¨ > ,< £¬> =,< =£©ºÍorder by¡¢group by·¢ÉúµÄÁУ¬¿É¿¼
Âǽ¨Á¢Èº¼¯Ë÷Òý£»
b.¾³£Í¬Ê±´æÈ¡¶àÁУ¬ÇÒÿÁж¼º¬ÓÐÖØ¸´Öµ¿É¿¼Âǽ¨Á¢×éºÏË÷Òý£»
c.×éºÏË÷ÒýÒª¾¡Á¿Ê¹¹Ø¼ü²éѯÐγÉË÷Òý¸²¸Ç£¬Æäǰµ¼ÁÐÒ»¶¨ÊÇʹÓÃ×îÆµ·±µÄÁС£Ë÷ÒýËäÓÐÖúÓÚÌá¸ßÐÔÄܵ«²»ÊÇË÷ÒýÔ½¶àÔ½ºÃ£¬Ç¡ºÃÏà·´¹ý¶àµÄË÷Òý»áµ¼ÖÂϵͳµÍЧ¡£
Óû§ÔÚ±íÖÐÿ¼Ó½øÒ»¸öË÷Òý£¬Î¬»¤Ë÷Òý¼¯ºÏ¾ÍÒª×öÏàÓ¦µÄ¸üй¤×÷¡£
2¡¢ÔÚº£Á¿²éѯʱ¾¡Á¿ÉÙÓøñʽת»»¡£
3¡¢ORDER BYºÍGROPU BYʹÓÃORDER BYºÍGROUP BY¶ÌÓÈκÎÒ»ÖÖË÷Òý¶¼ÓÐÖúÓÚSELECTµÄÐÔÄÜÌá¸ß¡£
4¡¢IN¡¢OR×Ӿ䳣»áʹÓù¤×÷±í£¬Ê¹Ë÷ÒýʧЧ¡£Èç¹û²»²úÉú´óÁ¿Öظ´Öµ£¬¿ÉÒÔ¿¼ÂǰÑ×Ó¾ä²ð¿ª¡£²ð¿ªµÄ×Ó¾äÖÐÓ¦¸Ã°üº¬Ë÷Òý¡£
SqlµÄÓÅ»¯ÔÔò2£º
1¡¢Ö»ÒªÄÜÂú×ãÄãµÄÐèÇó£¬Ó¦¾¡¿ÉÄÜʹÓøüСµÄÊý¾ÝÀàÐÍ£ºÀýÈçʹÓÃMEDIUMINT´úÌæINT
2¡¢¾¡Á¿°ÑËùÓеÄÁÐÉèÖÃΪNOT NULL£¬Èç¹ûÄãÒª±£´æNULL£¬ÊÖ¶¯È¥ÉèÖÃËü£¬¶ø²»ÊǰÑËüÉèΪĬÈÏÖµ¡£
3¡¢¾¡Á¿ÉÙÓÃVARCHAR¡¢TEXT¡¢BLOBÀàÐÍ
4¡¢Èç¹ûÄãµÄÊý¾ÝÖ»ÓÐÄãËùÖªµÄÉÙÁ¿µÄ¼¸¸ö¡£×îºÃʹÓÃENUMÀàÐÍ
5¡¢ÕýÈçgraymiceËù½²µÄÄÇÑù£¬½¨Á¢Ë÷Òý¡£
ÒÔÏÂÊÇÎÒ×öµÄÒ»¸öʵÑ飬¿ÉÒÔ·¢ÏÖË÷ÒýÄܼ«´óµØÌá¸ß²éѯµÄЧÂÊ£º
ÎÒÓÐÒ»¸ö»áÔ±ÐÅÏ¢±íusers£¬Àï±ßÓÐ37365ÌõÓû§¼Ç¼£º
ÔÚ²»¼ÓË÷ÒýµÄʱºò½øÐвéѯ£º
sqlÓï¾äA:
select * from users where username like ’%Ðí%’;
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º1.40,0.54,0.54,0.54,0.53,0.55,0.54 ¹²ÕÒµ½960Ìõ¼Ç¼
sqlÓï¾äB:
select * from users where username like ’Ðí%’;
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º0.53,0.53,0.53,0.54,0.53,0.53,0.54,0.54 ¹²ÕÒµ½836Ìõ¼Ç¼
sqlÓï¾äC:
select * from users where username like ’%Ðí’;
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º0.51,0.51,0.52,0.52,0.51,0.51,0.52,0.51 ¹²ÕÒµ½7Ìõ¼Ç¼
ΪusernameÁÐÌí¼ÓË÷Òý:
create index usernameindex on users(username(6));
Ôٴβéѯ£º
sqlÓï¾äA:
select * from users where username like ’%Ðí%’;
ÔÚMysql-FrontÖеÄ8´Î²éѯʱ³¤Îª£º0.35,0.34,0.34,0.35,0.34,0.34,0.
Ïà¹ØÎĵµ£º
SQL Server 7.0 ÈëÃÅ(7)
ʱ¼ä£º2001/02/06 11:57 ×÷Õߣº¶¹¶¹ CHINAASP
¡¡ &nbs ......
¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ ¡· ÖÜÆæ
SQL Server 2005µÄ°æ±¾£º
1. SQL Server 2005 Enterprise Edition ÆóÒµ°æ(32λºÍ64λ)
ÊÊÓÃÓÚ³¬´óÐÍÆóÒµ¡£Enterprise Edition ÊÇ×îÈ«ÃæµÄSQL Server°æ±¾£¬Êdz¬´óÐÍÆóÒµµÄÀíÏëÑ¡Ôñ£¬Äܹ»Âú×ã×ÔÓµÄÒªÇ󡣸ð汾»¹Í ......
ѧϰsqlµÄ±Ø¾ÎÊÌâ¡£
ѧÉú±ístudent (idѧºÅ SnameÐÕÃû SdeptËùÔÚϵ)
¿Î³Ì±íCourse (crscode¿Î³ÌºÅ name¿Î³ÌÃû)
ѧÉúÑ¡¿Î±ítranscript (studidѧºÅ &nbs ......
ÆôÓÃc2ÉóºËÃüÁîÈçÏ£º
EXEC sp_configure 'c2 audit mode', '1' RECONFIGURE
SQL ServerÒÔ128KB´óСµÄ¿éΪµ¥Î»°ÑÊý¾ÝдÈë¸ú×ÙÎļþ¡£Òò´Ë£¬µ±SQL Server·ÇÕý³£Í£Ö¹Ê±£¬×î¶à¿ÉÄܶªÊ§128
......
1
:
replace
º¯Êý
µÚÒ»¸ö²ÎÊýÄãµÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÄãÏëÌæ»»µÄ²¿·Ö£¬µÚÈý¸ö²ÎÊýÄãÒªÌæ»»³Éʲô
select
replace
(
'
lihan
'
,
'
a
'
,
'
b
'
)
--
---------------------------
lihbn
£¨ËùÓ°ÏìµÄÐÐÊýΪ
1
ÐУ©
==== ......