Welcome Guest, Not a member yet? Register   Sign In
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!




Theme © iAndrew 2016 - Forum software by © MyBB