This article shares how to use Navicat to import CSV data into MySQL for your reference. The details are as follows.
1. Get CSV data and save excel as CSV with office save as function. (Of course, this is the reason why my own data exists in excel, if you are CSV data, ignore this step.)
2. Import with Navicat: Set up a database and click the Import Wizard on the table.
Select CSV
Then go ahead and you’ll see.
Successful import at this moment.
The above is the whole content of this article. I hope it will be helpful to everyone’s study, and I hope you will support developpaer more.