title: if two users add 1 to a mysql value at same time will both work
body: <p>say I had a survey where there are two radio buttons. Yes/No. obviously I don't want to store a thousand "yes's" and "no's" in a database. I just want a single number to count the "yes's" and a single number to count the "no's". it look like this is the easiest method</p>
  
  <pre><code>UPDATE `databasename`.`tablename` SET fieldB = fieldB + 1 WHERE fieldA='#';
  </code></pre>
  
  <p>but I'm wonder if 2 people submit a survey at the same time would each look at the database see 500 "yes's" and both update it to 501. or is MySQL set up in away that one would have to wait fir the other to finish first.</p>