mysql - 我如何通过使用 ORDER BY 和 LIMIT 的简单查询来解决这个问题？

Question

我在 windows cmd 上运行 MySQL，我输入的命令是

SELECT name,rank,year FROM movies ORDER BY year DESC LIMIT 10;

我收到语法错误:

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 ' ,year from movies order by year DESC limit 10' at line 1

预期结果:

按降序排列年份，行数限制为10；

Answer 1

year是关键字。您能否通过在列名称周围添加 `(反勾符号)来转义关键字以解决问题:

SELECT name, `rank`, `year` FROM movies ORDER BY `year` DESC LIMIT 10;