Mysql 计算年龄函数
CREATE FUNCTION `get_age`(birthday datetime) RETURNS int(11)
BEGIN
DECLARE age int DEFAULT 0;
DECLARE now datetime DEFAULT now();
set age = (year(now)-year(birthday) - 1) + (DATE_FORMAT(birthday, '%m%d') <= DATE_FORMAT(now, '%m%d')) ;
return age;
END