mysql add 1 to value code example
Example 1: mysql update add to existing value
mysql> UPDATE tableName SET sometotal = sometotal+10 WHERE Id = 4;Example 2: mysql add to number
UPDATE user SET points = points + 1 WHERE id = 42mysql> UPDATE tableName SET sometotal = sometotal+10 WHERE Id = 4;UPDATE user SET points = points + 1 WHERE id = 42