【SQL】关联更新的简单写法

update table_a as a, table_b as b
set a.name = #{name}
where
a.id = b.id