http://www.infotech.vip/db-clickhouse.html https://www.jianshu.com/p/a9623ad8fd69 https://www.jianshu.com/p/5ee63674a798 https://gitbook.cn/books/5dc5c2e6573506442c3b30c2/index.html

启动clickhouse-client

  1. root@ubuntu:~# clickhouse-client 
  2. ClickHouse client version 20.2.1.2183 (official build).
  3. Connecting to localhost:9000 as user default.
  4. Connected to ClickHouse server version 20.2.1 revision 54432.
  6. localhost :)

查看数据库列表

查看数据库列表：SHOW DATABASES

  1. localhost :) show databases;
  3. SHOW DATABASES
  5. ┌─name────┐
  6. │ default │
  7. │ system  │
  8. │ test    │
  9. └─────────┘
  11. 3 rows in set. Elapsed: 0.008 sec. 
  13. localhost :)