php - How to make sql table display age computed by a specific formula?

Question

The formula:

TIMESTAMPDIFF(YEAR, `date_of_birth`, CURDATE())

I have to manually execute this query:

UPDATE `squad` SET `age` = TIMESTAMPDIFF(YEAR, `date_of_birth`, CURDATE())

Every time I insert rows into table, also when there is a player's birthday it surely doesn't apply a new age.

标签： phpmysql

Answer 1

请确保您 date_of_birth在表中使用日期时间或日期数据类型（不是 var char 数据类型），如果是，那么它工作正常。还有一件事 date_of_birth以 Ymd 格式插入。对于您的疑问，我创建相同的表并运行相同的查询然后它工作正常