MySQL恢复单一字段数据


UPDATE people_user AS p LEFT JOIN people_user_tmp AS t ON t.user_id = p.user_id SET p.user_pic = t.user_pic WHERE p.user_id<1871