MySQL同步数据到ClickHouse_select table_name, group_concat( column_name,-CSDN博客

网站介绍:文章浏览阅读4.3k次。MySQL同步数据到ClickHouseMergeTree引擎1.查看表的主键从元数据表中SELECT TABLE_NAME ,GROUP_CONCAT(COLUMN_NAME) AS COLUMN_NAMEFROM INFORMATION_SCHEMA.KEY_COLUMN_USAGEWHERE TABLE_SCHEMA = 'database_name' AND constra..._select table_name, group_concat( column_name,