Database triggers or triggers are SQL statements that are stored in the database catalog. Once triggers are activated by database events such as UPDATE, DELETE or INSERT, the triggers will execute either before or after the event that initiates them.
-
SQL trigger is an SQL statements or a set of SQL statements which is stored to be activated or fired when an event associating with a database table occurs.
-
MySQL finally supports one of the most important features of an enterprise database server which is called trigger since version 5.0.2. Trigger is implemented in MySQL by following the syntax of standard SQL:2003.
-
In this tutorial, you will learn how to write the first trigger in MySQL step by step.
-
In this tutorial you will learn how to retrieve information associating to a trigger. You also learn how to delete an existing trigger.