MySQL关联更新update

Demo：

update a join b on a.foreign_id = b.id
set a.name = b.name 
where a.name is null;