MySQL Forums
Forum List  »  Newbie

Automatic Import from CSV file
Posted by: Jakub Drhlik
Date: July 20, 2014 07:51PM

Hi All,

I am an average user of MySQL (Analyst). But the task I am facing is beyond my MySQL skills so I am hoping someone could help me out.

I have a daily report which is sent to a FTP server. The file comes out in CSV, and I need a script which will look into this CSV when delivered and update a table in the Database. I know how to execute this via LoadFile script but since I have 8 reports scheduled every day having it done automatically would be a great saver.

Any help would be greatly appreciated.

Jakub

Options: ReplyQuote


Subject
Written By
Posted
Automatic Import from CSV file
July 20, 2014 07:51PM


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.