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 | 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 | Load Data... context menu item.

• Setting source file name
• Selecting processing parameters
• Selecting fields for loading data
• Specifying data format parameters
• Loading data