Simple MYSQL import script
- or -
Post a project like this3829
$10
- Posted:
- Proposals: 3
- Remote
- #340659
- Awarded
Description
Experience Level: Entry
Estimated project duration: 1 day or less
Hello, I am new over here and this is my first project.
I regularly get several small to medium scale projects where I need help. I'll need someone to regularly help me out with this.
For now I have the first project as below. Not much budget, but I'm just looking at what results I get.
--------------------------------------
I have a mysql table with the following fields:
- ID
- firstname
- lastname
- email
- type
I need to upload a CSV file with 50,000+ records. The CSV file will only have these fields:
- firstname
- lastname
- email
I need a simple upload script to
1: Check if the email already exists in the database, if it does exists change type field to 1
2. If the email already exists and the type field is already 1 it should not import the email.
3. Check the database for any email with type 1 and if it is not in the CSV file, delete it from the database
4. It should not timeout, it can be batched
Need this done probably within next few hours..
I regularly get several small to medium scale projects where I need help. I'll need someone to regularly help me out with this.
For now I have the first project as below. Not much budget, but I'm just looking at what results I get.
--------------------------------------
I have a mysql table with the following fields:
- ID
- firstname
- lastname
- type
I need to upload a CSV file with 50,000+ records. The CSV file will only have these fields:
- firstname
- lastname
I need a simple upload script to
1: Check if the email already exists in the database, if it does exists change type field to 1
2. If the email already exists and the type field is already 1 it should not import the email.
3. Check the database for any email with type 1 and if it is not in the CSV file, delete it from the database
4. It should not timeout, it can be batched
Need this done probably within next few hours..
Lisa G.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
0%
Last project
16 Oct 2013
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies