Please Help: Multiple csv file into Mysql?

#1
[eluser]1mr3yn[/eluser]
I have 60 csv files and I had given a task to generate a report through that csv file,
Im using PhpMyAdmin to import (CSV using LOAD DATA)each one of them in MySQL. But the problem is, every time a new record added, it will overwrite the existing record or it will not retrieve the whole records.
The records is so vital, thats why Im making sure, that no single record is ignored.
Can anyone give me an idea, how to import/load csv file in most effective way.

Please Help!(The deadline of my Report is tomorrow).
If all the records is in the database, working with source codes is not a problem anymore!


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.