MySQL Update syntax error

Question

I need to have MySQL query like this one:

UPDATE table_name
SET
    1 = 1
WHERE
    ID = 257

But I got the syntax 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 '1 = 1 
WHERE ID = 257' at line 3

Need to perform an UPDATE query without updating anything. What are the solutions?

what is purpose of running query without updating anything? Mysql will not allow u to do this — Andrey
– Andrey, Commented Mar 4, 2010 at 22:07
@Andrey: -1. While I've never had the need to just run a no-op query by itself, it's quite common to do this with INSERT .. ON DUPLICATE... queries. — jasonbar
– jasonbar, Commented Mar 4, 2010 at 22:09
Presumably, he wants a trigger to be triggered, or perhaps auditing to occur. — tpdi
– tpdi, Commented Mar 4, 2010 at 22:09

jasonbar · Accepted Answer · 2010-03-04 22:04:49Z

6

UPDATE `table_name`
SET `ID` = `ID`
WHERE `ID` = 257

answered Mar 4, 2010 at 22:04

jasonbar

13.5k4 gold badges41 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sam Holloway · Accepted Answer · 2010-03-04 22:04:49Z

1

How about:

UPDATE table_name
SET
    ID = 257
WHERE
    ID = 257

Would that work for you?

answered Mar 4, 2010 at 22:04

Sam Holloway

2,01915 silver badges14 bronze badges

Collectives™ on Stack Overflow

MySQL Update syntax error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related