blocks|key|2834897|text|通常情况下，第一步是不要这样做，但如果已经这样做了，那么您需要求助于正确地引用列名：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2834898|SELECT+`Business+Name`+FROM+annoying_table|code-block|syntax|javascript|2834899|通常，这些东西是由使用过Microsoft+Access等工具的人创建的，并且总是使用GUI来做他们的事情。|2834900|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Generally the first step is to not do that in the first place, but if this is already done, then you need to resort to properly quoting your column names:

<pre><code>SELECT `Business Name` FROM annoying_table
</code></pre>

Usually these sorts of things are created by people who have used something like Microsoft Access and always use a GUI to do their thing.

blocks|key|2834902|text|我认为双引号也适用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2834903|SELECT+"Business+Name","Other+Name"+FROM+your_Table|code-block|syntax|javascript|2834904|但我只是在SQL+Server上测试，而不是在mySQL上测试，以防有人使用MS+SQL+Server。|2834905|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I think double quotes works too:

<pre><code>SELECT "Business Name","Other Name" FROM your_Table
</code></pre>

But I only tested on SQL Server NOT mySQL in case someone work with MS SQL Server.

blocks|key|200007|text|每个列都有自己的代码，但正确的编码方法是重命名列，插入下划线，这样就没有空格了。这将确保在编码时零错误。在打印列名以供公共显示时，您可以搜索并替换，将下划线替换为空格。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|200008|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

To each his own but the right way to code this is to rename the columns inserting underscore so there are no gaps. This will ensure zero errors when coding. When printing the column names for public display you could search-and-replace to replace the underscore with a space.

blocks|key|204574|text|如果双引号不起作用，请尝试将字符串包括在方括号中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|204575|例如：|204576|SELECT+"Business+Name","Other+Name"+FROM+your_Table|code-block|syntax|javascript|204577|可以更改为|204578|SELECT+[Business+Name],[Other+Name]+FROM+your_Table|offset|length|style|CODE|204579|entityMap^0|0|0|0|0|0|1F|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|W|8|@$M|X|N|Y|O|P]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

If double quotes does not work , try including the string within square brackets.

For eg:

<pre><code>SELECT "Business Name","Other Name" FROM your_Table
</code></pre>

can be changed as 

<code>SELECT [Business Name],[Other Name] FROM your_Table</code>

blocks|key|200010|text|您需要使用反引号而不是单引号：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|200011|单引号-+'Business+Name'+-错误|offset|length|style|CODE|200012|反引号-+`Business+Name`+-正确|200013|entityMap^0|0|5|F|0|5|F|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

You need to use backtick instead of single quotes:

Single quote - <code>'Business Name'</code> - Wrong

Backtick - <code>`Business Name`</code> - Correct

blocks|key|202431|text|我来这里的时候遇到了MS访问问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202432|反引号对MySQL有好处，但它们会产生奇怪的错误，如MS+Access中的"Invalid+Query+Name:+Query1“，仅对于MS+Access，请使用方括号：|202433|它应该看起来像这样|202434|SELECT+Customer.[Customer+ID],+Customer.[Full+Name]+...|code-block|syntax|javascript|202435|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I got here with an MS Access problem.
Backticks are good for MySQL, but they create weird errors, like &quot;Invalid Query Name: Query1&quot; in MS Access, for MS Access only, use square brackets:
It should look like this
<pre><code>SELECT Customer.[Customer ID], Customer.[Full Name] ...
</code></pre>

I am working on a project where another developer created a table with column names like <code>'Business Name'</code>. That is a space between two words. If I run a <code>SELECT</code> statement with 'Business Name' it says there is no column with name 'Business'.

How can I solve this problem?

How to select a column name with a space in MySQL

SQL Server

MySQL

我正在做一个项目，在这个项目中，另一个开发人员创建了一个具有类似'Business Name'的列名的表。这是两个单词之间的空格。如果我运行一条名为'Business Name‘的SELECT语句，它会显示没有名为'Business’的列。我该如何解决这个问题？

问如何在MySQL中选择带空格的列名
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中选择带空格的列名EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySQL中选择带空格的列名
EN