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