Triggers in MySQL

I. INTRODUCTION OF Triggers

Trigger (trigger), bind some code in advance for a table, and when this table data changes, the system will automatically call these bound code.

Event Type: Insert, delete, update

Trigger time: befor, after

Event object: Each record in the table (for rows)

There can be a maximum of 6 triggers per table. (There are 6 combinations of event type and trigger time, only one for each combination)

Second, create a trigger

-- Create a trigger delimiter $$ Create Trigger Insert  on  for Each row begin Update Set = - where =　　1; --SQL statements  End

Third, view the trigger
1. Show triggers [like ' pattern '];

Triggers in MySQL