title: MySQL trigger 'update on column' syntax
body: <p>Can we use a MySQL trigger on update of specific columns, which updates another column in same table (same row)</p>
  
  <pre><code>create trigger my_trigger
  BEFORE UPDATE OF col1, col2 ON TABLE_NAME
  for each row
  set NEW.col3 =  NEW.col3 +1;
  </code></pre>
  
  <p>I tried the above code using <code>UPDATE OF col1, col2</code> . It is not working in MySQL. What is the correct syntax, can somebody point me to some examples.</p>