Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

Markdown

Input Output Alias
MD

Description

You can export results using Markdown format to generate output ready to be pasted into your .md files:

The markdown table will be generated automatically and can be used on markdown-enabled platforms, like Github. This format is used only for output.

Example usage

SELECT
    number,
    number * 2
FROM numbers(5)
FORMAT Markdown
| number | multiply(number, 2) |
|-:|-:|
| 0 | 0 |
| 1 | 2 |
| 2 | 4 |
| 3 | 6 |
| 4 | 8 |

Format settings

Navigation