title: Simple Q regarding MySQL inline UPDATE
body: <p>I have a little confusion in this issue... For the same reason we use transactions and before applying our logic and updating a row in database we of course SELECT it with LOCK IN SHARE MODE.</p>
  
  <p>However my question is, if there is an inline update query for numeric value: i.e:</p>
  
  <pre><code>UPDATE table SET num1=num1+1, num2=num2-1 WHERE group='abc'
  </code></pre>
  
  <p>Will this provide always accurate value without locking row / using transactions?
  and what if this query is used along side other logic in a transaction (which is "required" for some other query).</p>