title: 1136 MySQL error - Column count doesn't match value count at row 1
body: <p>I am trying to update a table(table_name) with the condition:</p>
  
  <pre><code>UPDATE `table_name` 
  SET `column1` = 123
  WHERE `column1` = 100 
  AND `column2` NOT IN (1,2,3,4,5,6);
  </code></pre>
  
  <p>But getting the 1136-error. 
  When the condition rows matching are 0, the update is working, but when the condition matching rows are more than 1 or more the update is not working.
  There is 1 trigger on the table for UPDATE.</p>