SQL

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

Back to top button