how to update a mysql table from a file??
Im am trying to set up a data-integration with a diamond vender so that I can make a diamond search application.
they said they can place a file on my server via ftp everyday in any format I want with the data.
so what I want to do is make a table on my DB to hold this data and make a script that can take that file and update the entire table with all the information from the file.
the problem is I dont know how to make a script to do that or what kind of file I would need.
If anyone can shed any light on this I would really appreciate it.
(By the way there will be around 40,000 diamonds/rows passed)