命令列建立Mysql觸發器

1.測試資料表情況：mysql> select * from t1;
+------+-------+
| id | name |
+------+-------+
| 1 | name1 |
+------+-------+
1 row in set (0.00 sec)

mysql> select * from t2;
+------+-------+
| id | name |
+------+-------+
| 1 | name1 |
+------+-------+
1 row in set (0.00 sec) 2.命令列中建立觸發器：mysql> delimiter //
mysql> create trigger test.t1_ai after insert on test.t1
    -> for each row begin
    -> update t2 set id=3;
    -> end//
Query OK, 0 rows affected (0.11 sec)該觸發器會將t1表中的新增記錄插入到t2表中 3.命令列中向t1表插入一條新紀錄：mysql> insert into t1 values(2,'name2');
Query OK, 1 row affected (0.05 sec) 4.再次查看資料表中的記錄情況：mysql> select * from t1;
+------+-------+
| id | name |
+------+-------+
| 1 | name1 |
| 2 | name2 |
+------+-------+
2 rows in set (0.00 sec)

mysql> select * from t2;
+------+-------+
| id | name |集裝箱運費
+------+-------+
| 1 | name1 |
| 2 | name2 |
+------+-------+
2 rows in set (0.00 sec)Tp-Link教程 可見，我們的觸發器確實生效了！5.命令列刪除觸發器：mysql>drop trigger t1.t1_ai;