黄聪：mysql下使用update set from select

UPDATE friends INNER JOIN users ON friends.friendid=users.userid
SET friends.friendname=users.username