v.22.5New Feature
Add MySQLDump Input Format for Table Data Extraction
Add MySQLDump input format. It reads all data from INSERT queries belonging to one table in dump. If there are more than one table, by default it reads data from the first one. #36667 (Kruglov Pavel).Why it matters
This feature allows users to import data from MySQL dump files directly into ClickHouse by parsing theINSERT statements for a single table, simplifying the migration and integration process from MySQL to ClickHouse.How to use it
Use theMySQLDump input format when reading data. By default, it reads data only from the INSERT queries of the first table in the dump. To load data, specify the format as MySQLDump in the FORMAT clause of the INSERT query.