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

Äܲ»ÄÜÖ»ÓÃÒ»Ìõsql¹ýÂËÈçÏÂÄÚÈÝ£¿

Äܲ»ÄÜÖ»ÓÃÒ»Ìõsql¹ýÂËÈçÏÂÄÚÈÝ£¿
Ò»¸ö×Ö¶ÎÖÐÓÐÈçϼǼ
Ô­¼Ç¼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
½á¹û  a,b,c(Â˵ôͬÑùµÄ£©

SQL code:
select distinct Ò»¸ö×Ö¶Î from Ô­¼Ç¼


µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

Ô­¼Ç¼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
ÊÇÒ»Ìõ¼Ç¼£¿

13.2.7. SELECTÓï·¨
http://dev.mysql.com/doc/refman/5.1/zh/sql-syntax.html#select


ÔÚSELECT¹Ø¼ü´ÊµÄºóÃæ£¬Äú¿ÉÒÔʹÓÃÐí¶àÑ¡Ïî¡£ÕâЩѡÏî¿ÉÒÔÓ°ÏìÓï¾äµÄÔËÐС£

ALL, DISTINCTºÍDISTINCTROWÑ¡ÏîÖ¸¶¨ÊÇ·ñÖØ¸´ÐÐÓ¦±»·µ»Ø¡£Èç¹ûÕâЩѡÏîûÓб»¸ø¶¨£¬ÔòĬÈÏֵΪALL£¨ËùÓÐµÄÆ¥ÅäÐб»·µ»Ø£©¡£DISTINCTºÍDISTINCTROWÊÇͬÒå´Ê£¬ÓÃÓÚÖ¸¶¨½á¹û¼¯ºÏÖеÄÖØ¸´ÐÐÓ¦±»É¾³ý¡£


Ô­¼Ç¼ a,a,b,a,c,a,b,c,b,c,a,(¼Ç¼ÖÐÓн϶àͬÑù¼Ç¼£©
½á¹û  a,b,c(Â˵ôͬÑùµÄ£©


-------------------------
"a,a,b,a,c,a,b,c,b,c,a,"Õâ¸öÊÇÒ»Ìõ¼Ç¼»¹ÊǶàÌõ¼Ç¼£¿

Èç¹ûÊÇÒ»Ìõ¼Ç¼µÄ»°£¬ÄǵÃ×Ô¼ºÐ´¸öº¯ÊýÀ´½øÐÐÅжϴ¦ÀíÁË£»
Èç¹ûÊǶàÌõ¼Ç¼µÄ»°£¬ÔòÕâÑù£º
SQL code:
select group_concat(distinct field_name) from tb_name;


һ¥µÄÎÒÊÔÊÔ
¶þÂ¥£º


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......

SQL×ֶΣ¬ºáÏòÕ¹¿ª

ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN

¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª

ÐÕÃû  ¿ÆÄ¿      ³É¼¨
ÕÅÈý  Ó¢Óï    90
ÀîËÄ  Ó¢Óï&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ