Import multiple CSV files in one Mysql table.

[suhas mahajan]

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.