Shulou(Shulou.com)06/01 Report--

This article shares the specific code of Navicat for MySql visual import CSV file 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 import Wizard.

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

3. Select the .csv file to import, and note that the encoding format is the same as the file encoding format, otherwise there will be garbled, and then proceed to the next step

4. Select the delimiter I need. I use Linux, so the record delimiter of record delimiter is LF to represent the next line.

5. Adjust according to the content of your csv file. The number of lines in which the field name row field name is located, and first data row is the number of lines in which the first piece of data is located. Last data row can not be written out, the later time format I directly default, because my file does not have time data

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

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

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

9. Click start.

The import is successful without errors. You can view the imported data.

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.