MySQL Forums
Forum List  »  MySQL Workbench

Importing CSV Data
Posted by: Somnath Mukherjee
Date: August 01, 2019 08:05AM

Hi,

I am a newbie and hence unfamiliar with many aspects. Neither do I have any coding experience in any language.

Here is what I intend to do.

I have a folder which has around 20,000 csv files, all with the same column names. Each of them has a unique filename. I have created a schema which suits the data present in these csv files.

I want to import all of them either in one single table, in which case one column should be added to represent the filename from which they were imported, or, as different tables, such that the table name is the same as the file name.

If this is doable, then can you please help me out with a step by step guide ?

Thank you so much for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Importing CSV Data
186
August 01, 2019 08:05AM
115
August 01, 2019 08:46AM


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.