mysql 两个表 字段赋值

把 B表的 uniond 值 填到 A表的 username 中去

 

UPDATE  member A, `thirdusers` B SET A.username = B.unionid WHERE A.userid = B.userid