phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alchemist <>
Subject How to support UPSERT with WHERE clause
Date Sat, 14 Jul 2018 23:54:38 GMT
Looks like UPSERT doesn't support a WHERE clause.

But people have used workaroung like following:

UPSERT INTO test.MyTable(col1, col2) SELECT col3, col4 FROM test.TempTable
WHERE col5 = ABC

Does that mean If I have a use case where I need to update all the columns
of the MyTable based on some key, I need to add the data to be updated in
another TempTable then use a command similar to above to update data of the
MyTable.  Please let me know if my understanding is correct.  Somehow adding
data in another table just to update source table does not seems correct.

Sent from:

View raw message