MySQL5.7新特性之单表支持多个DML触发器

点击(此处)折叠或打开

1. mysql> create table t_trig_test_01 (name varchar(10));
   
2. Query OK, 0 rows affected (0.07 sec)
   
3. 
   
4. mysql> create table t_trig_test_02 (name varchar(10));
   
5. Query OK, 0 rows affected (0.03 sec)
   
6. 
   
7. mysql> create table t_trig_test_03 (name varchar(10));
   
8. Query OK, 0 rows affected (0.03 sec)

点击(此处)折叠或打开

1. mysql> delimiter //
   
2. mysql> create trigger trg_test_01
   
3. -> after insert on t_trig_test_01
   
4. -> for each row
   
5. -> begin
   
6. -> insert into t_trig_test_02 select * from t_trig_test_01;
   
7. -> end;
   
8. -> //
   
9. Query OK, 0 rows affected (0.06 sec)
   
10. 
    
11. mysql> delimiter //
    
12. mysql> create trigger trg_test_02
    
13. -> after insert on t_trig_test_01
    
14. -> for each row
    
15. -> begin
    
16. -> insert into t_trig_test_03 select * from t_trig_test_01;
    
17. -> end;
    
18. -> //
    
19. Query OK, 0 rows affected (0.11 sec)

点击(此处)折叠或打开

1. mysql> insert into t_trig_test_01 values('steven');
   
2. Query OK, 1 row affected (0.01 sec)
   
3. 
   
4. mysql> insert into t_trig_test_01 values('steven');
   
5. Query OK, 1 row affected (0.01 sec)

点击(此处)折叠或打开

1. mysql> select * from t_trig_test_01;
   
2. +--------+
   
3. | name |
   
4. +--------+
   
5. | steven |
   
6. | steven |
   
7. +--------+
   
8. 2 rows in set (0.00 sec)
   
9. 
   
10. mysql> select * from t_trig_test_02;
    
11. +--------+
    
12. | name |
    
13. +--------+
    
14. | steven |
    
15. | steven |
    
16. | steven |
    
17. +--------+
    
18. 3 rows in set (0.00 sec)
    
19. 
    
20. mysql> select * from t_trig_test_03;
    
21. +--------+
    
22. | name |
    
23. +--------+
    
24. | steven |
    
25. | steven |
    
26. | steven |
    
27. +--------+
    
28. 3 rows in set (0.00 sec)