The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable.

    Help ClickHouse documentation by editing this page

    mysql

    允许 要对存储在远程MySQL服务器上的数据执行的查询。

    参数

    • host:port — MySQL server address.

    • table — Remote table name.

    • user — MySQL user.

    • — User password.

    • — The ON DUPLICATE KEY on_duplicate_clause 表达式被添加到 INSERT 查询。

    其余的条件和 只有在对MySQL的查询完成后，才会在ClickHouse中执行采样约束。

    返回值

    与原始MySQL表具有相同列的table对象。

    MySQL中的表:

    从ClickHouse中选择数据:

    另请参阅