更新一张与另一张表关联的连接字段记录

UPDATE enrollments e
JOIN students s ON e.student_id = s.student_id
SET e.email = s.email;