mysql

    Parameters

    • host:port — MySQL server address.
    • table — Remote table name.
    • user — MySQL user.
    • password — User password.

    • on_duplicate_clause — The ON DUPLICATE KEY on_duplicate_clause expression that is added to the INSERT query.

      To specify on_duplicate_clause you need to pass 0 to the replace_query parameter. If you simultaneously pass replace_query = 1 and on_duplicate_clause, ClickHouse generates an exception.

    Simple WHERE clauses such as are currently executed on the MySQL server.

    Returned Value

    A table object with the same columns as the original MySQL table.

    Selecting data from ClickHouse:

    See Also