MySQL5.6不支持一個(gè)表有多個(gè)UPDATE/DELETE/INSERT觸發(fā)器。

下邊看一個(gè)例子：

創(chuàng)建三個(gè)測試表：

mysql> create table t_trig_test_01 (name varchar(10));

Query OK, 0 rows affected (0.07 sec)

mysql> create table t_trig_test_02 (name varchar(10));

Query OK, 0 rows affected (0.03 sec)

mysql> create table t_trig_test_03 (name varchar(10));

Query OK, 0 rows affected (0.03 sec)

創(chuàng)建兩個(gè)觸發(fā)器：

mysql> delimiter //

mysql> create trigger trg_test_01

    -> after insert on t_trig_test_01

    -> for each row

    -> begin

    -> insert into t_trig_test_02 select * from t_trig_test_01;

    -> end;

    -> //

Query OK, 0 rows affected (0.06 sec)

mysql> delimiter //

mysql> create trigger trg_test_02

    -> after insert on t_trig_test_01

    -> for each row

    -> begin

    -> insert into t_trig_test_03 select * from t_trig_test_01;

    -> end;

    -> //

Query OK, 0 rows affected (0.11 sec)

向表t_trig_test_01插入兩條測試數(shù)據(jù)：

mysql> insert into t_trig_test_01 values('steven');

Query OK, 1 row affected (0.01 sec)

mysql> insert into t_trig_test_01 values('steven');

Query OK, 1 row affected (0.01 sec)

查看三個(gè)表的數(shù)據(jù)：

mysql> select * from t_trig_test_01;

+--------+

| name |

+--------+

| steven |

| steven |

+--------+

2 rows in set (0.00 sec)

mysql> select * from t_trig_test_02;

+--------+

| name |

+--------+

| steven |

| steven |

| steven |

+--------+

3 rows in set (0.00 sec)

mysql> select * from t_trig_test_03;

+--------+

| name |

+--------+

| steven |

| steven |

| steven |

+--------+

3 rows in set (0.00 sec)

達(dá)到了預(yù)期的結(jié)果。