sql update subtract value code example Example: sql update subtract value UPDATE products SET stock_quantity=stock_quantity - 5 WHERE item_id=4