MySQL 和引号的问题 [英] Issues with MySQL and quotation marks

问题描述

我有一个非常简单的查询:

I have this very simple query:

SELECT * FROM "orders" WHERE "printer_id" = 'AC001' AND "sent" = '0'

它抛出以下错误:

#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 '"orders" WHERE "printer_id" = 'AC001' AND "sent" = '0' at line 1

从列名中删除"就可以了！如果有帮助，我使用 Medoo (http://medoo.in/) 作为我的数据库框架.

Removing the "" from the column names makes it work! Im using Medoo (http://medoo.in/) as my database framework if that helps.

推荐答案

仅当 SQL_MODE 设置包含 ANSI_QUOTES 时，才使用标识符的双引号.

The double quotes around identifiers are used only if the SQL_MODE setting includes ANSI_QUOTES.

默认的标识符引号字符是反引号字符.

The default identifier quote character is the backtick character.

MySQL 返回语法错误，因为它将 "orders" 视为字符串文字，它需要一个标识符(表名).

MySQL is returning a syntax error because it's seeing "orders" as a string literal, where it's expecting an identifier (a table name).

以下任一方法都可以解决问题:

Either of these should work to get around the problem:

不加引号的标识符:

SELECT * FROM  orders  WHERE  printer_id  = 'AC001' AND  sent  = '0'

使用反引号将标识符括起来

Use backticks to enclose the identifiers

SELECT * FROM `orders` WHERE `printer_id` = 'AC001' AND `sent` = '0'

或者(我不推荐这个，但这是另一种方法......

Or (I dom't recommend this, but it is another approach...

更改 SQL_MODE 的设置以包含 ANSI_QUOTES 选项，并使用双引号作为标识符转义字符，就像在原始语句中一样.

Change the setting of the SQL_MODE to include ANSI_QUOTES option, and use the double quotes as the identifier escape character, like in your original statement.

这篇关于MySQL 和引号的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！