Closed

Mysql developer needed

This project received 10 bids from talented freelancers with an average bid price of $89 AUD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $100 AUD
Total Bids
10
Project Description

This is a tiny project - needs to be done in mysql - needs to be a procedure that can be executed to process input table and get the output table.
Needs to be done today !
We have a small data set that needs to be processed using a mysql procedure.


The procedure :

Input Data :
Name (NonUnique)
Code (NonUnique)
Type (NonUnique) [Takes three values A / C / D]
Col1
Col2
Col3
Col4
Orderdate

What needs to be done

Purpose of the procedure : Read input data and create a consolidated output

Output table structure - Same as Input but without the Type Column
Name
Code
Col1
Col2
Col3
Col4
Orderdate

Read Input date - Based on Type - Append / Delete or do nothing in the output.

If Type = A - Add the record to output
If Type = C - Just Update Col2/Col3/Col4
If Type = D - Remove record from Output.

The full procedure is like this

Truncate output table
Order Input table with Orderdate column : Orderdate is in the format - 20130201101010
Start processing as per rules provided above.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online