title: Best update query for mysql table
body: <p>I have a file hosting site where I provide a point for every unique download to user.</p>
  <p>Sample of my table<br />
  <a href="https://i.stack.imgur.com/2uRIL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2uRIL.png" alt="Sample table" /></a></p>
  
  <p>These points can be redeemed by user. So for example if a user redeems 100 points than what is the best query to reduce points available from each row till 100 points are reduced.</p>
  <p>Thank You.</p>