Best update query for mysql table

Cooldude

New Member
I have a file hosting site where I provide a point for every unique download to user.Sample of my table
venok0.png
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.Thank You.
 
Top