mysql 两表关联更新 把b表的name给a表的name UPDATE table_a aLEFT JOINtable_b bON p.id= a.uidSET a.name = b.nameWHERE a.name != ''