PG:
UPDATE cd_pipeline_tbl
SET well_source = temp_pipeline.well_source
FROM temp_pipeline
WHERE cd_pipeline_tbl.key_id = temp_pipeline.key_id
PG多表:
UPDATE table1
SET column1 = new_value
FROM table2
JOIN table3 ON table2.column2 = table3.column3
JOIN table4 ON table3.column4 = table4.column5
WHERE table1.column6 = some_value;
MySQL:
UPDATE t_order o
INNER JOIN t_product p ON o.product_id=p.id
SET o.product_name=p.product_name