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?

Accepted Answer

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

MySQL Update syntax error

Solution

Problem