Mysql developer needed

CLOSED
Bids
10
Avg Bid (AUD)
$89
Project Budget (AUD)
$30 - $100

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.

Skills required:
MySQL, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 80
in 1 days
$ 103
in 1 days
$ 82
in 0 days
$ 69
in 3 days
$ 105
in 0 days
$ 66
in 3 days
Hire mrlinh2710
$ 55
in 0 days
$ 100
in 1 days
Hire ricardovsilva
$ 99
in 0 days
$ 126
in 1 days