Kapalı

Mysql developer needed

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.

Beceriler: MySQL, Yazılım Mimarisi

Daha fazlasını görün: 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

İşveren Hakkında:
( 44 değerlendirme ) Ashfield, Australia

Proje NO: #4440738

8 freelancer bu iş için ortalamada 89$ teklif veriyor

rinsadsl

Let me get it done for you

1 gün içinde 80$ AUD
(87 Değerlendirme)
6.3
honeypotant

Please check PM. thanks.

1 gün içinde 103$ AUD
(9 Değerlendirme)
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.=========

in 0 gün içinde82$ AUD
(14 Değerlendirme)
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 !!

in 3 gün içinde69$ AUD
(34 Değerlendirme)
4.0
bearjob

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

in 0 gün içinde105$ AUD
(14 Değerlendirme)
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

in 3 gün içinde66$ AUD
(1 Değerlendirme)
2.1
mrlinh2710

Hello sir! I can help you.

in 0 gün içinde55$ AUD
(2 Değerlendirme)
1.9
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!

in 0 gün içinde99$ AUD
(0 Değerlendirme)
0.0
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.

1 gün içinde 100$ AUD
(0 Değerlendirme)
0.0
atharvsoftwares

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

1 gün içinde 126$ AUD
(0 Değerlendirme)
0.0