MySQL关联多表进行update更新操作示例：

update product as a
join brand as b on a.brand_id = b.id
set a.brand_id = b.`relation_id`
where b.`relation_id` > 0;