你的SQL语法有错误;请查看与MySQL服务器版本对应的手册


mysql error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right

我在执行查询时总是得到这个错误:

你的SQL语法有错误;检查对应于MySQL服务器版本的手册,以便在第1行'read =1 WHERE user_id_sender =1 AND user_id_receiver = 33 AND OR user_id_sender'附近使用正确的语法

这是我的查询:

mysql_query("UPDATE messages SET read =1 WHERE user_id_sender = $user_id AND user_id_receiver = $user_id_partner AND read = 0 OR user_id_sender = $user_id_partner AND user_id_receiver = $user_id  AND read = 0  ") or die (mysql_error());

table(messages)有这些列:

message_id(INT)(AI)
user_id_sender(INT)
user_id_receiver(INT)
message(TEXT)
read(INT)

我真的不知道为什么会这样,我已经在网上看了,但我似乎找不到我确切问题的答案。也许有人能帮我一下。

READ为保留字

始终将数据库名、表名和列名用反引号括起来,以防止此类冲突:

UPDATE `messages` SET `read`=1 WHERE `user_id_sender`=$user_id AND...
相关文章: