rameshfaj Posted June 3, 2008 Share Posted June 3, 2008 I have a table say table1 which has fields like field1t1,field2t1....................... and another table say table2 which has fileds like field1t2,field2t2.............. Now I have to write a trigger such that every entry/insert in the table1 which has the fieldt1 with value 0(and not for other values),will insert a value in the table2. Now can I do this?Can anyone help me? Quote Link to comment Share on other sites More sharing options...
fenway Posted June 3, 2008 Share Posted June 3, 2008 You should probably consult the mysql refman on triggers... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.