update table with sum from same table mysql code example Example: mysql update sum same table UPDATE products SET quantity = quantity + 10 WHERE id = 8