{"id":76,"date":"2009-09-03T10:20:02","date_gmt":"2009-09-03T01:20:02","guid":{"rendered":"http:\/\/www.cosmetic-info.jp\/wordpress\/?p=76"},"modified":"2009-09-22T10:26:49","modified_gmt":"2009-09-22T01:26:49","slug":"76","status":"publish","type":"post","link":"https:\/\/blog.cfms.jp\/?p=76","title":{"rendered":"\u30ea\u30f3\u30af\u5207\u308c\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u63a2\u3059SQL"},"content":{"rendered":"<p>\u4ed6\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u306eID\u306a\u3069\u3092\u4fdd\u6301\u3057\u3066\u95a2\u9023\u3065\u3051\u3057\u3066\u3044\u308b\u3068\u304d\u306b\u3001\u3044\u3064\u306e\u9593\u306b\u304b\u30ea\u30f3\u30af\u5148\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u3066\u30ea\u30f3\u30af\u5207\u308c\u3092\u8d77\u3053\u3057\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308b\u3002<\/p>\n<p>\u305d\u3053\u3067\u30ea\u30f3\u30af\u304c\u5207\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u63a2\u3059SQL<\/p>\n<p>aTable<br \/>\n\u3000\u251c id<br \/>\n\u3000\u2514 b_id\uff08bTable\u306e\u30ea\u30f3\u30af\u5148id<br \/>\nbTable<br \/>\n\u3000\u2514 id<br \/>\n\u3068\u3044\u3046\u69cb\u6210\u306e\u3068\u304d\u306b\u3001aTable\u306e\u4e2d\u304b\u3089\u30ea\u30f3\u30af\u5148\u306ebTable\u306b\u5bfe\u8c61\u3068\u306a\u308bid\u306e\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3057\u306a\u3044\u3082\u306e\u3092\u62bd\u51fa\u3059\u308b\u3002<br \/>\n<code>SELECT aTable.id<br \/>\nFROM aTable<br \/>\nLEFT JOIN bTable ON aTable.b_id = bTable.id<br \/>\nWHERE bTable.id IS NULL <\/code><\/p>\n<p>aTable\u3068bTable\u3092Left Join\u3067\u7d50\u5408\u3057\u305f\u3068\u304d\u306b\u76f8\u624b\u65b9\u306eid\u304cNULL\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u3082\u306e\u3092\u62bd\u51fa\u3059\u308c\u3070\u3044\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ed6\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u306eID\u306a\u3069\u3092\u4fdd\u6301\u3057\u3066\u95a2\u9023\u3065\u3051\u3057\u3066\u3044\u308b\u3068\u304d\u306b\u3001\u3044\u3064\u306e\u9593\u306b\u304b\u30ea\u30f3\u30af\u5148\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u524a\u9664\u3057\u3066\u30ea\u30f3\u30af\u5207\u308c\u3092\u8d77\u3053\u3057\u3066\u3057\u307e\u3046\u3053\u3068\u304c\u3042\u308b\u3002 \u305d\u3053\u3067\u30ea\u30f3\u30af\u304c\u5207\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3092\u63a2\u3059SQL aTable \u3000\u251c id  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[],"class_list":["post-76","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76"}],"version-history":[{"count":0,"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=\/wp\/v2\/posts\/76\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.cfms.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}