clickhouse简单常用语句

1. 创建数据库

CREATE DATABASE if not exists cihon_dflzm  engine = ordinary;

2. 创建数据表

CREATE table test01(id UInt16, code String, name String, create_date date) engine = MergeTree(create_date,(id),8192);

3. 增：插入数据

insert into test01(id,code,name,create_date) VALUES(4,'004','GongDong',now());

4. 删：根据ID删除数据

ALTER table test01 DELETE  WHERE id = 1;

5. 全表查询数据

select t.* from test01 t ;

6. 改：根据ID修改数据

ALTER table test01 update code = '005' WHERE id = 3;

7.  添加字段

alter table test01 add column `remark` String DEFAULT '' COMMENT '备注/说明';

8. 修改表字段类型

alter table test01 modify column `remark` Nullable(String) DEFAULT NULL COMMENT '备注'; 

9. 删除表字段

alter table test01 drop column `remark`;

10. 按分区删除

ALTER TABLE db_name.table_name DROP PARTITION '分区(例如：时间20210514)'