按照出生日期来算,当前月日 < 出生年月的月日则,年龄减一
select student.SId as 学生编号,student.Sname as 学生姓名,
TIMESTAMPDIFF(YEAR,student.Sage,CURDATE()) as 学生年龄
from student
按照出生日期来算,当前月日 < 出生年月的月日则,年龄减一
select student.SId as 学生编号,student.Sname as 学生姓名,
TIMESTAMPDIFF(YEAR,student.Sage,CURDATE()) as 学生年龄
from student