clickhouseConnect command line client to remote host
clickhouse-client -h 1.1.1.1 --port 9000 -u user --password pwd -d dbctrl + c1.1.1.1ip address of remote host | 9000port to connect to |
useruser name | pwduser password |
dbname of the database to connect to | |
More of Clickhouse
- Create table example
- How to execute SQL query from a file
- Get total database size
- List all tables from all database
- Using variables in queries
- List all users
- Alter table query example
- Select countIf usage example
- Select where date column is between dates
- Create AggregatingMergeTree materialized view
See more codes...