click house学习

发布时间 2023-04-01 15:19:10作者: 沙漠皇帝

创建表

create table blog(id UInt64,title String,content String,created_at DateTime)Engine=MergeTree order by id;

日期数据一般指定默认值

create table blog(id UInt64,title String,content String,created_at DateTime default now())Engine=MergeTree order by id;

插入测试数据

insert into blog(id,title,content) values(1,'测试1','有点小帅');

查询测试

select * from blog;