title: Optimistic locking in MySQL
body: <p>I can't find any details on optimistic locking in MySQL.
  I read that starting a transaction keep updates on two entities synced, however - it doesn't stop two users updating the data at the same time causing a conflict.</p>
  
  <p>Apparently optimistic locking will solve this issue?  How is this applied in MySQL. Is there SQL syntax / keyword for this? Or does MySQL have default behavior?</p>
  
  <p>Thanks guys.</p>