9951 explained code solutions for 126 technologies


clickhouseHow to insert Tuple values


INSERT INTO tbl4 (ts, person) VALUES(now(), ('Donald', 1))ctrl + c
tbl4

name of the table with Tuple column

person

name of the created Tuple column

('Donald', 1)

Tuple column value consisting of a String and UInt32


Usage example

INSERT INTO tbl4 (ts, person) VALUES(now(), ('Donald', 1));
SELECT * FROM tbl4;
output
┌──────────────────ts─┬─person───────┐
│ 2022-01-19 14:04:03 │ ('Donald',1) │
└─────────────────────┴──────────────┘