Incorrect syntax error near keyword read,when I update

Question

update cometchat set read='1' where id='18'

SQL Error 156:Incorrect syntax near the keyword 'read'.

Can you guys help me how do I do that?

@Rizier123: Based on the error message, the database in question is not MySql, but Sql Server, so this is **not** a duplicate of the post you've chosen. — Zohar Peled, Jan 23 '17 at 08:54
@ZoharPeled Your right, I just saw the mysql tag. Then it should be closed with: http://stackoverflow.com/q/285775 — Rizier123, Jan 23 '17 at 09:00
Holiday Tourism you have answers below. Check them and mark one as accepted answer.Thanks — Alive to die - Anant, Jan 24 '17 at 04:17

Zohar Peled · Answer 1 · 2017-01-23T07:46:50.600

2

Read is a reserved word. You need to escape it. Also, if the values are integers, you should not use the single quotes around them.

If It's Sql Server (and it is, based on the error message), you need to use square brackets:

update cometchat set [read]=1 where id=18

In MySql, your query should look like this:

update cometchat set `read`=1 where id=18

edited Jan 23 '17 at 07:46

answered Jan 23 '17 at 07:40

Zohar Peled

score 0 · Answer 2 · edited May 23 '17 at 12:16

0

You shouldn't put quotes around int values in your query as it converts them to type string.

UPDATE cometchat SET `read`=1 WHERE id=18

**Edit: You're also using a reserved keyword, and need to escape it, see:

edited May 23 '17 at 12:16

Community

answered Jan 23 '17 at 07:36

Kaylined

score 0 · Answer 3 · answered Jan 23 '17 at 07:42

0

Seriously...

UPDATE cometchat SET `read`=1...

"read" is a restricted keyword. It needs to be quoted.

answered Jan 23 '17 at 07:42

junkfoodjunkie

3 Answers3