How to import CSV data to MySQL in JetBrains DataGrip

mysql csv import datagrip
Ilya Rusin picture Ilya Rusin · Jan 20, 2016 · Viewed 20.1k times · Source

I'm studying MySQL. I need to import data from a CSV file to a MySQL table using JetBrains DataGrip.

I've done such this job before in dbForge MySQL, but last week I moved from Windows to Linux.

There are some questions how to import CSV to MySQL on StackOverflow, but I'm still not so familiar with SQL.

How do I import a CSV data file in JetBrains DataGrip?

Thank you!

Answer

moscas picture moscas · Feb 29, 2016
  1. Context menu of datasource you want to import to
  2. Choose Import from File....
  3. Customize the table that will be created, check the preview and press OK.

Context menu Import Dialog

Related questions

MYSQL import data from csv using LOAD DATA INFILE

I am importing some data of 20000 rows from a CSV file into Mysql. Columns in the CSV are in a different order than MySQL table's columns. How to automatically assign columns corresponding to Mysql table columns? When I execute LOAD …

Read More
Import CSV to mysql table

What is the best/fastest way to upload a csv file into a mysql table? I would like for the first row of data be used as the column names. Found this: How to import CSV file to MySQL table …

Read More
How to import a csv file into MySQL workbench?

I have a CSV file. It contain 1.4 million rows of data, so I am not able to open that csv file in Excel because its limit is about 1 million rows. Therefore, I want to import this file in MySQL workbench. …

Read More