MySQL查询中的表和列周围的引号真的必要吗? [英] Are quotes around tables and columns in a MySQL query really necessary?

问题描述

我有一个关于mysql查询的简短问题.

I have a short question about mysql query.

什么是正确的?

SELECT * FROM Persons WHERE Year='1965'

或

SELECT * FROM `Persons` WHERE `Year` = '1965'

这是个人选择还是真正的错误?

Is this a personal choice or is this something what is really wrong?

推荐答案

如果您有一个名为table的表或名为where的列，该怎么办.这些是保留关键字.如果您在查询中使用的关键字没有反引号，则它们会产生无效的查询(当然，使用保留关键字是不正确的做法).

What if you have a table named table, or a column named where. These are reserved keywords. If you used those in your queries without backticks, they'd produce an invalid query (Of course, using reserved keywords is bad practice).

SELECT something FROM table WHERE where = 1;

vs.

SELECT something FROM `table` WHERE `where` = 1;

这篇关于MySQL查询中的表和列周围的引号真的必要吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！