Update the value of column value in clickhouse database

The command is as follows:

:) ALTER TABLE tablename UPDATE column_name = column expresion1 WHERE expression;

Example:

:) ALTER TABLE tablename UPDATE time = time / 100 WHERE id = 0;