MySQL Bulk Loader

Description

The MySQL Bulk Loader action loads data from a text file into a MySQL table.

Options

OptionDescription

Workflow action name

The name of the workflow action.

Connection

The connection to the MySQL database to use.

Target schema

The schema of the table to load.

Target table name

The name of the table to load into.

Source file name

The name of the file to load.

Local

Check this if the file is local.

Priority

The priority to load the file with.

Fields terminated by

The field terminator to use.

Fields enclosed by

The field enclosure to use.

Fields escaped by

The escape character to use.

Lines started by

The line start string to use.

Lines terminated by

The line termination string to use.

Fields

The fields to load, separated by comma (,).

Replace data

Check this option if you want to replace the data in the target data.

Ignore the first …​ lines

Ignores the first …​ lines in the text file.

Add files to result

Check this option if you want to re-use the filename of the text file in a next workflow action.