MySQL Forums
Forum List  »  Knowledge Base

Import multiple CSV files in one Mysql table.
Posted by: suhas mahajan
Date: September 10, 2009 10:46PM

Hello all,
Scenario:

1. I have requirement where multiple CSV files should imported autoomatically in one table by appending it (myasql database).
E.g files a.csv has 10 record import in table A with 10 records then b.csv file has 20 records should get imported in table A i.e 10+20 records record in second file should append in table A.

I have written a batch script which import one csv file in mysql table but how can I achieve it for bulk or multiple files.

2. How can I import multiple files in multiple tables.
E.g - File a.csv, b.csv, c.csv (stored in one n/w folder) should get imported in Table a, b, c by using batch script.

Awaiting for your response.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Import multiple CSV files in one Mysql table.
12334
September 10, 2009 10:46PM


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.