数据插入
sql
insert + values
insert into t1 ('sku_id','pay_money')
values ('sku_001', 123.00),
('sku_002', 345.11);
insert into t1
values ('sku_001', 123.00),
('sku_002', 345.11);
insert + select
insert into t1 select * from t2;
本地文件
clickhouse-client -q
cat /opt/module/inputData/ck/word.txt | clickhouse-client -q 'insert into learn_db.test_insert format CSV' --format_csv_delimiter=':'