{"id":4996,"date":"2017-11-13T12:25:32","date_gmt":"2017-11-13T03:25:32","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=4996"},"modified":"2020-05-28T14:14:29","modified_gmt":"2020-05-28T05:14:29","slug":"mysql-mariadb%ec%9d%98-insert-into-on-duplicate-key-update","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=4996","title":{"rendered":"MySQL, MariaDB\uc758 INSERT INTO &#8230; ON DUPLICATE KEY UPDATE &#8230;"},"content":{"rendered":"<p>MySQL(MariaDB)\uc5d0\uc11c \ub3d9\uc77c\ud55c Key \uac12\uc774 \uc774\ubbf8 \uc874\uc7ac\ud55c\ub2e4\uba74 UPDATE \ubb38\uc744 \ud638\ucd9c\ud558\uc5ec \uae30\uc874\uc758 Row\uc758 \uac12\uc744 \ubcc0\uacbd\ud558\uace0, \ub3d9\uc77c\ud55c Key \uac12\uc744 \uac00\uc9c4 Row\uac00 \uc5c6\ub2e4\uba74 INSERT\ub97c \ud638\ucd9c\ud558\ub294 SQL \ubb38\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">\r\nINSERT INTO \r\n    current_load_powerfactor \r\n    (ref_mRID, update_timeStamp, value) \r\nVALUES\r\n    (\"_1e1ccab5-250a-44a3-89d8-177e2d53e071\", NOW(), 99) \r\nON DUPLICATE KEY UPDATE \r\n    update_timeStamp=NOW(), value=99\r\n<\/pre>\n<p>\uc704\uc758 SQL\uc740 current_load_powerfactor\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c, Primary Key\ub85c \uc7a1\ud78c ref_mRID\uac00 \uc911\ubcf5\ub41c \uc774\ubbf8 \uc874\uc7ac\ud558\ub294 Row\uac00 \uc788\ub2e4\uba74, \uc911\ubcf5\ub41c Row\uc758 \uac12\uc744 \ubcc0\uacbd(UPDATE \ubb38 \uc2e4\ud589)\ud558\uace0, \uc911\ubcf5\ub41c Row\uac00 \uc5c6\ub2e4\uba74 \uc0c8\ub85c\uc6b4 Row\ub97c \ucd94\uac00(INSERT)\ud558\ub77c\ub294 \ub0b4\uc6a9\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL(MariaDB)\uc5d0\uc11c \ub3d9\uc77c\ud55c Key \uac12\uc774 \uc774\ubbf8 \uc874\uc7ac\ud55c\ub2e4\uba74 UPDATE \ubb38\uc744 \ud638\ucd9c\ud558\uc5ec \uae30\uc874\uc758 Row\uc758 \uac12\uc744 \ubcc0\uacbd\ud558\uace0, \ub3d9\uc77c\ud55c Key \uac12\uc744 \uac00\uc9c4 Row\uac00 \uc5c6\ub2e4\uba74 INSERT\ub97c \ud638\ucd9c\ud558\ub294 SQL \ubb38\uc758 \uc608\uc785\ub2c8\ub2e4. INSERT INTO current_load_powerfactor (ref_mRID, update_timeStamp, value) VALUES (&#8220;_1e1ccab5-250a-44a3-89d8-177e2d53e071&#8221;, NOW(), 99) ON DUPLICATE KEY UPDATE update_timeStamp=NOW(), value=99 \uc704\uc758 SQL\uc740 current_load_powerfactor\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 \ub300\ud574\uc11c, Primary Key\ub85c \uc7a1\ud78c ref_mRID\uac00 \uc911\ubcf5\ub41c \uc774\ubbf8 \uc874\uc7ac\ud558\ub294 Row\uac00 \uc788\ub2e4\uba74, \uc911\ubcf5\ub41c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=4996\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;MySQL, MariaDB\uc758 INSERT INTO &#8230; ON DUPLICATE KEY UPDATE &#8230;&#8221;<\/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":[1],"tags":[],"class_list":["post-4996","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4996","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4996"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4996\/revisions"}],"predecessor-version":[{"id":9641,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4996\/revisions\/9641"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4996"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4996"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}