通过此方式可直接创建和mysql表一致的表
CREATE TABLE article_clientuser_sum ENGINE = MergeTree ORDER BY id AS SELECT * FROM mysql(‘host:port‘, ‘db‘, ‘article_clientuser_sum‘, ‘user‘, ‘password‘)
clickhouse通过mysql建表
原文:https://www.cnblogs.com/hemin809/p/15222295.html