Is there an "Update if not exists insert" (like replace in MySQL)?

Question

Is there an "update if not exists insert" function in Redshift, like replace in MySQL?

If not, what should I do instead?

Look for `upsert' on SO, you'll find lotof answers – Houari Aug 27 '15 at 08:23 — Houari, Aug 27 '15 at 08:23

Bernd Buffen · Answer 1 · 2015-08-27T08:26:53.627

-2

there is a other way

INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b);

you right, sorry

edited Aug 27 '15 at 08:26

answered Aug 27 '15 at 08:21

Bernd Buffen

1 Answers1