
å¶æ¥ã»ããŒã±ã¿ãŒãAIã«æžãããSQLãèªåã§èªãã§ç¢ºãããããã®åºç€
AIã§ç°¡åã«æžããããã«ãªã£ããã確ããããããšã¯éããªã
以åã®èšäºã§ãAIã«SQLãæžãããããšãšäŸé Œããããšã®éãã«ã€ããŠæžãããçµè«ã¯ãåºæ¬çã«ã¯äŸé Œãããã ãAIãçæããSQLã®çµæãèªåã§æ€èšŒã§ããªããªããæåããå°éå®¶ã«æž¡ããæ¹ãããã
ãã ãèªåã§ãããããåŸãªãå Žé¢ã¯ãããäŒç€Ÿã®äºæ ãã¿ã€ãã³ã°ã人çãªãœãŒã¹ãããããç¶æ³ã®ããã®èšäºã ã
ãæžããããèªãããã確ããããããã¯å¥ã®èœåã ãAIã®ãããã§SQLãçæããããšã¯èª°ã§ãã§ããããã«ãªã£ããã ãçæã§ããããšãšãåºãŠããSQLãäœãããŠããããèªããããšã¯éããèªããããšãšãçµæãæå³éããã確ãããããããšãéãã
ãã®èšäºã¯ãSQLæªçµéšã§AIã䜿ã£ãŠåããŠSQLãæžã人ã«åããŠããèªãããã確ããããããã®åºæ¬çãªããšãäžéãæ±ãã
SQLã¯SELECTããèªãŸãªã
AIãæžãSQLã¯ãããŠã`SELECT`ããå§ãŸããã ããSQLãèªããšãã¯`SELECT`ããå§ãããšèŠèª€ããããããŸãèŠãã¹ããªã®ã¯ãã©ã®ããŒãã«ã䜿ããã©ã®æ¡ä»¶ã§çµããã©ã®åäœã§ãŸãšããŠãããã ãæ¬¡ã®é çªã§èªããšããã
FROM / JOINïŒã©ã®ããŒãã«ã䜿ãããäœãšã€ãªãããæ±ºãã
WHEREïŒæ¡ä»¶ã§çµã
GROUP BYïŒãŸãšãã
SELECTïŒçµæãšããŠåºãåãæ±ºãã
æžããé ãšèªãé ãéããäžããèªãã§ãããšããŸããäœãåºãŠãããããæžããŠããã®ã«ãå®éã«ç¢ºèªãã¹ããªã®ã¯ãã©ã®éåãäœã£ãŠããããã ã
SQLãèªããšãã¯`FROM`ããå§ããããã©ã®éåãã§ããŠãã©ãçµãããŠãã©ããŸãšãŸã£ãŠãæåŸã«äœãåºãŠããããã远ãã®ãèªã¿æ¹ã®åºæ¬ã ã
AIã«SQLãæžãããããSQLæ¬äœã ãã§ãªãããã©ã®ããŒãã«ã䜿ããã©ãã§çµããäœã®åäœã§ãŸãšããŠããããã説æããããšããã
FROMã»JOIN â ã©ã®éåãäœã£ãŠããã
ãŸã`FROM`ã«æžãããŠããããŒãã«ã確èªãããäœãèµ·ç¹ã«ãªã£ãŠãããã
次ã«`JOIN`ãèŠããã©ã®ããŒãã«ãã€ãªãã§ãããã`ON`ã®æ¡ä»¶ã¯äœãã
泚æããã®ã¯è¡æ°ã ã1察å€ã®é¢ä¿ã§JOINãããšè¡ãå¢ãããæ³šæããŒãã«ãšæ³šææçްããŒãã«ãJOINããã°ã泚æ1ä»¶ã«å¯ŸããŠæçŽ°ã®æ°ã ãè¡ãã§ããããã®æç¹ã§è¡ãèšããã§ãããšãåŸç¶ã®`SUM`ã`COUNT`ãæå³ããªãæ°åã«ãªããJOINã®çš®é¡ã«ã€ããŠã¯åŸè¿°ããã
WHERE â ã©ãã§çµã£ãŠããã
`WHERE`ã¯æ¡ä»¶ã§è¡ãçµããããã¯èœãšã穎ãå€ãã
LIKE
`LIKE '%ã»ãã%'`ã¯ãã»ããããšããæååãå«ããã®ããã¹ãŠæŸãããæé£ã»ãããããã»ããå²åŒãããããã±ãŒãžã»ãããã察象ã«ãªãã`%`ã®äœçœ®ã§äžèŽã®ç¯å²ãå€ãããããæå³ããªããã®ãæŸã£ãŠããªããã確èªããã
NULLãšç©ºæå
NULLã¯ãå€ãå ¥ã£ãŠããªããç¶æ ã ã空æåãšã¯éãã
NULLãæ¡ä»¶ã«ãããšãã¯`= NULL`ã§ã¯ãªãã`IS NULL`ãŸãã¯`IS NOT NULL`ã䜿ãã空æåãæ¡ä»¶ã«ãããšãã¯`= ''`ã䜿ãã
èŠãç®ã空ã«èŠããŠããNULLãªã®ã空æåãªã®ãã§æ¡ä»¶ã®æžãæ¹ãå€ããã
æ¥ä»ã»ç¯å²
`BETWEEN`ã¯äž¡ç«¯ãå«ãã`>=`ãš`>`ã`<=`ãš`<`ã®äœ¿ãåãã確èªããã
æ¥ä»ã ãã®åãšãæå»ãŸã§å«ãæ¥æã®åã§ã¯æ³šæç¹ãéããæ¥ä»ã ãã®åãªãã`2026-06-30`ã¯6æ30æ¥ãã®ãã®ã衚ããã ãæ¥æã§ã¯ãåã6æ30æ¥ã§ã`2026-06-30 12:00:00`ã`2026-06-30 23:59:59`ãããã
æ¥æã®åã«å¯ŸããŠ6æåãåããªããã6æ1æ¥ä»¥äžã7æ1æ¥æªæºãã®ããã«èããæ¹ãå®å šã ã
AND / OR
`AND`ãš`OR`ãæ··ãããšãæå³ãšéãæ¡ä»¶ã«ãªãããšãããã`A AND B OR C`ãš`A AND (B OR C)`ã¯åãã§ã¯ãªããæ¡ä»¶ãè€æ°ãããšãã¯ãæ¬åŒ§ãä»ããŠããããèŠãã
`WHERE`ã¯ãäœãæ®ãããã§ã¯ãªããäœãèœã¡ãããã®èŠç¹ã§èªããšãããçµãããããšå¿ èŠãªããŒã¿ãæ¶ããçµãè¶³ããªããšäžèŠãªããŒã¿ãæ®ãã
GROUP BY â äœã®åäœã§ãŸãšããŠããã
`GROUP BY`ã¯è¡ããŸãšãããããã§ã1è¡ãäœã衚ããŠãããããæ±ºãŸãã
æ¥å¥ãªã®ãæå¥ãªã®ãããŠãŒã¶ãŒåäœãªã®ã泚æåäœãªã®ãã§ãæ°åã¯ãŸã£ããå€ãããã売äžãåºããŠããšã ãAIã«æž¡ããšãAIã¯äœãããã®ç²åºŠã§ãŸãšããããããæ¬²ããã£ãç²åºŠãã©ããã確èªããã
`GROUP BY`ã«æžãããŠããããŒãèŠãŠããã®åäœã§ãŸãšãããã®ã1è¡ã«ãªã£ãŠããããšèªãã
SELECT â çµå±äœãåºããŠããã
`SELECT`ã§åºãåãšéèšé¢æ°ã確èªããã
`COUNT(*)`ã¯NULLãå«ããŠå šè¡ãæ°ããã`COUNT(åå)`ã¯ãã®åãNULLã§ãªãè¡ã ããæ°ãããã©ã¡ãã䜿ã£ãŠãããã§ä»¶æ°ãå€ããã
`SUM`ã¯NULLãç¡èŠãããNULLã¯0ãšããŠè¶³ãããããã§ã¯ãªããéé¡ãæ°éã«NULLãããå Žåã¯ããã®æ±ããæå³éããã確èªããã
`DISTINCT`ã¯éè€ãé€ããçµæããããããšãã«`DISTINCT`ã远å ããŠãçŽã£ãããšããã®ã¯ãåå ãé èœããŠããå¯èœæ§ãããããªãéè€ãçºçããŠãããã確èªããã®ãå ã ã
JOINã®çš®é¡ãšä»¶æ°ã®å€å
JOINã®çš®é¡ã«ãã£ãŠãçµæã®ä»¶æ°ãå€ããã
INNER JOINïŒäž¡ããŒãã«ã«ååšããè¡ã ããæ®ããã©ã¡ããã«ãããªãè¡ã¯æ¶ããã
LEFT JOINïŒå·ŠããŒãã«ïŒ`FROM`ã«æžããããŒãã«ïŒã¯å šè¡æ®ããå³ããŒãã«ã«å¯Ÿå¿ããªãå Žåã¯ãå³ããŒãã«ã®åãNULLã«ãªãã
RIGHT JOINïŒLEFT JOINã®éãå³ããŒãã«ãåºæºã«ããŠãå·ŠããŒãã«ã«å¯Ÿå¿ããªãå Žåã¯å·ŠåŽã®åãNULLã«ãªããæ £ããªããã¡ã¯LEFT JOINã«èªã¿æ¿ããæ¹ãããããããã
FULL OUTER JOINïŒäž¡ããŒãã«ã®å šè¡ãæ®ãã察å¿ããªãåŽã¯NULLã«ãªãã
CROSS JOINïŒå šçµã¿åãããäœããå·ŠããŒãã«ã100è¡ãå³ããŒãã«ã100è¡ãªãçµæã¯1äžè¡ã«ãªããæå³ãã䜿ãããŠãããšä»¶æ°ãççºããã
1察å€ã®é¢ä¿ã§JOINãéãããšãè¡æ°ãæãç®ã§å¢ããã`FROM`ãã`JOIN`ã远ããªãããã€ãªãã åŸã®è¡æ°ãæå³éããã確ãããããšã倧åã ã
èªãã åŸã®ç¢ºããæ¹
SQLãèªãã åŸãçµæã確ãããã
ãŸãç¹å®ã®IDãæ°ä»¶éžãã§ãSQLã®çµæãšæã§è¿œã£ãå 容ãäžèŽããŠãããã確èªãããæ³šæIDã»ãŠãŒã¶ãŒIDã»ååIDãªã©ãåå¥ã«è¿œããåäœã§èŠãã
次ã«ä»¶æ°ã確èªãããçµæã®è¡æ°ãå€ãããã»å°ãªããããšãã¯ããŸãJOINãš`WHERE`ãçããã€ãªãæ¹ã§å¢ããçµãæ¹ã§æžãããã ãJOINã®ååŸã§ä»¶æ°ãæ¯ã¹ããšãã©ãã§èšããã§ããããèŠããããã
éèšã®å Žåã¯åå¥ç¢ºèªãé£ãããæ£è§£ããŒã¿ãå¥éåããå Žåã¯ãããšæ¯èŒãããåãæ¡ä»¶ã§éèšããŠãããªããæå¥éèšã¯æ¥å¥ã®åèšãšäžèŽããã¯ãã ã幎éåèšããæå¥ã®åèšã®åãšäžèŽããã¯ãã ãå¥ã®ç²åºŠã»å¥ã®åãå£ããåãæ°åã«èŸ¿ãçãããã確ãããã
ãããŸã§ãåºç€ããã以äžã¯åœ¹å²ã決ãã話ã
å®å šãªæ€èšŒã¯é£ãããã©ããã§ãã§ããç¯å²ã§ãã£ãããšå€æããå¿ èŠãããã
ãã以äžã®ããšãããžãã¹ãµã€ããèªåã§ããããšã¯ãå§ãããªããSQLãæ¬æ Œçã«äœ¿ããããªããåŠãã§ä»äºãšããŠæã€ããå°éå®¶ã«ä»»ãããããããŸã§ãããªããšæ±ºããããéžã¶æ¹ãããã
AIãSQLãæžãããšã§ãæžãå§ããå£ã¯äžãã£ããããããçµæã確ãããå£ã¯æ®ã£ãŠããããããé£ã°ããšããSQLã¯åããããæ°åã¯ééã£ãŠããããšããç¶æ ã«ãªãã
ãAIã§æžããããèªåã§ãããã¯ãæäœéãã®èšäºã§æžãã芳ç¹ãã確èªã§ããããšãåæã«ãªãã