MySQL学习笔记15：触发器_MySQL

CREATE TRIGGER 触发器名 BEFORE|AFTER 触发事件ON 表名 FOR EACH ROW 执行语句

mysql> CREATE TRIGGER trig1 AFTER INSERT    -> ON work FOR EACH ROW    -> INSERT INTO time VALUES(NOW());Query OK, 0 rows affected (0.09 sec)

CREATE TRIGGER 触发器名 BEFORE|AFTER 触发事件ON 表名 FOR EACH ROWBEGIN    执行语句列表END

mysql> DELIMITER ||mysql> CREATE TRIGGER trig2 BEFORE DELETE    -> ON work FOR EACH ROW    -> BEGIN    -> INSERT INTO time VALUES(NOW());    -> INSERT INTO time VALUES(NOW());    -> END    -> ||Query OK, 0 rows affected (0.06 sec)mysql> DELIMITER ;

mysql> SHOW TRIGGERS/G;*************************** 1. row ***************************             Trigger: trig1               Event: INSERT               Table: work           Statement: INSERT INTO time VALUES(NOW())              Timing: AFTER             Created: NULL            sql_mode:              Definer: root@localhostcharacter_set_client: utf8collation_connection: utf8_general_ci  Database Collation: latin1_swedish_ci

mysql> SELECT * FROM information_schema.triggers/G*************************** 1. row ***************************           TRIGGER_CATALOG: def            TRIGGER_SCHEMA: person              TRIGGER_NAME: trig1        EVENT_MANIPULATION: INSERT      EVENT_OBJECT_CATALOG: def       EVENT_OBJECT_SCHEMA: person        EVENT_OBJECT_TABLE: work              ACTION_ORDER: 0          ACTION_CONDITION: NULL          ACTION_STATEMENT: INSERT INTO time VALUES(NOW())

mysql> SELECT * FROM information_schema.triggers WHERE TRIGGER_NAME='trig1'/G*************************** 1. row ***************************           TRIGGER_CATALOG: def            TRIGGER_SCHEMA: person              TRIGGER_NAME: trig1        EVENT_MANIPULATION: INSERT      EVENT_OBJECT_CATALOG: def       EVENT_OBJECT_SCHEMA: person        EVENT_OBJECT_TABLE: work

mysql> DROP TRIGGER trig1;Query OK, 0 rows affected (0.04 sec)