Import / Upload CSV File to Mysql Using Windows Batch File

Web, Mobile & Software Dev Web Development Posted 3 years ago

Fixed Price

Budget: $10
Delivery by November 16, 2012

Start Date

November 15, 2012

Details

Hello Dear Programmers:

I am currently developing a system built on PHP and MySql. The system has the ability to upload csv file to MySQL using PHP scripts. The problem is, quite a little bit slow.

Now, I am thinking of uploading the file using a batch file. This would be more faster than the usual php script. Unfortunately, I am not familiar with batch file.

Can anyone help me solve the problem?

Below are the requirements:

1. Create a bat file that will upload or import the csv file.
2. In case the data to be uploaded is already existing in the database, it will just update some of the data.
3. The reference of the so that file will not be duplicated are the AgreementID and InsNum

I have attached the sample data to be uploaded as well as the mysql table.

---
Skills: import, batch-scripting

Open Attachment

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Hired: 1


About the Client

(4.96) 4 reviews

Philippines
Makati City 08:39 AM

20 Jobs Posted
25% Hire Rate, 1 Open Job

$339 Total Spent
6 Hires, 0 Active

Member Since May 30, 2012