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.campaign_id, campaignName, new.place_id, placeName from campaign pd join place pm on = new.place_id where = 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

Written By
Need help with a delete statement with joins
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.