TSEAHT的博客

场景: 有个资源发布表 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_