clickhouse的sql语法3之alter和show功能

ALTER TABLE 表名 DELETE WHERE 条件

ALTER TABLE 表名 UPDATE column1 = expr1 [, ...] WHERE filter_expr

ADD COLUMN [IF NOT EXISTS] name [type] [default_expr] [codec] [AFTER name_after]

alter table test_mergetree add column height String comment '高度' after id;

ALTER TABLE visits DROP COLUMN browser

alter table test_mergetree drop column ttt;

MODIFY COLUMN [IF EXISTS] name [type] [default_expr] [TTL]

ALTER TABLE test_mergetree MODIFY COLUMN height Int32 comment '高度';

show create table test_mergetree

show processlist

show grants