sql 从另外一张表查询数据存入本表. (有关联的)

UPDATE friends INNER JOIN users ON friends.friendid=users.userid

SET friends.friendname=users.username 

转载于:https://www.cnblogs.com/yanjunwu/p/4213217.html