mysql如何计算年龄

MySQL可以通过DATEDIFF函数和CURDATE函数计算年龄。具体语句如下：

SELECT YEAR(CURDATE())-YEAR(birthday)-IF(MONTH(CURDATE())>MONTH(birthday),0,IF(MONTH(CURDATE())=MONTH(birthday) AND DAY(CURDATE())>DAY(birthday),0,1)) AS age FROM table_name;

其中，birthday为生日对应的字段名，table_name为对应的表名。执行以上语句可以计算出年龄。