Updating a column with an array of rows

Community
,
1

Hi.

I have prices stored within a certain time period that need to be updated, it is a lot of rows, and I therefor do not want to update each row individually.

Is it possible to use the UPDATE statement with an array of values

2

If they are just in a time range, then you can use an UPDATE … WHERE.

Otherwise, it can be easier to simpler to enable DEDUP and use a read-modify-write. i.e.

INSERT INTO tbl (vlaue1, value2, value3, value4)
SELECT 
    old_value1 as value1, 
    old_value2 as value2, 
    “abc” as value3, 
    old_value4 as value4
FROM tbl
WHERE ...