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

warrenwt / 2024-10-12 / 原文

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