Trigger Types Row Trigger In Database Explain

Types Of Triggers, What Is Row Triggers, Explain Row Triggers, How Row Triggers Works

Types Of Triggers:

Row triggers
Statement triggers
Before V/s after triggers

Row Triggers:
A row trigger is fired each time a row in the table is affected by the triggering statement.
For example, if an UPDATE statement updates multiple rows of a table, a row trigger is fired once for each row affected by the UPDATE statement.
If the triggering statement affects no rows, the trigger is not executed at all.
Row triggers should be used when some processing is required whenever a triggering statement affects a single row in a table.

Tweet