dbc_zt的博客

clickhouse 删除数据常见异常Expected one of: DATABASE, TEMPORARY, TABLEtruncate login_log_struct;Syntax error: failed at position 10:truncate login_log_struct;Expected one of: DATABASE, TEMPORARY, TABLE解决方案drop table login_log_struct;Code: 359. DB

clickhouse SHOW查询查看建表信息SHOW CREATE [TEMPORARY] [TABLE | DICTIONARY] [db.]table [INTO OUTFILE filename] [FORMART format];查看所有库SHOW DATABASES [INTO OUTFILE filename] [FORMAT format];打印所有的数据库列表， 该查询等同于 SELECT name FROM system.databases [INTO OUTFI