DB/SQL/¼Í±Æ¤ÈÁªÂò
Îó¤ÎÁªÂò†
»ØÄꤷ¤¿É½¤«¤é¡¢»ØÄꤷ¤¿Îó¤òÃê½Ð¤¹¤ë¡Ê¼Í±Æ¡Ë¡£
- ÊýË¡
-- piyo ɽ¤ÎÁ´¤Æ¤ÎÎó¤òÁªÂò select * from piyo; -- piyo ɽ¤Î hoge Îó¤òÁªÂò select hoge from piyo; -- piyo ɽ¤Î hoge Îó¤È fuga Îó¤òÁªÂò select hoge, fuga from piyo;
¹Ô¤ÎÁªÂò†
»ØÄꤷ¤¿É½¤«¤é¡¢»ØÄꤷ¤¿¹Ô¤òÃê½Ð¤¹¤ë¡ÊÁªÂò¡Ë¡£
- ÊýË¡
-- ´ðËܤϤ³¤¦ select hoge from piyo where <¾ò·ï> -- »È¤¨¤ë±é»»»Ò¤Ï¤³¤ó¤Ê¤Î¡£³Æʸ¤Î select ¡Á from ¡Á ¤Ï¾Êά where fuga = 'hoge' -- fuga Îó¤¬Ê¸»úÎó hoge where fuga = 100 -- fuga Îó¤¬ 100 where fuga > 100 -- fuga Îó¤¬ 100 ¤è¤êÂ礤¤ where fuga >= 100 -- fuga Îó¤¬ 100 °Ê¾å where fuga < 100 -- fuga Îó¤¬ 100 ¤è¤ê¾®¤µ¤¤ where fuga <= 100 -- fuga Îó¤¬ 100 °Ê²¼ where fuga <> 100 -- fuga Îó¤¬ 100 ¤Ç¤Ï¤Ê¤¤ -- ¤³¤¦¤¤¤¦¤Î¤â»È¤¨¤ë -- ¤½¤ì¤¾¤ì not ¤òÆþ¤ì¤ì¤Ð¤½¤ì¤¾¤ì¤Î¾ò·ï¤ÎÈÝÄ꤬¤È¤ì¤ë where fuga [not] between 100 and 200 -- fuga Îó¤¬ 100 ¤«¤é 200 ¤Î´Ö where fuga [not] in ('hoge', 'fuga', 100, 200) -- fuga Îó¤¬ "hoge"¡¢"fuga"¡¢100¡¢200 ¤Î¤¤¤º¤ì¤« where fuga [not] like '_b%' -- fuga Îó¤Î 2 ʸ»úÌܤ¬ "b" where fuga [not] like '%HOGE\_%' escape '\' -- fuga Îó¤Ë "HOGE_" ¤ò´Þ¤à where fuga is [not] null -- fuga Îó¤¬ null -- ¤¢¤ó¤Þ¤ê»È¤ï¤Ê¤¤¤«¤â¤Ê¥Ñ¥¿¥ó -- ÉûÌ䤤¹ç¤ï¤»¤Î»þ¤Ë»È¤¦¤«¤â -- ¤½¤ì¤¾¤ì not ¤òÆþ¤ì¤ì¤ÐÈÝÄê¤Ë¤Ê¤ë where fuga > [not] any (100, 200, 300) -- fuga Îó¤¬ 100 ¤« 200 ¤« 300 ¤Î¤É¤ì¤«¤è¤êÂ礤¤ where fuga < [not] any (100, 200, 300) -- fuga Îó¤¬ 100 ¤« 200 ¤« 300 ¤Î¤É¤ì¤«¤è¤ê¾®¤µ¤¤ where fuga = [not] any (100, 200, 300) -- fuga Îó¤¬ 100 ¤« 200 ¤« 300 ¤Î¤É¤ì¤«¤ÈÅù¤·¤¤¡ÊIN ¤ÈƱ¤¸¡Ë where fuga > [not] all (100, 200, 300) -- fuga Îó¤¬ 100 ¤È 200 ¤È 300 ¤Î¤¹¤Ù¤Æ¤è¤êÂ礤¤ where fuga < [not] all (100, 200, 300) -- fuga Îó¤¬ 100 ¤È 200 ¤È 300 ¤Î¤¹¤Ù¤Æ¤è¤ê¾®¤µ¤¤ -- Ê£¿ô¾ò·ï»ØÄê¤Ï and ¤â¤·¤¯¤Ï or¡£Í¥Àè½ç°Ì¤Ï¥«¥Ã¥³¤Ç»ØÄê²Äǽ -- Ä̾ï¤Ï and ¤¬Í¥Àè¡£ where fuga > 100 and fuga < 200 where fuga > 100 and ( fuga < 200 or foo < 100 )
- like ¤ÎÆüìʸ»ú¤Î°ÕÌ£¤Ï¤³¤ó¤Ê¡£Æüìʸ»ú¤½¤Î¤â¤Î¤ò¸¡º÷¤·¤¿¤¤¤È¤¤Ï escape ¤¹¤ë
µ¹æ °ÕÌ£ % 0ʸ»ú°Ê¾å¤ÎǤ°Õ¤Îʸ»úÎó _ 1ʸ»ú¤ÎǤ°Õ¤Îʸ»ú
- like ¤ÎÆüìʸ»ú¤Î°ÕÌ£¤Ï¤³¤ó¤Ê¡£Æüìʸ»ú¤½¤Î¤â¤Î¤ò¸¡º÷¤·¤¿¤¤¤È¤¤Ï escape ¤¹¤ë
Îó¤ËÊÌ̾¤ò¤Ä¤±¤ë†
Ãê½Ð¤¹¤ëÎó¤ËÊÌ̾¤òÉÕ¤±¤ë¡£²èÌ̤Ëɽ¼¨¤¹¤ë̾Á°¤ò»ØÄꤹ¤ë¤Û¤«¡¢¥½¡¼¥È¤ÎÎó»ØÄê¡Ê¸å½Ò¡Ë¤Ë¤â»È¤¨¤ë¡£
- ÊýË¡
-- ¥À¥Ö¥ë¥¯¥ª¡¼¥È¤Ç°Ï¤à¤ÈÂçʸ»ú¾®Ê¸»ú¤ò¶èÊÌ¡£¤³¤Î¾ì¹ç¤Ï fuga ¤Ë¤Ê¤ë select hoge as "fuga" from piyo; -- °Ï¤Þ¤Ê¤±¤ì¤ÐÂçʸ»ú¡£FUGA select hoge as fuga from piyo; -- as ¤Ï¾Êά¤â²Äǽ select hoge "fuga" from piyo; select hoge fuga from piyo;
Îó¤òÏ¢·ë¤¹¤ë†
½ÐÎϤ¹¤ëÎó¤ò¹¥¤¤ËÏ¢·ë¤·¤ÆÀ°·Á¤¹¤ë¡£
- ÊýË¡
-- ¤¿¤Àñ¤Ë¤¯¤Ã¤Ä¤±¤Æ½ÐÎϤ¹¤ë select hoge || fuga from piyo; -- ´Ö¤Ë²¿¤«Ê¸»úÎó¤òÆþ¤ì¤ë¤È¤¤Ï¥·¥ó¥°¥ë¥¯¥ª¡¼¥È select hoge || ' is a ' || fuga from piyo;
¹Ô¤Î½ÅÊ£¤ò¾Ê¤¯†
Ʊ¤¸¹Ô¤¬¤¤¤Ã¤Ñ¤¤¤¢¤Ã¤¿¤é°ì¹Ô¤Ë¤Þ¤È¤á¤ë¡£
- ÊýË¡
-- ´ðËܤϤ³¤¦ select distinct hoge from piyo; -- ¤³¤¦¤¹¤ë¤È hoge ¤È fuga ¤ÎÁȤǽÅÊ£¤ò¾Ê¤¯¡£¤¢¤ëÎó¤Ç¤À¤±¤Î½ÅÊ£ÇÓ½ü¤ÏÉÔ²Ä select distinct hoge, fuga from piyo;
¹Ô¤ò¥½¡¼¥È¤¹¤ë†
½ÐÎϤ¹¤ë¹Ô¤ò½ç½ø¤è¤¯Ê¤٤롣
- ÊýË¡
-- ´ðËܤϤ³¤¦¡£hoge Îó¤Ç¥½¡¼¥È¡Ê¾º½ç¡Ë select hoge, fuga from piyo order by hoge; -- ¾º½ç¤Ë¥½¡¼¥È¡Ê¥Ç¥Õ¥©¥ë¥È¡Ë order by hoge asc -- ¹ß½ç¤Ë¥½¡¼¥È order by hoge desc -- Ê£¿ôÎó¤ò»ØÄꤷ¤Æ¥½¡¼¥È¡£¤³¤ÎÎã¤Ç¤Ï fuga ½ç¤Ë¥½¡¼¥È¤µ¤ì¤¿¾õÂÖ¤Ç hoge ½ç¤ËÊÂ¤Ö order by hoge, fuga -- ¥½¡¼¥È¾ò·ï¤Ë¤ÏÎóÊÌ̾¤ò»ÈÍѲÄǽ select hoge as fuga from piyo order by fuga;
Last-modified: 2011-10-17 (·î) 20:04:52