lt@DESKTOP-RS3EG9A:~$ clickhouse-client -m
ClickHouse client version 20.11.3.3 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.11.3 revision 54442.

DESKTOP-RS3EG9A.localdomain :) create database mydb;

CREATE DATABASE mydb

Query id: df069962-718d-447a-9c80-609e81a0c70b

Ok.

0 rows in set. Elapsed: 0.019 sec.

DESKTOP-RS3EG9A.localdomain :) use mydb;

USE mydb

Query id: 8cd47799-602d-469d-901c-67bbfa0f977d

Ok.

0 rows in set. Elapsed: 0.002 sec.

DESKTOP-RS3EG9A.localdomain :) create table mytab2 (id Int32, name String) Engine =MergeTree order by id;

CREATE TABLE mytab2
(
    `id` Int32,
    `name` String
)
ENGINE = MergeTree
ORDER BY id

Query id: 88c160e6-902b-4fd4-99de-aa39a26302e5

Ok.

0 rows in set. Elapsed: 0.006 sec.

DESKTOP-RS3EG9A.localdomain :) insert into mytab2 select number ,'name'||toString(number) from numbers(5);

INSERT INTO mytab2 SELECT
    number,
    concat('name', toString(number))
FROM numbers(5)

Query id: cdfa4bd8-349e-4de1-a51e-e613a8973872

Ok.

0 rows in set. Elapsed: 0.003 sec.

DESKTOP-RS3EG9A.localdomain :) select * from mytab2;

SELECT *
FROM mytab2

Query id: d0b41070-9357-422d-8451-f737fee2344c

┌─id─┬─name──┐
│  0 │ name0 │
│  1 │ name1 │
│  2 │ name2 │
│  3 │ name3 │
│  4 │ name4 │
└────┴───────┘

5 rows in set. Elapsed: 0.005 sec.

DESKTOP-RS3EG9A.localdomain :)