Posts

Showing posts with the label update column value

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;