Answers for "#1064 error in mysql"

mysql #1064 error

UPDATE test
SET  field  = IF(something == 1{CONDITION}, 1 {NEW VALUE}, field)
WHERE `id` = 5

Posted by: Guest on December-31-2019

propabaly you are using a reserved keyword as column name, just add `` around the coulumn name.

Posted by: Guest on August-17-2021

Code answers related to "#1064 error in mysql"