9951 explained code solutions for 126 technologies


clickhouseSelecting with JSONEachRow format


SELECT * FROM tbl FORMAT JSONEachRowctrl + c

Usage example

SELECT * FROM tbl FORMAT JSONEachRow
output
{"date":"2022-01-07","col":"Donald","val":0,"age":0}
{"date":"2022-01-10","col":"Donald","val":0,"age":0}
{"date":"2022-01-11","col":"Donald","val":0,"age":0}