clickhouseHow to create temporary table
CREATE TEMPORARY TABLE tmp(id UInt64, name String)ctrl + cCREATE TEMPORARY TABLEwill create temp table (which is going to be deleted on user logout) | tmpname of the tmp table |
id UInt64, name Stringtemp table column declaration | |
More of Clickhouse
- Get total database size
- Create table example
- Using variables in queries
- List all tables from all database
- How to execute SQL query from a file
- List all users
- Select where date column is between dates
- Alter table query example
- Select countIf usage example
- Create AggregatingMergeTree materialized view
See more codes...