title: How to lock a single row
body: <p>I have a <code>user</code> table with field <code>lastusedecnumber</code>.</p>
  
  <p>I need to access and increment <code>lastusedecnumber</code>.</p>
  
  <p>During that accessing time I need to lock that particular user row (not the entire table).</p>
  
  <p>How do I do this?</p>
  
  <p>The table type is <code>MyISAM</code>.</p>