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;

Comments

Popular posts from this blog

BdsDex: failed to load Boot0001 "UEFI BHYVE SATA DISK BHYVE-OABE-20A5-E582" from PciRoot(0x0)/Pci (0x2, 0x0)/Stat(0x0,0xFFFF,0x0) : Not Found

FreeBSD安装SCIM中文输入法(csh/tcsh)

How to Dockerizing LEMP Stack with Docker-Compose