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
Project Budget$30 - $100 AUD
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online