SQL 日付計算（年齢算出）

SELECT
name,
birth,
curdate(),
(YEAR(CURDATE())-YEAR(birth)) - (RIGHT(CURDATE(),5) < RIGHT(birth,5)) AS age
FROM age;