赞
踩
mysql 更新中使用left jon where UPDATE user2 t1 left join usera1 t2 on t1.sex = t2.id set t1.phone = t2.name where t1.age = 10
user2
usera1
sex
id
phone
name