MySQL Forums
Forum List  »  Triggers

Trigger with case possible?
Posted by: erwin traas
Date: September 09, 2023 08:23AM

Hello,

I'm rather new to triggers, here is what I want to do 'after update' on a certain table.

I want to check the value of a field like :

progress bigger the 0 but less then 100 -> insert a log into a second table
progress equals 100 -> insert another record into the second table

Can this be done by triggers?

Regards
Erwin

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger with case possible?
173
September 09, 2023 08:23AM


Sorry, only registered users may post in this forum.

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.