From: Girish Talluru
Date: January 24 2013 6:41am
Subject: Stored procedure to update destination table from 3 source tables
List-Archive: http://lists.mysql.com/mysql/228876
Message-Id: <CABenTqYpxWyPF3u8NAStYAaVhcVUnMVcMhS2vfKzf9-4Udt5AA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=14dae93993c3d51de104d403182f

--14dae93993c3d51de104d403182f
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

*project table*

proj_id, proj_name, Proj_Type

1, test, dev

2, test1, infra

3, test2, BI

*quota table*

quota_id, proj_id, allot_type, allot_num

1, 1, java, 3

2, 1, architect, 1

3, 1, Jasper, 2

4, 2, unix admin, 2

5, 2, dba, 1

6, 2, nwk admin, 1

*tracking table*

track_id, proj_id, status,start_date, sch_end_date,end_date, update_date

1,1, started,dec 16 2012,feb 12 2013,,01 jan 2013

2,2, resource allocated, 01 jan 2013, 03 mar 2013, , 01 jan 2013

3,3, yet to start, 19 jan 2013, 19 apr 2013

*Destination table (Summary_Table)*

event_id, proj_id, proj_name, Proj_Type, allot_type, allow_num,
proj_start_date_sch_end_date, proj_status

1, 1, test,dev,java,3,16 dec 2012,12 feb 2013,started

2, 1, test,dev,architect,1,16 dec 2012, 12 feb 2013, started

3, 1, test,dev,jasper, 2, 16 dec 2012, 12 feb 2013, started


I have to write a stored procedure to load the destination table with the
information from all three source tables

and another procedure to update the records regularly in destination table
when ever there is a change in source tables such as project status changed
from started to delivered etc.

Can some one give me some sample procedures to achieve above please.

Thanks,
Girish Talluru

--14dae93993c3d51de104d403182f--