Navicat imports CSV data into MySQL

Time:2019-8-21

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.

Recommended Today

Think about open source project promoting rust search extension: quickly search rust documents in the browser address bar

Open source project name:Rust Search Extension Introduction to open source projects:Quick search for rust documents in the browser address barOpen source project type:teamProject creation time:2020 GitHub data:375 Star,18 ForkGitHub address:https://github.com/huhu/rust-search-extension Rust search extension is a plug-in that can quickly search rust documents, Crites, built-in properties and error codes in the browser address bar. It supports […]