Import / Upload CSV File to Mysql Using Windows Batch File

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

Fixed Price

Delivery by November 16, 2012




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

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Proposals: 2

Hired: 1

About the Client

(4.96) 4 reviews

Makati City 08:22 AM

20 Jobs Posted
25% Hire Rate, 1 Open Job

$339 Total Spent
6 Hires, 0 Active

Member Since May 30, 2012