MySQL Forums
Forum List  »  CSV Storage Engine

How to load multiple csvs from a hierarchy structure?
Posted by: Roberto B.
Date: March 24, 2014 04:12PM

Hi all,
i am on a Windows machime.
I have a directory A with many subdirectories A1, A2, ... An (some hundreds).
Each subdirectory Ax has some csv files Ax1 Ax2 ...Axm (some tens).
Each csv file has the same structure and i build the LOAD DATA INFILE statement to load the data on a mysql unique table.
LOAD DATA INFILE filename ....
How can i reiterate automatically the single load data infile to load all the csvs without moving them and regroup the csvs??
Any instruction to execute that?
Thanks for your help

Options: ReplyQuote

Written By
How to load multiple csvs from a hierarchy structure?
March 24, 2014 04:12PM

Sorry, you can't reply to this topic. It has been closed.

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.