mysql计算年龄

YEAR(CURDATE())-YEAR(addtime)-(RIGHT(CURDATE(),5)<RIGHT(addtime,5))

addtime='2006-11-2'
mysql> SELECT id,  YEAR(CURDATE())-YEAR(addtime)-(RIGHT(CURDATE(),5)<RIGHT(addtime,5))   FROM user  where id='109480'

来自：http://www.cnblogs.com/fenglie/p/3985521.html
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/dengyg200891/p/5966086.html