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
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
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
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
You will learn how to manage triggers including listing, modifying and removing triggers in MySQL databases.