sql update add to existing value code example

Example: mysql update add to existing value

mysql> UPDATE tableName SET sometotal = sometotal+10 WHERE Id = 4;