Comments on: Merging tables with INSERT…ON DUPLICATE KEY UPDATE https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update Blog by Shlomi Noach Fri, 22 Feb 2013 15:19:24 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Latest data Industry news round up, Log Buffer #308 https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update/comment-page-1#comment-183842 Fri, 22 Feb 2013 15:19:24 +0000 https://shlomi-noach.github.io/blog/?p=6120#comment-183842 […] Shlomi Noach is merging tables with INSERT…ON DUPLICATE KEY UPDATE. […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update/comment-page-1#comment-183594 Fri, 22 Feb 2013 04:27:01 +0000 https://shlomi-noach.github.io/blog/?p=6120#comment-183594 Rick,
Yes

]]> By: Rick James https://shlomi-noach.github.io/blog/mysql/merging-tables-with-insert-on-duplicate-key-update/comment-page-1#comment-183446 Thu, 21 Feb 2013 21:10:18 +0000 https://shlomi-noach.github.io/blog/?p=6120#comment-183446 Are these identical?
x = ifnull(tmerge.x, values(x))
x = coalesce(tmerge.x, values(x))

]]>