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

Load Data Wizard


Load Data Wizard allows you to use the LOAD DATA INFILE native MySQL statement to read rows from a text file to a table at a very high speed. This command copies data from a file to a table, appending the data to whatever is in the table already. The file must be accessible to the server and the name must be specified from the viewpoint of the server. You can save your settings as a template any time for future use.

 

To start the wizard, right-click the table in DB Explorer, select the Data Manipulation | iconTools_LoadData Load Data... context menu item.

Alternatively, you can open the Data tab of Table Editor / View Editor, right-click the grid there, then select the Data Manipulation | iconTools_LoadData Load Data... context menu item.

 

menuLoadData

 

 

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.

 

 


See also:

Export Data Wizard

Import Data Wizard

Export as SQL Script

Save Data Wizard

Using templates