title: Mysql multi connections with atomic update sql queries [Race condition]
body: <p>I'm currently working on a project in nodejs that has a pool connection to Mysql DB ( with like 10 connections open at the same time ).
  And now I want to able the connections to update tables in the DB like so:</p>
  <pre><code>update table set tries=tries+1 where condition=value;
  </code></pre>
  <p>My question is there is no way that will be here a race condition between all the connections with this approach?
  because I've looked up on the internet and found that &quot;transactions&quot; in my SQL will cause a race condition between multi DB connections.</p>
  <p>Thanks</p>