Daily Archive for August 21st, 2009

MySQL恢复单一字段数据

1
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
Share