UPDATE enrollments e
JOIN students s ON e.student_id = s.student_id
SET e.email = s.email;
BlogPost5 min read
更新一张与另一张表关联的连接字段记录
Written on 2024.10.12
Written on 2024.10.12
UPDATE enrollments e
JOIN students s ON e.student_id = s.student_id
SET e.email = s.email;