SQL Triggers update

In this case, the triggers update is triggered when you update a specific value in your table.

Initial input table:

triggers update

In case the ISEE is less than 10000 euro the fees are set to 750, this trigger is triggered only when we update a value in the Table.

update students
set ISEE=8000;

Output Table:

trigger update

Download full input date and SQL syntax

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button