mysql 多个sum,MySQL Sum（）多列

I have a table of student scorecard.

here is the table,

subject | mark1 | mark2 | mark3 |......|markn

stud1 | 99 | 87 | 92 | | 46

stud2 |....................................

.

.

studn |....................................|

Now, i need to sum it for each student of total marks. I got it by using sum(mark1+mark2+...+markn) group by stud. I want to know how to sum it without adding each column name,it will be huge when in case up to marks26. so could anyone know how to fix it. Thanks in advance.

解决方案SELECT student, (SUM(mark1)+SUM(mark2)+SUM(mark3)....+SUM(markn)) AS Total

FROM your_table

GROUP BY student