Setting up a trigger to update one table from another table inside mySQL

Question

Ultimately what I'm trying to do is this:

When CCT1 is updated, also update CCT2.

What Row? The row with the matching ID (CCT1 ID:16 = CCT2 ID:16)

CCT1: ’O1cUxE_jet_cct_raffles.raffle_id’

CCT2: ’O1cUxE_rafflepro_tickets_setting.category_id’

From data entered into a specific column in CCT1: ‘O1cUxE_jet_cct_raffles.raffle_start_date’

I’d like to update a specific column in CCT2: ‘O1cUxE_rafflepro_tickets_setting.raffle_dates_from’

Here's what I've got so far... I'm sure its not even close haha.


CREATE TRIGGER `Update Raffle Ticket Pro` AFTER UPDATE ON `O1cUxE_jet_cct_raffles`
FOR EACH ROW UPDATE O1cUxE_rafflepro_tickets_setting
SET raffle_dates_from = O1cUxE_jet_cct_raffles.raffle_start_date
WHERE O1cUxE_rafflepro_tickets_setting.category_id = O1cUxE_jet_cct_raffles.raffle_name

In the trigger's query definition, replace both O1cUxE_jet_cct_raffles references with NEW. — Paul T.
– Paul T., Commented Mar 5, 2022 at 23:45

nbk · Accepted Answer · 2022-07-08 00:23:18Z

1

the old values before the UPDATE you get by using for example OLD.raffle_start_date

The updated Values you get by using for example NEW.raffle_start_date

CREATE 
    TRIGGER  `Update Raffle Ticket Pro`
 AFTER UPDATE ON `O1cUxE_jet_cct_raffles` FOR EACH ROW 
    UPDATE O1cUxE_rafflepro_tickets_setting 
      SET raffle_dates_from = NEW.raffle_start_date 
      WHERE O1cUxE_rafflepro_tickets_setting.category_id = NEW.raffle_name

edited Jul 8, 2022 at 0:23

answered Mar 5, 2022 at 23:55

nbk

49.6k8 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rob Johnson Over a year ago

YES! This did it... Thanks so much for your help... Can't thank you enough!!

Collectives™ on Stack Overflow

Setting up a trigger to update one table from another table inside mySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related