{"blog_title":"Fight the Future","published":"2009-04-30 06:57:18","url":"https://www.sakatakoichi.com/entry/20090429/1241071038","author_name":"jyukutyo","width":"100%","type":"rich","provider_url":"https://hatena.blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.sakatakoichi.com%2Fentry%2F20090429%2F1241071038\" title=\"update\u6587\u306bfrom\u53e5\uff01\uff1f - Fight the Future\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/jyukutyo/","provider_name":"Hatena Blog","categories":["database"],"title":"update\u6587\u306bfrom\u53e5\uff01\uff1f","height":"190","image_url":null,"version":"1.0","description":"\u3053\u3093\u306a\u611f\u3058\u306eSQL\u6587\u304c\u3042\u3063\u305f\u3002 UPDATE table_a SET column_a = 1 FROM ( SELECT column_b, column_c, column_d FROM table_b ) table_b WHERE column_a = 2 AND table_b.column_b = table_a.column_b AND table_b.column_c = table_a.column_c AND table_b.column_d = table_a.column_d \u306a\u3093\u3058\u3083\u3053\u308a\u3083\uff01\uff1f\u3063\u3068\u601d\u3063\u305f\u3051\u3069\u3001PostgreSQL\u306e\u975e\u6a19\u6e96\u62e1\u5f35\u3089\u3057\u3044\u3002 UPDATE ta\u2026","blog_url":"https://www.sakatakoichi.com/"}