9951 explained code solutions for 126 technologies


clickhouseInserting data into table example


Although Clickhouse allows inserting data row-by-row, use bulk insert to get best performance if inserting more than 1 row.

INSERT INTO tbl(ts, col) VALUES(now(), 123)ctrl + c
INSERT INTO

will insert data into specified table

tbl

name of the table to insert data to

ts, col

column names to specify values for (can be skipped)

VALUES

list of values to insert into row

now(), 123

will insert current datetime into ts column and 123 value into col column