Bulk load from MySQL into file
Description
The Bulk load from MySQL into file action bulk loads data from a MySQL table into a file.
Options
| Option | Description |
|---|---|
Action name | The name of the workflow action. |
Connection | The database connection. |
Target schema | The target schema. |
Target File name | The target file. |
High Priority | The priority to load the file with. |
Type | OUTFILE, DUMPFILE |
Field separator | The field separator to use. |
Fields enclosed by | The field enclosure to use. |
Optionally enclosed | |
Lines terminated by | The line termination string to use. |
Names of columns | A comma separated list of columns to export |
Limit to the…first lines | Only export the first x number of rows |
If file exists | The action to take when the target file already exists:
|
Add file to result filenames | Add the target file to the result filenames |