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

Editor to share with you the method of importing navicat into csv files, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

How does navicat import csv files?

1. Create a database, right-click the table and select the Import Wizard.

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

3, select your .csv file, pay attention to the encoding format, and your file encoding format is the same, otherwise garbled, the next step.

4. Select the delimiter I need. I use Navicat11, so I automatically select the field delimiter after selecting the file type. Next step.

5, the line here is not clear what is going on, but I directly according to the default value, there is no change, the next step.

6. If there is a corresponding table between the file name and the database, it will not be created here. If not, create a new table. Next.

7. Adjust the target field, data type, and next step.

8. If there is such a table in the database and there is no data, or there is no such table, choose to add it. Otherwise, copy it. Next step.

9. Click start.

10. If the error handling is zero, the import is successful, and you can see the imported data by refreshing the database.

The above is all the contents of this article "how to import navicat into csv files". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.