ClickHouse语法笔记

一、DDL基础

二、CRUD

1、修改

alter table school update name = 'hyf'
where id='1'

2、插入

insert into tb_user(id  , name , age) values(1,’zss’,21) ;

//插入多行
insert into tb_user (select * from log2);

3、查询

alter  table tb_update  delete  where  id=2