1、update a inner join b on a.id=b.id set a.name=b.name where ...
2、update table1 set a.name = b.name from table1 a inner join table2 b on a.id =b.id where...
2023-10-11 13:45:22
1、update a inner join b on a.id=b.id set a.name=b.name where ...
2、update table1 set a.name = b.name from table1 a inner join table2 b on a.id =b.id where...