{"id":240,"date":"2018-08-18T21:13:49","date_gmt":"2018-08-18T12:13:49","guid":{"rendered":"https:\/\/www.nblog09.com\/w\/?p=240"},"modified":"2021-06-04T14:40:02","modified_gmt":"2021-06-04T05:40:02","slug":"mysql-update","status":"publish","type":"post","link":"https:\/\/www.nblog09.com\/w\/2018\/08\/18\/mysql-update\/","title":{"rendered":"Mysql\u3067\u8907\u6570\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u7d50\u5408\u3057\u3001\u6761\u4ef6\u6307\u5b9a\u3067UPDATE\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<h2 class=\"title-border\">Mysql\u3067\uff11\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3067UPDATE\u3059\u308b\u3084\u308a\u65b9<\/h2>\n<p>Mysql\u30671\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3068\u540c\u3058\u5024\u306b\u5408\u308f\u305b\u305f\u3044\u3068\u304d\u306eSQL\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p>\u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3001\u30c6\u30fc\u30d6\u30ebA\u3092\u30c6\u30fc\u30d6\u30ebB\u306e\u5024\u3067\u66f4\u65b0\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u30c6\u30fc\u30d6\u30ebA (table_a)<\/li>\n<\/ul>\n<table style=\"width: 99.8068%; border-collapse: collapse; border-color: #080707; height: 96px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 33.3333%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">ID(id)<\/td>\n<td style=\"width: 33.3333%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u540d\u524d(name)<\/td>\n<td style=\"width: 33.1884%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u8a95\u751f\u65e5(birthday)<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">1<\/td>\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">\u5c71\u7530<\/td>\n<td style=\"width: 33.1884%; border-color: #050505; height: 24px;\">1988-10-01<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">2<\/td>\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">\u4f50\u85e4<\/td>\n<td style=\"width: 33.1884%; border-color: #050505; height: 24px;\">1988-12-01<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">3<\/td>\n<td style=\"width: 33.3333%; border-color: #050505; height: 24px;\">\u7530\u4e2d<\/td>\n<td style=\"width: 33.1884%; border-color: #050505; height: 24px;\">1989-01-01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>\u30c6\u30fc\u30d6\u30ebB (table_b)<\/li>\n<\/ul>\n<table style=\"width: 99.855%; border-collapse: collapse; border-color: #080707; height: 96px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">ID(id)<\/td>\n<td style=\"width: 27.9632%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u540d\u524d(name)<\/td>\n<td style=\"width: 26.3185%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u8a95\u751f\u65e5(birthday)<\/td>\n<td style=\"width: 20.5129%; background-color: #f0f8ff; border-color: #050505;\">\u65b0ID(new_id)<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; border-color: #050505; height: 24px;\">1<\/td>\n<td style=\"width: 27.9632%; border-color: #050505; height: 24px;\">\u5c71\u7530<\/td>\n<td style=\"width: 26.3185%; border-color: #050505; height: 24px;\">1989-10-01<\/td>\n<td style=\"width: 20.5129%; border-color: #050505;\">1<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; border-color: #050505; height: 24px;\">2<\/td>\n<td style=\"width: 27.9632%; border-color: #050505; height: 24px;\">\u4f50\u85e4<\/td>\n<td style=\"width: 26.3185%; border-color: #050505; height: 24px;\">1989-12-01<\/td>\n<td style=\"width: 20.5129%; border-color: #050505;\">3<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; border-color: #050505; height: 24px;\">3<\/td>\n<td style=\"width: 27.9632%; border-color: #050505; height: 24px;\">\u7530\u4e2d<\/td>\n<td style=\"width: 26.3185%; border-color: #050505; height: 24px;\">1990-01-01<\/td>\n<td style=\"width: 20.5129%; border-color: #050505;\">4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>table_a\u306ebirthdary\u3092table_b\u306ebirthday\u3067\u66f4\u65b0\u3057\u305f\u3044\u5834\u5408\u3001\u4ee5\u4e0b\u306eSQL\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<br \/>\n(id\u3068name\u304c\u4e00\u81f4\u3059\u308b\u3082\u306e\u540c\u58eb\u3067\u7d10\u3065\u3051\u3066\u3001table_a\u306ebirthday\u3092\u66f4\u65b0\u3059\u308b)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1856 aligncenter\" src=\"https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81.png\" alt=\"\" width=\"415\" height=\"174\" srcset=\"https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81.png 637w, https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81-300x126.png 300w\" sizes=\"auto, (max-width: 415px) 100vw, 415px\" \/><\/p>\n<ul>\n<li>Example<\/li>\n<\/ul>\n<pre class=\"font-size:14 lang:default decode:true\">UPDATE\r\n    table_a a,\r\n    \u00a0table_b b\r\nSET\r\n    a.birthday = b.birthday\r\nWHERE\r\n    a.id = b.id\r\nAND a.name = b.name<\/pre>\n<div class=\"customized-adsense\"><\/div>\n<h2 class=\"title-border\">Mysql\u3067\u4ed6\u30c6\u30fc\u30d6\u30eb\u3092\u6761\u4ef6\u6307\u5b9a\u3057\u3066,\u4ed6\u65b9\u306e\u30c6\u30fc\u30d6\u30eb\u3092UPDATE\u3059\u308b\u3084\u308a\u65b9<\/h2>\n<p>\u4e0a\u306etable_a\u306b\u5bfe\u3057\u3001id=2\u306e\u4f50\u85e4\u3055\u3093\u306e\u307ftable_b\u306e\u5024\u3067\u66f4\u65b0\u3057\u305f\u3044\u5834\u5408<\/p>\n<pre class=\"\">UPDATE \r\n  \u00a0 table_a a, \r\n  \u00a0 (\r\n    SELECT \r\n      id, \r\n      name, \r\n      birthday \r\n    FROM \r\n      table_b \r\n    WHERE \r\n      id = 2\r\n  ) AS b \r\nSET \r\n  a.birthday = b.birthday \r\nWHERE \r\n  a.id = b.id \r\n  AND a.name = b.name<\/pre>\n<div class=\"customized-adsense\"><\/div>\n<h2 class=\"title-border\">Mysql\u3067\uff11\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u7d50\u5408\u3057\u305f\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3067\u66f4\u65b0\u3059\u308b\u3084\u308a\u65b9<\/h2>\n<ul>\n<li>\u30c6\u30fc\u30d6\u30ebC (table_c)<\/li>\n<\/ul>\n<table style=\"width: 99.855%; border-collapse: collapse; border-color: #080707; height: 96px;\" border=\"1\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u65b0ID(new_id)<\/td>\n<td style=\"width: 27.9632%; background-color: #f0f8ff; border-color: #050505; height: 24px;\">\u8a95\u751f\u65e5(birthday)<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; border-color: #050505; height: 24px;\">3<\/td>\n<td style=\"width: 26.3185%; border-color: #050505; height: 24px;\">1991-10-01<\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 25.0604%; border-color: #050505; height: 24px;\">4<\/td>\n<td style=\"width: 26.3185%; border-color: #050505; height: 24px;\">1992-10-01<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u6b21\u306b\u30c6\u30fc\u30d6\u30ebB\u306e\u65b0ID\u3001\u30c6\u30fc\u30d6\u30ebC\u306e\u65b0ID\u3092\u7d10\u3065\u3051\u3066\u3001\u30c6\u30fc\u30d6\u30ebC\u306ebirthday\u3067\u30c6\u30fc\u30d6\u30ebA\u306ebirtyday\u3092\u66f4\u65b0\u3059\u308bSQL\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1854 aligncenter\" src=\"https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81-1.png\" alt=\"\" width=\"530\" height=\"160\" srcset=\"https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81-1.png 910w, https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81-1-300x91.png 300w, https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/08\/IT\u30d1\u30b9\u30dd\u30fc\u30c81-1-768x232.png 768w\" sizes=\"auto, (max-width: 530px) 100vw, 530px\" \/><\/p>\n<ul>\n<li>Example\uff08Inner Join\u3067\u7d10\u3065\u3051\u308b\uff09<\/li>\n<\/ul>\n<pre class=\"\">UPDATE \r\n  table_a a, \r\n  (\r\n    SELECT \r\n      b.id, \r\n      b.name, \r\n      c.birthday \r\n    FROM \r\n      table_b b \r\n      INNER JOIN table_c c ON b.new_id = c.new_id\r\n  ) AS w_table \r\nSET \r\n  a.birthday = w_table.birthday \r\nWHERE \r\n  a.id = w_table.id \r\n  AND a.name = w_table.name<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql\u3067\uff11\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3067UPDATE\u3059\u308b\u3084\u308a\u65b9 Mysql\u30671\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3068\u540c\u3058\u5024\u306b\u5408\u308f\u305b\u305f\u3044\u3068\u304d\u306eSQL\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002 \u4f8b\u3048\u3070\u4ee5\u4e0b\u306e\u3001\u30c6\u30fc\u30d6\u30ebA\u3092\u30c6\u30fc\u30d6\u30ebB\u306e\u5024\u3067\u66f4\u65b0\u3057\u307e\u3059\u3002 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":243,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[220,219],"tags":[29],"class_list":{"0":"post-240","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"category-it-programming","9":"tag-mysql","10":"entry"},"uagb_featured_image_src":{"full":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",699,480,false],"thumbnail":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480-150x150.jpg",150,150,true],"medium":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480-300x206.jpg",300,206,true],"medium_large":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",699,480,false],"large":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",699,480,false],"1536x1536":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",699,480,false],"2048x2048":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",699,480,false],"home-middle":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",510,350,false],"home-top":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",612,420,false],"sidebar-thumbnail":["https:\/\/www.nblog09.com\/w\/wp-content\/uploads\/2018\/12\/road-220058__480.jpg",100,69,false]},"uagb_author_info":{"display_name":"9nmatsumoto","author_link":"https:\/\/www.nblog09.com\/w\/author\/9nmatsumoto\/"},"uagb_comment_info":6,"uagb_excerpt":"Mysql\u3067\uff11\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u5225\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3067UPDATE\u3059\u308b\u3084\u308a\u65b9 Mysql\u30671\u3064\u306e\u30c6\u30fc\u30d6\u30eb\u306e\u5024\u3092\u5225\u306e\u30c6\u30fc&hellip;","_links":{"self":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/comments?post=240"}],"version-history":[{"count":20,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/240\/revisions"}],"predecessor-version":[{"id":1857,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/posts\/240\/revisions\/1857"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/media\/243"}],"wp:attachment":[{"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/media?parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/categories?post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nblog09.com\/w\/wp-json\/wp\/v2\/tags?post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}