°Ê²¼¤Î¤è¤¦¤Ê¥Æ¡¼¥Ö¥ë¤¬¤¢¤ë¤È¥¹¥ë¡£
¢SELECT * from `test` ;
DISTINCT¤Ï½ÅÊ£½ü³°¤Ê¤Î¤Ç¡¢2¤Ä¤¢¤ëaaa¤Ï1¤Ä¤·¤«É½¼¨¤µ¤ì¤Ê¤¤¡£
¢SELECT DISTINCT `vid` from `test` ;
¥³¥Î»þ¡¢id¤äconts¤Ïɽ¼¨¤µ¤ì¤Ê¤¤(¤·¤è¤¦¤¬¥Ê¤ð)¡£
½ÅÊ£½ü³°¥Ä¥Ã¥¿¥Ã¥Æ¡¢¥É¥ì¤¬½ü³°¤µ¤ì¡¢¥É¥ì¤¬»Ä¤Ã¤¿¥ó¤«¤Ïʬ¤«¤é¤ó/¼ãÍ𤫤é¥Ì¥§¡£
¤µ¤Æ¡¢IN¤ÏÊ£¿ô»ØÄê²Äǽ¤Ê¤Î¤Ç¡¢vid¤¬aaa¤«bbb¤Î¥â¥Î¤¬Áª¤Ð¤ì¤ë¡£
¢SELECT * from `test` WHERE `vid` IN ('aaa','bbb') ;
¥Ê¥Ì¥©¤Ç¡¢IN¤ËSELECT DISTINCT¤ò»È¤¤(¥µ¥Ö¥¯¥¨¥ê)¡¢SELECT *¤ÇÁ´¹àÌÜɽ¼¨¤¬²Äǽ¤À¤È»×¤ï¤ì¤ë¤¬¡¢
¢SELECT * from `test` WHERE `vid` IN (SELECT DISTINCT `vid` from `test`) ;
½ÅÊ£½ü³°¤·¤Æ¤¤¤ë¥Ï¥Å¤Îid=5¤¬É½¼¨¤µ¤ì¤ë¡¢¥³¥Î°ÕÌ£ÉÔÌÀº¾¤Ç¤¢¤ë£÷£÷£÷£÷£÷
¥Æ¥£¥Ì¥¡¥ß¤Ë¡¢
SELECT * from `test` WHERE `vid` IN (SELECT `vid` from `test`) ;
¤È¥·¤Æ¤â¡¢·ë²Ì¤ÏƱ¤¸¤Ç¥¢¥ë...
DISTINCT¤¬Ìµ»ë¤µ¤ì¤ë¡¢±£Êòþãâµõµ¶ÙÔ¤µ¶Áõ¡ª¡ª¡ª
DISTINCT¤Ï½ÅÊ£½ü³°¤Ç¤¢¤ë¤¬¡¢GROUP by(¥°¥ë¡¼¥×²½)¤Ç¤â½ñ¤±¤ë¡£
°Ê²¼¤Î2¤Ä¤ÏƱ¤¸·ë²Ì¤òÊÖ¤¹¡£
¡SELECT DISTINCT `vid` from `test` ;
¢SELECT `vid` from `test` GROUP by `vid` ;
¡¤Ï¾å½Ò¤Î¤è¤¦¤Ëid¤äconts¤Ïɽ¼¨¤µ¤ì¥Å(¤Ç¤¤Ê¤¤)¡¢¢¤Ï¥°¥ë¡¼¥×²½¤·¤Æ¤¤¤ë¥³¥È¤«¤é¤âʬ¤«¤ë¤è¤¦¤Ëɽ¼¨¤Ç¤¤Ê¤¤¡£
´ØÏ¢¡§DISTINCT¤ÎµÕ(½ÅÊ£¤òÃê½Ð¤¹¤ëSQLʸ)
´ØÏ¢¡§[MySQL] ¥é¥ó¥¥ó¥°¤Ê¤É¤Ç½ç°Ì¤ò¼èÆÀ¤¹¤ëÊýË¡ [¼«¸Ê·ë¹ç]
´ØÏ¢¡§[MySQL] id¤òµÍ¤á¤ë(Ï¢ÈÖ¤ò¿¶¤êľ¤¹)ÊýË¡
´ØÏ¢¡§163data.com.cn¤ÎµñÈÝIP¥ê¥¹¥È¤ò¼«Æ°À¸À®(deny)
´ØÏ¢¡§Mac¤Ç¥µ¡¼¥Ð¡¼(Apache,PHP,MySQL,WordPress)¤òºî¤ë
´ØÏ¢¡§[Mac] PHP¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ëÌäÂê [HighSierra]
´ØÏ¢¡§Ubuntu 18.04.2 LTS¤Î32¥Ó¥Ã¥ÈÈÇ
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó
¢SELECT * from `test` ;
DISTINCT¤Ï½ÅÊ£½ü³°¤Ê¤Î¤Ç¡¢2¤Ä¤¢¤ëaaa¤Ï1¤Ä¤·¤«É½¼¨¤µ¤ì¤Ê¤¤¡£
¢SELECT DISTINCT `vid` from `test` ;
¥³¥Î»þ¡¢id¤äconts¤Ïɽ¼¨¤µ¤ì¤Ê¤¤(¤·¤è¤¦¤¬¥Ê¤ð)¡£
½ÅÊ£½ü³°¥Ä¥Ã¥¿¥Ã¥Æ¡¢¥É¥ì¤¬½ü³°¤µ¤ì¡¢¥É¥ì¤¬»Ä¤Ã¤¿¥ó¤«¤Ïʬ¤«¤é¤ó/¼ãÍ𤫤é¥Ì¥§¡£
¤µ¤Æ¡¢IN¤ÏÊ£¿ô»ØÄê²Äǽ¤Ê¤Î¤Ç¡¢vid¤¬aaa¤«bbb¤Î¥â¥Î¤¬Áª¤Ð¤ì¤ë¡£
¢SELECT * from `test` WHERE `vid` IN ('aaa','bbb') ;
¥Ê¥Ì¥©¤Ç¡¢IN¤ËSELECT DISTINCT¤ò»È¤¤(¥µ¥Ö¥¯¥¨¥ê)¡¢SELECT *¤ÇÁ´¹àÌÜɽ¼¨¤¬²Äǽ¤À¤È»×¤ï¤ì¤ë¤¬¡¢
¢SELECT * from `test` WHERE `vid` IN (SELECT DISTINCT `vid` from `test`) ;
½ÅÊ£½ü³°¤·¤Æ¤¤¤ë¥Ï¥Å¤Îid=5¤¬É½¼¨¤µ¤ì¤ë¡¢¥³¥Î°ÕÌ£ÉÔÌÀº¾¤Ç¤¢¤ë£÷£÷£÷£÷£÷
¥Æ¥£¥Ì¥¡¥ß¤Ë¡¢
SELECT * from `test` WHERE `vid` IN (SELECT `vid` from `test`) ;
¤È¥·¤Æ¤â¡¢·ë²Ì¤ÏƱ¤¸¤Ç¥¢¥ë...
DISTINCT¤¬Ìµ»ë¤µ¤ì¤ë¡¢±£Êòþãâµõµ¶ÙÔ¤µ¶Áõ¡ª¡ª¡ª
DISTINCT¤Ï½ÅÊ£½ü³°¤Ç¤¢¤ë¤¬¡¢GROUP by(¥°¥ë¡¼¥×²½)¤Ç¤â½ñ¤±¤ë¡£
°Ê²¼¤Î2¤Ä¤ÏƱ¤¸·ë²Ì¤òÊÖ¤¹¡£
¡SELECT DISTINCT `vid` from `test` ;
¢SELECT `vid` from `test` GROUP by `vid` ;
¡¤Ï¾å½Ò¤Î¤è¤¦¤Ëid¤äconts¤Ïɽ¼¨¤µ¤ì¥Å(¤Ç¤¤Ê¤¤)¡¢¢¤Ï¥°¥ë¡¼¥×²½¤·¤Æ¤¤¤ë¥³¥È¤«¤é¤âʬ¤«¤ë¤è¤¦¤Ëɽ¼¨¤Ç¤¤Ê¤¤¡£
´ØÏ¢¡§DISTINCT¤ÎµÕ(½ÅÊ£¤òÃê½Ð¤¹¤ëSQLʸ)
´ØÏ¢¡§[MySQL] ¥é¥ó¥¥ó¥°¤Ê¤É¤Ç½ç°Ì¤ò¼èÆÀ¤¹¤ëÊýË¡ [¼«¸Ê·ë¹ç]
´ØÏ¢¡§[MySQL] id¤òµÍ¤á¤ë(Ï¢ÈÖ¤ò¿¶¤êľ¤¹)ÊýË¡
´ØÏ¢¡§163data.com.cn¤ÎµñÈÝIP¥ê¥¹¥È¤ò¼«Æ°À¸À®(deny)
´ØÏ¢¡§Mac¤Ç¥µ¡¼¥Ð¡¼(Apache,PHP,MySQL,WordPress)¤òºî¤ë
´ØÏ¢¡§[Mac] PHP¤Î¥Ð¡¼¥¸¥ç¥ó¤¬°Û¤Ê¤ëÌäÂê [HighSierra]
´ØÏ¢¡§Ubuntu 18.04.2 LTS¤Î32¥Ó¥Ã¥ÈÈÇ
SQL Âè2ÈÇ ¥¼¥í¤«¤é¤Ï¤¸¤á¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹Áàºî
posted with amazlet at 19.08.05
æÆ±Ë¼Ò (2016-07-11)
Çä¤ê¾å¤²¥é¥ó¥¥ó¥°: 5,007
Çä¤ê¾å¤²¥é¥ó¥¥ó¥°: 5,007
SQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó
posted with amazlet at 19.08.05
Bill Karwin
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥¥ó¥°: 7,819
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥¥ó¥°: 7,819