q29191 发表于 2018-10-8 08:20:45

十一、MySQL触发器

mysql> CREATE TABLE myevent  
    -> (
  
    -> id int(11) DEFAULT NULL,
  
    -> evt_name char(20) DEFAULT NULL
  
    -> );
  
Query OK, 0 rows affected (0.03 sec)
  

  
mysql> CREATE TRIGGER trig_update AFTER UPDATE ON account
  
    -> FOR EACH ROW INSERT INTO myevent VALUES (1,'AFTER UPDATE');
  
Query OK, 0 rows affected (0.05 sec)
  

  
mysql> SHOW TRIGGERS \G
  
*************************** 1. row ***************************
  
             Trigger: ins_sum
  
               Event: INSERT
  
               Table: account
  
         Statement: SET @sum = @sum +NEW.amount
  
            Timing: BEFORE
  
             Created: NULL
  
            sql_mode:
  
             Definer: root@localhost
  
character_set_client: utf8
  
collation_connection: utf8_general_ci
  
Database Collation: utf8_general_ci
  
*************************** 2. row ***************************
  
             Trigger: trig_update
  
               Event: UPDATE
  
               Table: account
  
         Statement: INSERT INTO myevent VALUES (1,'AFTER UPDATE')
  
            Timing: AFTER
  
             Created: NULL
  
            sql_mode:
  
             Definer: root@localhost
  
character_set_client: utf8
  
collation_connection: utf8_general_ci
  
Database Collation: utf8_general_ci
  
2 rows in set (0.00 sec)


页: [1]
查看完整版本: 十一、MySQL触发器