MySQL Forums :: Data Warehouse :: Loading files automation using Load_data

Advanced Search

Loading files automation using Load_data
Posted by: Dhiraj Bhangale ()
Date: August 06, 2012 12:46AM

HI everyone,

I want to load more than 100 CSV files in every week to database. For the same i am using LOAD DATA functionality of MYSQL.

To automate it. I am extracting file name & related path in csv file using scripting & loading to the table. Now i have all csv files names & path in my database table.

I tried to create a prepared statement for LOAD DATA, where i was concatenating file name & file path to LOAD DATA statement in procedure using cursor to dynamically execute it.

But here LOAD DATA is not allowed in procedures.

Can anyone please help me to do so????

Please suggest.

Thanking you in advance.


Options: ReplyQuote

Subject Views Written By Posted
Loading files automation using Load_data 3146 Dhiraj Bhangale 08/06/2012 12:46AM
Re: Loading files automation using Load_data 1624 Rick James 08/07/2012 11:07PM

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.