MySQL Forums
Forum List  »  Newbie

THE CSV PROBLEM
Posted by: Filip Kettner
Date: October 08, 2024 12:57PM

Hello everyone,

First of all, thank you very much for this great community.

I hope you can help me.

I have been struggling for days with importing CSV files. The background is that I am currently doing an SQL course and would like to work with the CSV files provided.
I have already tried all possible variants that I can find on the Internet. I have also tried DBeaver. Without success.

I'm not sure whether I just lack basic knowledge or whether it is generally difficult to import CSV into SQL. How do you do it with data sets in CSV format that are too big for Excel?

I would like to view and analyze many data sets in CSV format later, so I need a solution for this problem. Or is this data format not recommended anyway?

I am uploading an example file here. The import actually worked, but there were always problems with the data type in the last column (Value). I think this was probably also due to the 1000 separators.

I have read countless instructions for importing files on the Internet. Nothing worked.

I hope you can give me a few tips on how to deal with this.


Many thanks and best regards

Options: ReplyQuote


Subject
Written By
Posted
THE CSV PROBLEM
October 08, 2024 12:57PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.