How to update in database

Question

How to update in database. while purchase the product that time will decreses the number of product total

for example 100 after purchase 10 product will less the counting.



send me with example.



Thanks&Regs

Magesh.A