Click here to Skip to main content
14,734,133 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

I need to create a after insert trigger in mysql.

I have 3 tables like this.

Table1

ProjectID(TestP), Site(st1,st2,st3)


Table2

ProjectName,ProjectID,ProjectDetails


Table3

ProjectName,ProjectDetails,Site


Now I have to write a trigger which will insert 3 row in Table3, when I am inserting 1 row in Table2 (TestProject,TestP,Details1)

The value should be like this in Table3

Row1 : TestProject,Details1,st1
Row2 : TestProject,Details1,st2
Row3 : TestProject,Details1,st3


Please somebody help me.
Posted
Comments
Sandeep Mewara 30-Apr-12 0:42am
   
And where are you stuck? Go ahead, try out.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900