Mysql批量查询更新另一张表

update xxx a
INNER JOIN xxx b on a.name = b.name
set a.id = b.id
where b.del = 0