{"id":409,"date":"2005-06-09T01:00:00","date_gmt":"2005-06-08T16:00:00","guid":{"rendered":"https:\/\/ecoop.net\/memo\/2005-06-09-1.html"},"modified":"2005-06-09T01:00:00","modified_gmt":"2005-06-08T16:00:00","slug":"2005-06-09-1","status":"publish","type":"post","link":"https:\/\/www.ecoop.net\/memo\/archives\/2005-06-09-1.html","title":{"rendered":"UPDATE \u3067\u540c\u3058\u6761\u4ef6\u306e\u4efb\u610f\u6570\u306e\u30ec\u30b3\u30fc\u30c9\u3060\u3051\u66f4\u65b0\u3057\u305f\u3044"},"content":{"rendered":"<p>\n&#8211; ORDER BY \u3068 LIMIT \u3092\u4f7f\u3048\u3070\u3088\u3044\u3002UPDATE \u306b\u3082\u3042\u308b\u3068\u306f\u77e5\u3089\u306a\u304b\u3063\u305f..\u8fc2\u95ca\u3002<br \/>\n&lt;<a href=\"http:\/\/dev.mysql.com\/doc\/mysql\/ja\/update.html\">http:\/\/dev.mysql.com\/doc\/mysql\/ja\/update.html<\/a>><br \/>\n&#8211; MySQL \u30ea\u30d5\u30a1\u30ec\u30f3\u30b9\u30de\u30cb\u30e5\u30a2\u30eb :: 6.4.4 UPDATE \u69cb\u6587\n<\/p>\n<blockquote><p>&nbsp;UPDATE [LOW_PRIORITY] [IGNORE] tbl_name<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;SET col_name1=expr1 [, col_name2=expr2 &#8230;]<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;[WHERE where_definition]<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;[ORDER BY &#8230;]<br \/>\n&nbsp;&nbsp;&nbsp;&nbsp;[LIMIT row_count]\n<\/p><\/blockquote>\n<p>\u6700\u521d\u3053\u3046\u3044\u3046\u3053\u3068\u3092\u3084\u3063\u3066\u3001\u540c\u3058\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u66f4\u65b0\u3068\u53c2\u7167\u3092\u540c\u6642\u306b\u3084\u308b\u306a\u3068\u6012\u3089\u308c\u305f\u3002\n<\/p>\n<blockquote><p>UPDATE footable SET name = &#8216;foo&#8217; WHERE id = (SELECT id FROM footable <br \/>\n&nbsp;&nbsp;WHERE gender = 1)\n<\/p><\/blockquote>\n<p>\n","protected":false},"excerpt":{"rendered":"<p>&#8211; ORDER BY \u3068 LIMIT \u3092\u4f7f\u3048\u3070\u3088\u3044\u3002UPDATE \u306b\u3082\u3042\u308b\u3068\u306f\u77e5\u3089\u306a\u304b\u3063\u305f..\u8fc2\u95ca\u3002 &lt;http:\/\/dev.mysql.com\/doc\/mysql\/ja\/update.html> &#038;# &hellip; <a href=\"https:\/\/www.ecoop.net\/memo\/archives\/2005-06-09-1.html\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">UPDATE \u3067\u540c\u3058\u6761\u4ef6\u306e\u4efb\u610f\u6570\u306e\u30ec\u30b3\u30fc\u30c9\u3060\u3051\u66f4\u65b0\u3057\u305f\u3044<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[26],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","tag-mysql"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/comments?post=409"}],"version-history":[{"count":0,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/posts\/409\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/media?parent=409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/categories?post=409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ecoop.net\/memo\/wp-json\/wp\/v2\/tags?post=409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}