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.
8 freelancers are bidding on average $89 for this job
======== Greetings. Dedicated and Professional committed to 100% completion and deadlines. Ready to start now. Sir, more details mentioned on message board please.=========
HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!
Would you like the procedures to be coded in PHP pages also? Ready to execute the project... Procedures to: 1. Create table 2. Input data based on type 3. Output data