°Ê²¼¤Î¤è¤¦¤Ê¥Æ¡¼¥Ö¥ë¤¬¤¢¤ë¤È¥¹¥ë¡£

¢­SELECT * from `test` ;
MySQL¤ÎIN_001

DISTINCT¤Ï½ÅÊ£½ü³°¤Ê¤Î¤Ç¡¢2¤Ä¤¢¤ëaaa¤Ï1¤Ä¤·¤«É½¼¨¤µ¤ì¤Ê¤¤¡£

¢­SELECT DISTINCT `vid` from `test` ;
MySQL¤ÎIN_002

¥³¥Î»þ¡¢id¤äconts¤Ïɽ¼¨¤µ¤ì¤Ê¤¤(¤·¤è¤¦¤¬¥Ê¤ð)¡£

½ÅÊ£½ü³°¥Ä¥Ã¥¿¥Ã¥Æ¡¢¥É¥ì¤¬½ü³°¤µ¤ì¡¢¥É¥ì¤¬»Ä¤Ã¤¿¥ó¤«¤Ïʬ¤«¤é¤ó/¼ãÍ𤫤é¥Ì¥§¡£

¤µ¤Æ¡¢IN¤ÏÊ£¿ô»ØÄê²Äǽ¤Ê¤Î¤Ç¡¢vid¤¬aaa¤«bbb¤Î¥â¥Î¤¬Áª¤Ð¤ì¤ë¡£

¢­SELECT * from `test` WHERE `vid` IN ('aaa','bbb') ;
MySQL¤ÎIN_003

¥Ê¥Ì¥©¤Ç¡¢IN¤ËSELECT DISTINCT¤ò»È¤¤(¥µ¥Ö¥¯¥¨¥ê)¡¢SELECT *¤ÇÁ´¹àÌÜɽ¼¨¤¬²Äǽ¤À¤È»×¤ï¤ì¤ë¤¬¡¢

¢­SELECT * from `test` WHERE `vid` IN (SELECT DISTINCT `vid` from `test`) ;
MySQL¤ÎIN_004

½ÅÊ£½ü³°¤·¤Æ¤¤¤ë¥Ï¥Å¤Î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ÈÇ ¥¼¥í¤«¤é¤Ï¤¸¤á¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹Áàºî
æÆ±Ë¼Ò (2016-07-11)
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 5,007

SQL¥¢¥ó¥Á¥Ñ¥¿¡¼¥ó
Bill Karwin
¥ª¥é¥¤¥ê¡¼¥¸¥ã¥Ñ¥ó
Çä¤ê¾å¤²¥é¥ó¥­¥ó¥°: 7,819


[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó