Page Operations
Browse SpaceDescription
This step loads data from a text file into a MySQL table.
See also the MySQL reference page for the generated LOAD DATA command. (MySQL 5.0)
Options
| Option | Description |
|---|---|
| Job entry name | The name of the job entry. Note: This name has to be unique in a single job. A job entry can be placed several times on the canvas, however it will be the same job entry. |
| 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 job entry. |