MySQL中根据A表画更新B表

Update tTarget a,tSource B
Set a.MyName=b.MyName
Where a.MyID=b.MyID