MySQL根据生日计算年龄

select
    id,
    DATE_FORMAT(birthday,"%Y-%m-%d") birthday,
    CURDATE() ,
    (year(CURDATE())-year(birthday)-1) + ( DATE_FORMAT(birthday, '%m%d') <= DATE_FORMAT(CURDATE(), '%m%d') ) as age
from

    user ;

原文地址：http://houzhiqingjava.blog.163.com/blog/static/167399507201362084525866/