{"id":9257,"date":"2018-03-13T05:35:09","date_gmt":"2018-03-13T05:35:09","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=9257"},"modified":"2018-03-13T05:35:09","modified_gmt":"2018-03-13T05:35:09","slug":"upsert-a-row-into-mysql-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mysql\/upsert-a-row-into-mysql-table.html","title":{"rendered":"Upsert a row Into Mysql Table"},"content":{"rendered":"

In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”.<\/p>\n

INSERT INTO employees(id, name, hire_date ) \r\nVALUES (1, 'John', '2016-11-29' ) \r\nON DUPLICATE KEY UPDATE name='john', hire_date='2016-11-29'<\/pre>\n
In SQL Server,\u00a0https:\/\/www.withdata.com\/blog\/sql-server\/replace-update-or-insert-a-row-into-sql-server-table.html<\/a><\/p>\n
In Oracle,\u00a0https:\/\/www.withdata.com\/blog\/oracle\/replace-update-or-insert-a-row-into-oracle-table-merge-into.html<\/a><\/p>\n
In DB2,\u00a0https:\/\/www.withdata.com\/blog\/db2\/replace-update-or-insert-a-row-into-db2-table-merge-into.html<\/a><\/p>\n
In Sqlite,\u00a0https:\/\/www.withdata.com\/blog\/sqlite\/replace-update-or-insert-a-row-into-sqlite-table.html<\/a><\/p>\n
Some MySQL tools you can try:  https:\/\/www.withdata.com\/mysql\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
In Mysql, if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. INSERT INTO employees(id, name, hire_date ) VALUES (1, ‘John’, ‘2016-11-29′ ) ON DUPLICATE KEY UPDATE name=’john’, hire_date=’2016-11-29′ In SQL Server,\u00a0https:\/\/www.withdata.com\/blog\/sql-server\/replace-update-or-insert-a-row-into-sql-server-table.html In […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[238,1323,239,428],"class_list":["post-9257","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-merge-into","tag-mysql","tag-replace-into","tag-upsert"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=9257"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9257\/revisions"}],"predecessor-version":[{"id":9258,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9257\/revisions\/9258"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=9257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=9257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=9257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}