clickhouseHow to insert UUID into table
INSERT INTO utbl SELECT generateUUIDv4(), today(), 'Joe'ctrl + cutblname of the table with UUID column | generateUUIDv4generates UUID value |
today()sample value for | 'Joe'sample value for |
Usage example
INSERT INTO utbl SELECT generateUUIDv4(), today(), 'Joe';
SELECT * FROM utbl;output
┌─id───────────────────────────────────┬───────date─┬─col─┐
│ 4b06cbf8-96cc-4d85-8cfc-5cb905bf45d0 │ 2022-01-12 │ Joe │
└──────────────────────────────────────┴────────────┴─────┘More of Clickhouse
- Convert array to rows
- How to execute SQL query from a file
- Get total database size
- How to restart Clickhouse server
- List all tables from all database
- Select where date column is between dates
- Using variables in queries
- Select sumIf query example
- Select countIf usage example
- Get table size
See more codes...