Mysql developer needed

Closed

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: MySQL, Software Architecture

See more: what is record in data structure, get a developer today, mysql developer, mysql add record, mysql delete using, mysql append data, mysql append, mysql update values, update values mysql, mysql output table, data input output software, mysql remove table, mysql update table, data architecture structure, create read update delete, vaidhee, output table, mysql output, output data mysql, append record table, procedure mysql, mysql procedure, software needed mysql, processing mysql, mysql update column

Project ID: #4440738

8 freelancers are bidding on average $89 for this job

rinsadsl

Let me get it done for you

$80 AUD in 1 day
(87 Reviews)
6.3
honeypotant

Please check PM. thanks.

$103 AUD in 1 day
(9 Reviews)
4.5
abhius

======== Greetings. Dedicated and Professional committed to 100% completion and deadlines. Ready to start now. Sir, more details mentioned on message board please.=========

$82 AUD in 0 days
(14 Reviews)
4.4
farhaoui

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 !!

$69 AUD in 3 days
(34 Reviews)
4.0
bearjob

hello sir , iam ready to start now , please check PMB

$105 AUD in 0 days
(14 Reviews)
3.8
BadihBarakat

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

$66 AUD in 3 days
(1 Review)
2.1
mrlinh2710

Hello sir! I can help you.

$55 AUD in 0 days
(2 Reviews)
1.9
Crazometer

G'day vaidhee, I could finish this for you within 24hours. I have strong mysql experience and this should be no problem. Cheers, Justin.

$100 AUD in 1 day
(0 Reviews)
0.0
ricardovsilva

I have large experience in MySQL. I transformed all data processing of one FoxPro system in MySQL procedures. I'm your man, consider it done!

$99 AUD in 0 days
(0 Reviews)
0.0
atharvsoftwares

Hi, Thanks for creating the project. Let's Discuss and start it with get complete it in today.

$126 AUD in 1 day
(0 Reviews)
0.0