INSERT INTO tbl(date, val) SELECT today(), number FROM numbers(10000)ctrl + ctbltable to insert generated data to | date, valcolumns to fill with generated data |
today()set today value for | , numberset |
numbers(10000)will generate 10k rows with | |
More of Clickhouse
- Convert datetime to unix timestamp
- Convert hex to text
- Select countIf usage example
- Create table example
- String concat
- Add row number to results
- List all tables from all database
- Select where date column is between dates
- Create table with UUID column
- How to get median value
See more codes...