mysql error code 1414 code example

Example 1: error code 1205 mysql

SET innodb_lock_wait_timeout = 5000;

Example 2: mysql #1064 error

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