php - mysql 更新查询失败

Question

这个问题已经有答案了:

Syntax error due to using a reserved word as a table or column name in MySQL (1 个回答)

已关闭 9 年前。

我的查询代码是:

$query = mysql_query("UPDATE books SET read = 'y' WHERE id = 2") or die(mysql_error());

错误是:

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 'read = 'y' WHERE id = 2' at line 1

Answer 1

read是MySQL中的保留关键字。将其括在反引号中:

UPDATE books SET `read` = 'y' WHERE id = '2'

参见http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html查看保留关键字列表。