pgsql 连表更新语法
0
查看原文 ↗
UPDATE table_reference t1
SET col_name1 = t2.col_name2
FROM
table_reference t2
WHERE
t1.col_name1 = t2.col_name1UPDATE table_reference t1
SET col_name1 = t2.col_name2
FROM
table_reference t2
WHERE
t1.col_name1 = t2.col_name1