LineAsStringWithNames
| Input | Output | Alias |
|---|---|---|
| ✗ | ✔ |
Description
The LineAsStringWithNames format is similar to the LineAsString format but prints the header row with column names.
Example Usage
Query
CREATE TABLE example (
name String,
value Int32
)
ENGINE = Memory;
INSERT INTO example VALUES ('John', 30), ('Jane', 25), ('Peter', 35);
SELECT * FROM example FORMAT LineAsStringWithNames;
Response
name value
John 30
Jane 25
Peter 35