update a inner join b on a.bid=b.id set a.x=b.x,a.y=b.y;
update
a
inner
join
b
on
a.bid=b.id
set
a.x=b.x,a.y=b.y;