SQLInsert

Input	Output	Alias
✗	✔

Description

Outputs data as a sequence of INSERT INTO table (columns...) VALUES (...), (...) ...; statements.

Example Usage

Example:

To read data output by this format you can use MySQLDump input format.

Format Settings

Setting	Description	Default
output_format_sql_insert_max_batch_size	The maximum number of rows in one INSERT statement.	65505
output_format_sql_insert_table_name	The name of the table in the output INSERT query.	'table'
output_format_sql_insert_include_column_names	Include column names in INSERT query.	true
output_format_sql_insert_use_replace	Use REPLACE statement instead of INSERT.	false
output_format_sql_insert_quote_names	Quote column names with "`" characters.	true