Check out example codes for "mysql #1064 error". It will help you in understanding the concepts better.

Code Example 1

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

Code Example 2

syntax error

Learn ReactJs, React Native from akashmittal.com