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 full_score = 150 WHERE course = 2 AND full_score IS NULL;