Navicat for MySql Visual Import CSV File

This article shares the specific code of Navicat for MySql visual import of CSV files for your reference. The specific content is as follows

Version number: Navicate 12

1. Create a database, right-click the table, and import the wizard.

2. Select the format of the imported data file, next->

3. Select the .csv file to be imported. Note that the encoding format should be the same as the file encoding format, otherwise garbled characters will appear. Then proceed to the next step.

4. Select the required delimiter. I use Linux, so the record delimiter is LF to indicate the next line.

5. Adjust according to the content of your CSV file. Field name row is the row number where the field name is located, and first data row is the row number where the first data is located. The last data row can be left blank. I will use the default time format because my file does not have time data.

6. Select the table to import data into. If it does not exist, a table with the same name will be created. For example, if I have created the events table, the new table below will be empty.

7. Adjust the field information, data type, and primary key information in the selected data table, and click next.

8. Choose to add the data directly to the target table. If there is data in the table, you can select copy: clear all data and then import.

9. Click Start.

If there is no error, the import is successful and you can view the imported data

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.