MySQL Bulk File
Description
The MySQL Bulk File action bulk loads data from MySQL into a file.
Options
Option | Description |
---|---|
Workflow action name | The name of the workflow action. |
Connection | The database connection. |
Edit… | Edit the database connection. |
New… | Create a new database connection using the standard dialog. |
Wizard… | Create a new database connection using the wizard dialog. |
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 | |
Limit to the…first lines | |
If file exists | Create new with unique name, Do Nothing, Fail |
Add file to result filenames |