pgsql 连表更新语法
UPDATE table_reference t1 SET col_name1 = t2.col_name2 FROM table_reference t2 WHERE t1.col_name1 = t2.col_name1
阅读全文 →共 1 篇文章
UPDATE table_reference t1 SET col_name1 = t2.col_name2 FROM table_reference t2 WHERE t1.col_name1 = t2.col_name1
阅读全文 →