EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Selecting processing parameters


Define options for the LOAD DATA command. The description of these options is given below.

 

Load Data Wizard - Selecting processing parameters

 

 

Loading priority

 

RadioButton Low priority

Delays loading data until no other clients are reading from the table.

RadioButton Concurrent

Allows other threads to retrieve the data from the table while loading data is executed.

 

 

Duplicate key values

 

RadioButton Replace

Replaces the existing rows with the new rows that have the same unique key value.

RadioButton Ignore

Skips the input rows that duplicate an existing row on a unique key value.

 

Note: If you specify neither Replace nor Ignore option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored.

 

 

Click the Next button to proceed to the Selecting fields for loading step of the wizard.