title: Is incrementing a field in MySQL atomic?
body: <p>I'm making a web site where I would like to increment a counter in a standard MyISAM table.</p>
  
  <p>Simplified example:</p>
  
  <pre><code>UPDATE votes SET num = num + 1;
  </code></pre>
  
  <p>Will this cause problems if multiple connections are doing the same query, or will MySQL take care of it and lock the table or something to make sure that there are no conflicts?</p>