mysql中如何获取学生总分

CREATE TABLE student_scores (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    math_score INT,
    english_score INT,
    science_score INT
);

SELECT id, name, (math_score + english_score + science_score) AS total_score
FROM student_scores;

-- 使用动态SQL
SET @sql = NULL;
SELECT GROUP_CONCAT(column_name) INTO @sql FROM information_schema.columns WHERE table_name = 'student_scores' AND column_name LIKE '%_score';
SET @sql = CONCAT('SELECT id, name, (', @sql, ') AS total_score FROM student_scores');
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

CREATE INDEX idx_student_name ON student_scores(name);

ALTER TABLE student_scores MODIFY math_score INT;
ALTER TABLE student_scores MODIFY english_score INT;
ALTER TABLE student_scores MODIFY science_score INT;