mysql modify value in table code example

Example 1: how to update an attribute in MySQL

UPDATE table_name
SET variable = 'changed field', variable = 'another changed field'
WHERE firstline_name = 1;

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