MySQL_DQL_select_数学运算

常用数学运算

+、-、*、/、%

例子

给每个学生的英语成绩加上1分,并计算总分

SELECT id,
         user_name,
         math AS "数学",
         english + 1 AS aa,
         math + english + 1 AS "总分"
FROM student;