【mysql】mysql update left join

：例如：

UPDATE user
 LEFT JOIN user_info 
  ON user.id = user_info.user_id 
SET user.validate_time =user_info.validate_time;