Import / Upload CSV File to Mysql Using Windows Batch File
Closed - This job posting has been filled.
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