ansaurus

Question

Why doesn't this SQL UPDATE query work?

Answer 1

+3 A:

That looks like a MySQL error message. Doesn't MySQL use backticks (`) for escaping?

Ken 2010-03-05 07:09:14

Answer 2

+3 A:

UPDATE pages SET [order] = 1 WHERE id = 19

Nevemind MySQL

Dustin Laine 2010-03-05 07:09:27

It says "MySQL" right in the error message. :-)

Ken 2010-03-05 07:13:22

Interestingly, that didn't work either. Even though I immediately recognized what you were saying and was sure that was it.

Jason Rhodes 2010-03-05 07:14:27

Answer 3

+1 A:

don't use quotes, use [order] (or whatever your sql version uses for escaping). With the regular quotes it is seen as a string literal, which is not allowed here.

Hans Kesting 2010-03-05 07:09:58

Answer 4

A:

pavun_cool 2010-03-05 07:11:20

This won't work. ORDER is a reserved word, and so it must be escaped (which is database-specific)

Tim Drisdelle 2010-03-05 07:23:33

Answer 5

+6 A:

If using MySQL the query should look like this:

UPDATE `pages` SET `order`=1 WHERE `id`=19

Tobias 2010-03-05 07:14:51

Only backticks worked, but you only need them around the reserved word, order. So it's UPDATE pages SET `order`=1 WHERE id = 19 LIMIT 1. I was sure square brackets would have worked, I have to look into why they didn't.

Jason Rhodes 2010-03-05 07:26:16

Note that you don't have to escape every word (as shown in the example). Only `order`.

Tim Drisdelle 2010-03-05 07:26:18

Yes, you do not have to escape every word.But for better understanding (and I think its good practice) to escape the table and row names.[edit] Here is a list of reserved words foy mysql: http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

Tobias 2010-03-05 07:28:19

Answer 6

A:

"order" is a reserved word used in ... ORDER BY .... Use (`) (as Ken said).

lepe 2010-03-05 07:15:15

ansaurus

tags:

views:

answers:

Why doesn't this SQL UPDATE query work?

related questions