mysql 批量更新语句

已经知道了用户名对应的uid，需要批量更新另外的表中的用户名对应的authorid

UPDATE bbs_forum_thread AS p
  INNER JOIN bbs_common_member AS m
    ON p.author = m.username
SET p.authorid = m.uid;