update tableA a left join tableB b on a.id= b.id set a.name = b.name,a.age=b.age where a.id=b.id;
通过一张表更新另一张表
于 2020-05-22 10:32:02 首次发布
update tableA a left join tableB b on a.id= b.id set a.name = b.name,a.age=b.age where a.id=b.id;