SQL 两表关联更新UPDATE (用一个表更新另一个表)
摘要:方法一: update table1 set field1=table2.field1 from table2 where table1.id=table2.id --简写 update t1 set t1.c2 = t2.c2 from t2 where t1.c1 = t2.c1 方法二: up
阅读全文
posted @ 2021-09-25 10:51
posted @ 2021-09-25 10:51
posted @ 2021-09-06 08:09