how to change the column value mysql code example

Example 1: update all rows mysql

UPDATE tableName SET columnName = yourValue;
#to update multiple columns:
UPDATE tableName SET column1 = value1, column2 = value2; #and so on

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              |
+---------+------------------+------+-----+-------------------+-----------------------------+