根据一个表更新另一个表
1.
update a,b set a.age=b.age where a.id=b.id
2.子查询
update a inner join b on a.name = b.nname set a.age = b.age where a.id = b.id
根据一个表更新另一个表
1.
update a,b set a.age=b.age where a.id=b.id
2.子查询
update a inner join b on a.name = b.nname set a.age = b.age where a.id = b.id