UPDATE feifei.student s, feifei.temp t
SET s.name = t.name,
s.sex = t.sex,
s.age = t.age
WHERE s.student_id = t.student_id;
或者可以这样
UPDATE feifei.student s
INNER JOIN feifei.temp t ON t.student_id=s.student_id
SET s.name=t.name,
s.age=t.age,
s.sex=t.sex;