{"blog_url":"https://www.sakatakoichi.com/","type":"rich","height":"190","author_url":"https://blog.hatena.ne.jp/jyukutyo/","title":"update\u6587\u306bfrom\u53e5\uff01\uff1f","width":"100%","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","published":"2009-04-30 06:57:18","provider_name":"Hatena Blog","author_name":"jyukutyo","version":"1.0","categories":["database"],"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>","blog_title":"Fight the Future","image_url":null,"url":"https://www.sakatakoichi.com/entry/20090429/1241071038","provider_url":"https://hatena.blog"}