UPDATE sq_testpaper SET full_score = CASE WHEN course IN (1, 2, 3) THEN 150 ELSE 100 END; — 更新有小题记录的数学试卷满分 UPDATE sq_testpaper tp SET full_score = (SELECT SUM(score) FROM sq_testpaperinfo WHERE testpaper_id = tp.id) WHERE tp.course = 2; — 将没有小题记录的数学试卷满分设置为默认值150 UPDATE sq_testpaper SET […]