dbc_zt的博客

clickhouse 删除数据常见异常 Expected one of: DATABASE, TEMPORARY, TABLE truncate 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