{"id":318,"date":"2013-01-18T14:28:42","date_gmt":"2013-01-18T05:28:42","guid":{"rendered":"https:\/\/potal.poweredge.co.jp\/blog\/?p=318"},"modified":"2013-01-18T14:28:42","modified_gmt":"2013-01-18T05:28:42","slug":"insert%ef%bc%9fupdate%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/po-tal.poweredge.co.jp\/blog\/?p=318","title":{"rendered":"insert\uff1fUpdate\uff1f"},"content":{"rendered":"<p>\u30ec\u30b3\u30fc\u30c9\u304c\u306a\u304b\u3063\u305f\u3089Insert\u3001\u3042\u3063\u305f\u3089update\u3068\u304b\u4e00\u767a\u3067\u3067\u304d\u3093\u306e\u304b\u3044\u30fb\u30fb\u30fb\u3068\u601d\u3063\u305f\u3089\u3042\u3063\u305f\u3002<\/p>\n<pre>\nINSERT INTO\n   TABLE_NAME\n   (\n      PK1,\n      PK2,\n      AAA,\n      BBB\n   )\n      VALUES\n   (\n      (key1),\n      (key2),\n      10,\n      20\n   )\n<strong>ON DUPLICATE KEY UPDATE<\/strong>\n      AAA = AAA + 10,\n      BBB = BBB + 20\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30ec\u30b3\u30fc\u30c9\u304c\u306a\u304b\u3063\u305f\u3089Insert\u3001\u3042\u3063\u305f\u3089update\u3068\u304b\u4e00\u767a\u3067\u3067\u304d\u3093\u306e\u304b\u3044\u30fb\u30fb\u30fb\u3068\u601d\u3063\u305f\u3089\u3042\u3063\u305f\u3002 INSERT INTO TABLE_NAME ( PK1, PK2, AAA, BBB ) VALUES ( (key [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[29],"_links":{"self":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/318"}],"collection":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=318"}],"version-history":[{"count":0,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/318\/revisions"}],"wp:attachment":[{"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/po-tal.poweredge.co.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}