Triggers are code that we associate with a table to be executed when certain actions occur—for example, after a new
INSERT in the table
book. The action does not need to happen from within phpMyAdmin.
Contrary to routines that are related to an entire database and visible on the database's Structure page, triggers for each table are accessed from this specific table's Structure page.
Prior to MySQL 5.1.6, we needed the
SUPER privilege to create and delete triggers. In version 5.1.6, a
TRIGGER table-level privilege was added to the privilege system. Hence, a user no longer needs the powerful
SUPER privilege for these tasks.
In order to perform the following exercise, we'll need a new
author table. ...