mysql根据出生日期计算年龄

新建用户数据表

CREATE TABLE `test`.`user2` (
  `user_id` INT NOT NULL AUTO_INCREMENT,
  `user_name` VARCHAR(45) NULL,
  `birthday` DATETIME NULL,
  PRIMARY KEY (`user_id`));

INSERT INTO `test`.`user2` (`user_name`, `birthday`) VALUES ('张无忌', '1994-01-01');
INSERT INTO `test`.`user2` (`user_name`, `birthday`) VALUES ('令狐冲', '1998-05-24');

将出生日期字段转换为年龄字段

SELECT user_name,ceil(datediff(now(),birthday)/365)  age FROM test.user2;

datediff(startDate,endDate)计算相差天数
ceil()向上取整