Navicat imports csv data into mysql

This article shares with you how to use Navicat to import csv data into mysql for your reference. The specific content is as follows

1. Get the csv data and use the office save as function to save the excel as csv (of course this is because my own data is in excel. If you already have csv data, ignore this step.)

2. Import with Navicat: Create a database at random, then click the Import Wizard in the table.

Select csv

Then keep going to the next step and you will see.

The import is successful at this moment.

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.