Online Documentation for SQL Manager for MySQL

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 columns for loading step of the wizard.