December 12, 2017 Brother Lian Learning Python class note----MySQL Trigger

MySQL Flip-flop

Format: 1, trigger definition:
CREATE TRIGGER trigger_name trigger_time trigger_event
On tbl_name for each ROW trigger_stmt

Description
# Trigger_name: Trigger Name
# Trigger_time: Trigger time, desirable value: before or after
# Trigger_event: Trigger event, desirable value: INSERT, update, or delete.
# Tb1_name: Specify on which table
# trigger_stmt: Triggers the processing of SQL statements.

Example:
Mysql> delimiter $$
Mysql> CREATE trigger Del_stu before delete on Stu for each row
Begin
INSERT into Stu_bak values (old.id,old.name,old.sex,old.age,old.addtime);
-End;
$$
Query OK, 0 rows affected (0.05 sec)

Mysql> delimiter;

December 12, 2017 Brother Lian Learning Python class note----MySQL Trigger