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.

 

Load Data Wizard - Specifying data format parameters

 

 

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.

 

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 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.