clickhouse常用脚本语句

1.创建库和删除库

drop database IF EXISTS rt_db
CREATE DATABASE  rt_db ENGINE = Ordinary;
CREATE DATABASE  rt_db ENGINE = Atomic;

2.创建表

CREATE TABLE IF NOT EXISTS intellect_alarm_info
(
`id` UInt64 ,
`client_info_id