edit a value in mysql row code example

Example 1: mysql change value

UPDATE [LOW_PRIORITY] [IGNORE] table_name 
SET 
    column_name1 = expr1,
    column_name2 = expr2,
    ...
[WHERE
    condition];

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