Online Documentation for SQL Manager for MySQL
Specifying data format parameters
Define parameters for writing data to the destination file according to the description below.
Fields terminated by
Defines the character used for delimiting the field values in the destination file.
Fields enclosed by
Defines the character that will be used for quoting the field values in the destination 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 write 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 starting by
Defines the characters that will be used for inserting before every string in the destination file.
Lines terminated by
Defines the characters that will be used for delimiting strings in the destination file.
Click the Next button to proceed to Saving data.