how to modify the values column in mysql code example

Example 1: mysql update add to existing value

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

Example 2: how to edit a value in acoulum for a table mysql cmd

mysql> DESCRIBE users;
+---------+------------------+------+-----+-------------------+-----------------------------+
| Field   | Type             | Null | Key | Default           | Extra                       |
+---------+------------------+------+-----+-------------------+-----------------------------+
| id      | int(11)          | NO   | MUL | NULL              |                             |
| name    | varchar(255)     | YES  |     | NULL              |                             |
| address | varchar(10)      | YES  |     | NULL              |                             |
| date    | timestamp        | NO   |     | CURRENTTIMESTAMP  | on update CURRENTTIMESTAMP  |
| uid     | int(10) unsigned | NO   | PRI | NULL              | auto_increment              |
+---------+------------------+------+-----+-------------------+-----------------------------+

Tags:

Sql Example