Question

This question already has an answer here:

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

Closed 9 years ago.

我试图用PHP做一个非常简单的UPDATE。

$nlk = $lk + "1";
mysql_query("UPDATE posts SET like =  ".$nlk."  WHERE id =  ".$cid." ") or die(mysql_error());

$lk is a the value gotten from the field like, which is default 0. $cid is a value from an id field, which is on auto_increment.

我发现这一错误:

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 like = 1 WHERE id = 45 at line 1

这里的问题是什么?

Answer 1

使用该栏():

mysql_query("UPDATE posts SET `like` =  ".$nlk."  WHERE id =  ".$cid." ") or die(mysql_error());

Better yet, don t use reserved words as table/column names.

Answer 2

就像一个保留词。你们需要用背书的方式来加以克服。

mysql_query("UPDATE posts SET `like` =  ".$nlk."  WHERE id =  ".$cid." ") or die(mysql_error());

Answer 3

<代码>类似为保留关键词。 See here, for a list of reservations keywords in mysql. 如果你随附,如-Column in remaps (`),该错误就应当删除。

Answer 4

<代码>如是MySQL的关键词。情况最有可能如此。要么试图放弃实地名称

mysql_query("UPDATE posts SET `like` =  ".$nlk."  WHERE id =  ".$cid." ") or die(mysql_error());

或者,如果你重犯同一错误,将实地名称改为别的东西。

Answer 5

Like is a keyword in SQL. This could cause your error. Change your column name, or, at least, add the table name in front of your "like".

Answer 6

因为LKE是一个关键词。采用对应标准。

Answer 7

http://dev.mysql.com/doc/refman/5.0/en/servd-words.html” rel=“nofollow”

页: 1

mysql_query("UPDATE posts SET `like` =  ".$nlk."  WHERE id =  ".$cid." ") or die(mysql_error());

Answer 8

背着你错误的信息,靠近WHERE id = 45”。

This query will probably run if replace the double quotation mark with a single.

-gz

我的坏处,我错过了像保留词前面的主要一面,并且看到的是非单体空间,因此,最后两个单一体会翻一番。期限。

友情链接