Friends, do you know how to import data tables in Navicat for MySQL? Today I will explain Navicat for MySQL MySQL import data table tutorial guide, if you are interested, please come and take a look with the editor. I hope it can help everyone.
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 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 reminder, 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.
Fair name: The line of the data table field, enter 1 here 1;
The first data line: The import source data starts from the first line, I entered here 2;
The last data line: The import source data is over, and I enter 6 here.
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 source fields and target fields. 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 source fields and target fields
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 entire content of the tutorial guide for importing data tables in Navicat for MySQL brought to you by the editor. I hope it can help you.
