MySQL Forums
Forum List  »  Triggers

Need help with a delete statement with joins
Posted by: Amin Baig
Date: January 14, 2017 03:43AM

Hi, I have the following sql statement in my trigger which is working fine:

INSERT INTO campaignplacedenom (id, campaign_id, campaignName, place_id, placeName) select new.id, new.campaign_id, campaignName, new.place_id, placeName from campaign pd join place pm on pm.id = new.place_id where pd.id = new.campaign_id


Can you guys help me with what should be the delete statement in the trigger and the update statement?

I am very new to mysql and having issues.

Thanks in advance.

Options: ReplyQuote


Subject
Views
Written By
Posted
Need help with a delete statement with joins
768
January 14, 2017 03:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.