A表的a字段 关联 B表的b字段(主键) b字段对应c字段现在要把c字段同步更新到A表里面去

场景:
有个资源发布表 release 存了年级id (grade_id)
有个年级学段对应表 grade (id, school_type_id)
现在要把school_type_id同步更新到release表
ALTER TABLE release ADD school_type_id BIGINT ( 20 ) UNSIGNED DEFAULT NULL COMMENT ‘学段ID’ AFTER path;
UPDATE release r
INNER JOIN grade g ON r.grade_id = g.id
SET r.school_type_id = g.school_type_id;