MySQL 获取计算列和所有列(*)

Question

我有一个表，我有列。我想获取 AGE 列 - 它正在创建(当前日期 - 年份列数据) - 以及像 * 这样的整个列。

我试过了；

SELECT (YEAR(CURRENT_DATE) - YEAR(dateOfBirth)) as age , * FROM users

但它给出了错误:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM users LIMIT 0, 25' at line 1

我应该写什么？谢谢!

Answer 1

使用别名和TIMESTAMPDIFF 函数

SELECT u.*,
TIMESTAMPDIFF(YEAR, dateOfBirth, CURRENT_DATE) as age
FROM users u