Friends, do you know how to import a data table in Navicat for MySQL? Today I will explain the tutorial of importing a data table in Navicat for MySQL. If you are interested, come and take a look with me. I hope it can help you.
Step 1 Select the data type. Open Navicat for MySQL, click the [Import Wizard] button, select the type of imported data, as shown in the figure below, select the Excel file.
Select Excel file type
Step 2: Select the file as the data source. After selecting the data type to import, the Select File as Data Source dialog box pops up. Click the Browse button to find the saved table file and select the table to be imported.
Select file as data source
It should be pointed out here: the system goes directly to step 4 after step 2. This may be a system bug. To give you a hint, here is an explanation.
Step 3: Define some additional options for the source file. The options in the red box in the picture below must be selected correctly, otherwise the correct import will not be completed.
Field name row: The row position where the data table field is located, enter 1 here;
The first data row: the row from which the imported source data starts. What I entered here is 2;
The last data row: the end row of the imported source data. What I entered here is 6.
Define some additional options for the source file
Step 4: Select the target table. After defining the additional items, click "Next" and select the target table. Here you can select an existing table or enter a new table name.
Select target table dialog box
Step 5: Define the corresponding relationship between the source field and the target field. Entering the next dialog box, you can define the field correspondence. If the target field has a primary key set, it must be checked in this step, otherwise the data will not be imported normally.
Define the corresponding relationship between the source field and the target field
Step 6: Select the import mode. If it is a new table, we choose the first option: Add. We can choose different options according to the specific situation. Interested friends can test the effects of each.
Select the required import mode
Step 7: After selecting the import mode, go to the next step and click the [Start] button in the lower right corner to execute the import command. After the import is completed, there will be a [Msg] message, as shown in the figure below.
Dialog box after import is completed
The above is the tutorial for importing data tables in Navicat for MySQL brought to you by the editor.All the content, I hope it can help everyone.
