Error in where clause of sql update query

Question

Why does the sql query

UPDATE `singleent` SET `pre_timestamp` = CURRENT_TIMESTAMP WHERE listingType = 1

give error whereas

UPDATE `singleent` SET `pre_timestamp` = CURRENT_TIMESTAMP WHERE 1

or

UPDATE `singleent` SET `pre_timestamp` = CURRENT_TIMESTAMP

runs perfectly?

Edit:

The column type is timestamp and the error was:

Truncated incorrect static value: select listingType

listingType what type is that column? int? nvarchar? and whats the error that you receive? — Veljko89, Mar 23 '16 at 07:34
the column type is timestamp and the error was ' Truncated incorrect static value: select listingType' @Veljko89 — Shyam Agarwal, Mar 23 '16 at 07:44
Added `mysql` tag based on the backticks and the non-standard `where 1` clause — , Mar 23 '16 at 08:48

score 0 · Answer 1 · edited Mar 23 '16 at 08:48

0

The Error was due to the listingType being of Type varchar and so it needed the value to be in single inverted commas ''

The query

UPDATE `singleent` 
   SET `pre_timestamp` = CURRENT_TIMESTAMP 
WHERE listingType = '1'

is perfect

edited Mar 23 '16 at 08:48

answered Mar 23 '16 at 08:43

Shyam Agarwal

1 Answers1