You have chosen to sponsor your bid up to a maximum amount of .
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 :
Type (NonUnique) [Takes three values A / C / D]
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
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.