Menu
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!
706
Import CSV There is a dedicated UI for importing DSV (CSV and TSV) files to the database. Click the schema you wish to import data to, and choose Import From File… from the context menu. Then select the CSV file where your data is stored. You will see the Import dialog window.
In DataGrip go to File > Open and select your mysql dump file. Then right click the tab for the file to get the context menu, and select "Run [your filename...]" option. It may ask you to select your schema to apply the run to.
52
Precision : The pinned answer explains how to create and populate a new table.
To populate an already existing table it's quite similar: use the context menu of this particular table to choose Import From File. Then the steps are similar to the ones in the pinned answer.
8
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
