{"description":"\u5c0f\u30cd\u30bf\u3002 \u7279\u5b9a\u306e\u6761\u4ef6\u306b\u4e00\u81f4\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b\u306e\u306fINNER JOIN\u7b49\u3092\u4f7f\u3046\u65b9\u6cd5\u306f\u77e5\u3063\u3066\u307e\u3057\u305f\u304c\u3001\u4e00\u81f4\u3057\u306a\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b\u65b9\u6cd5\u3092\u77e5\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3057\u307e\u3059\u3002 \u74b0\u5883 MySQL 8 \u5b9f\u88c5 NOT EXISTS\u3092\u4f7f\u3048\u3070\u6761\u4ef6\u4e00\u81f4\u3057\u306a\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u7279\u5b9a\u3067\u304d\u307e\u3059\u3002\u9006\u306b\u6761\u4ef6\u4e00\u81f4\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u3092\u8abf\u3079\u308b\u3068\u304d\u306fEXISTS\u3092\u4f7f\u3048\u3070\u7279\u5b9a\u3067\u304d\u307e\u3059\u3002 SELECT * FROM users WHERE NOT EXISTS(SELECT 1 FROM user_profiles WHERE users.id = user_profiles.id) \u691c\u8a3c\u65b9\u6cd5 USERS\u30c6\u30fc\u30d6\u30eb\u3068USER_PROFILES\u30c6\u30fc\u30d6\u30eb\u3092\u2026","author_url":"https://blog.hatena.ne.jp/nainaistar/","blog_title":"\u304d\u308a\u4e38\u306e\u6280\u8853\u65e5\u8a18","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/n/nainaistar/20231210/20231210112716.png","version":"1.0","type":"rich","title":"SQL\u3067\u6761\u4ef6\u304c\u4e00\u81f4\u3057\u306a\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u7279\u5b9a\u3059\u308b\uff08NOT EXISTS\uff09","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnainaistar.hatenablog.com%2Fentry%2Fuse-not-exists-in-sql\" title=\"SQL\u3067\u6761\u4ef6\u304c\u4e00\u81f4\u3057\u306a\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u7279\u5b9a\u3059\u308b\uff08NOT EXISTS\uff09 - \u304d\u308a\u4e38\u306e\u6280\u8853\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["SQL","\u6280\u8853","\u5c0f\u30cd\u30bf"],"published":"2023-12-11 12:00:00","height":"190","url":"https://nainaistar.hatenablog.com/entry/use-not-exists-in-sql","width":"100%","author_name":"nainaistar","blog_url":"https://nainaistar.hatenablog.com/"}