MySQL Triggers

In this section, you will learn how to work with MySQL triggers. By definition, a trigger or database trigger is a stored program that is executed automatically to respond to a specific event associated with table e.g.,  insert, update or delete.

Database trigger is powerful tool for protecting the integrity of the data in your MySQL databases. Database triggers are very useful to automate some database operations such as audit logging.

Introduction to SQL Trigger

code_122
A SQL trigger is a set of SQL statements stored in the database catalog. A SQL trigger is executed or fired whenever an event that is associated with a table occurs e.g., insert, update or delete.

MySQL Triggers Implementation

code_127
This tutorial introduces you to MySQL triggers implementation. In addition, we will show you how MySQL stores trigger definitions and the limitations of triggers in MySQL.

Create Trigger in MySQL

code_110
This tutorial shows you how to create a simple trigger in MySQL to audit the changes of a table. We will explain the syntax of the CREATE TRIGGER statement in detail.

Managing Trigger in MySQL

code_31
You will learn how to manage triggers including listing, modifying and removing triggers in MySQL databases.