How execute a trigger SQL by condition?

Question

I need execute a trigger INSERT after adding row at table subscrubetousers with a condition:

subscrubetousers.SubscrubeToUsersType = 9

BEGIN
   INSERT INTO logsub Set 
   LogTime = NEW.subscrubetousersTime, 
   LogIdNote = NEW.subscrubetousersId, 
   LogType = NEW.SubscrubeToUsersType;
END

Ivan Cachicatari · Accepted Answer · 2014-10-13 16:11:16Z

2

Just add a condition to your trigger body:

BEGIN
   IF NEW.SubscrubeToUsersType = 9 THEN
       INSERT INTO logsub (LogTime,LogIdNote,LogType) 
       VALUES (NEW.subscrubetousersTime, NEW.subscrubetousersId,NEW.SubscrubeToUsersType);
    END IF;
END

answered Oct 13, 2014 at 16:11

Ivan Cachicatari

4,3143 gold badges24 silver badges41 bronze badges

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

6 Comments

Avinash Babu Over a year ago

can i know from where did this new came from ??

Ivan Cachicatari Over a year ago

It not possible... what is your goal?

Avinash Babu Over a year ago

i have sen a similar question like this ..which uses new in triggers ..is there something to do with new in triggers ??

Ivan Cachicatari Over a year ago

I still don't understand you, NEW is a reference to new record to be insert(ed) in table, you cam manipulate NEW as you need... now the question is: What is your needs/requirements/goals with this trigger?

Arsen Over a year ago

Thank you! Can you explain please with a Trigger Update?

|

Collectives™ on Stack Overflow

How execute a trigger SQL by condition?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related