Hi, I regularly import csv files into my database and I would like a procedure created that can do this automatically.
There are 10 or so csv files located in a directory on the server. Each of these files is associated with a table in the database. For each csv file, the associated table should be first truncated and then the new data loaded into the table.
Sometimes additional columns will be added to the csv files so it may be necessary to update the table structure (either by adding additional fields or dropping and recreating the table).
32 freelancers are bidding on average £231 for this job
Dear Sir i am mysql expert. i already developed the project that import csv file into database. i would like discuss with you about your project. thank you. Best Regard.
Hi, I am working as a web developer from the past five years. I believe in providing quality work with long term relation with clients . let discuss and start now. Please give a chance. thanks