O'Reilly logo

Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Triggers

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.

Note

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 INT column— total_page_count—in our author table. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required