Online Documentation for SQL Manager for MySQL
Specifying data format parameters
Define parameters for reading data from the source file according to the description below.
Fields terminated by
Defines the character used for delimiting the field values in the source file.
Fields enclosed by
Defines the character used for quoting the field values in the source file.
If this option is selected, the Fields enclosed by character is used only to enclose values from columns that have a string data type (such as CHAR, BINARY, TEXT, or ENUM).
Fields escaped by
Controls how to read special characters. If the character is not empty, it is used as a prefix that precedes Fields enclosed by, Fields terminated by, Lines terminated by characters on output.
Lines terminated by
Defines the character used for delimiting strings in the source file.
Ignore lines count
Specifies the number of first lines in the source file that are not loaded.
Click the Next button to proceed to Loading data.