title: Is there a way to increment the value of a sql column without reading it
body: <p>I wanted to know if there is a way I can directly increment the value of a column without reading the current value.
  something like:</p>
  
  <pre><code>update table `user` set cnt = cnt+1
  </code></pre>
  
  <p>The above statement gave me a syntax error, but I am sure there has to be something for it. </p>
  
  <p>Thanks</p>