2808 explained code solutions for 75 technologies


clickhouseInsert value into array column


INSERT INTO tbl3(ts, list) VALUES(now(), ['a', 'b', 'c'])ctrl + c
tbl3

table with array column

list

name of array (of strings) column

['a', 'b', 'c']

value for array column


Usage example

INSERT INTO tbl3(ts, list) VALUES(now(), ['a', 'b', 'c']);
SELECT * FROM tbl3;
output
┌──────────────────ts─┬─list──────────┐
│ 2022-01-14 17:41:32 │ ['a','b','c'] │
│ 2022-01-14 17:41:38 │ ['b','c','d'] │
└─────────────────────┴───────────────┘