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.

 

Save Data Wizard - Specifying data format parameters

 

 

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.

 

CheckBox Optionally

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.