9951 explained code solutions for 126 technologies


clickhouseUpdate rows in ReplacingMergeTree table


INSERT INTO rt(id, ver, name) VALUES(1, 3, 'Hillary')ctrl + c
rt

name of the ReplacingMergeTree table

id

primary key column (identifies unique rows)

ver

version column (we should increment it to overwrite row identified by id)

name

sample string column

(1, 3, 'Hillary')

we insert 3 into ver column (assume current version stored there is 2)