Online Documentation for SQL Manager for MySQL

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.