add amount in integer mysql code example Example: mysql add to number UPDATE user SET points = points + 1 WHERE id = 42