黄聪：mysql下使用update set from select时间：2024-11-13 12:37:02 UPDATE friends INNER JOIN users ON friends.friendid=users.userid SET friends.friendname=users.username
