The following is an implementation method. The idea is to try to use an incorrect statement in the trigger to interrupt code execution.
Mysql> create table t_control (id int primary key );
Query OK, 0 rows affected (0.11 sec)
Mysql> insert into t_control values (1 );
Query OK, 1 row affected (0.05 sec)
Mysql> create table t_bluerosehero (id int primary key, col int );
Query OK, 0 rows affected (0.11 sec)
Mysql> delimiter //
Mysql> create trigger tr_t_bluerosehero_bi before insert on t_bluerosehero
-> For each row
-> Begin
-> If new. col> 30 then
-> Insert into t_control values (1 );
-> End if;
-> End;
-> //
Query OK, 0 rows affected (0.08 sec)
Mysql> delimiter;
Mysql>
Mysql> insert into t_bluerosehero values (1, 20 );
Query OK, 1 row affected (0.25 sec)
Mysql> insert into t_bluerosehero values (2, 40 );
ERROR 1062 (23000): Duplicate entry '1' for key 'primary'
Mysql>
Mysql> select * from t_bluerosehero;
+ ---- + ------ +
| Id | col |
+ ---- + ------ +
| 1 | 20 |
+ ---- + ------ +
1 row in set (0.00 sec)
Mysql>
Or
Mysql> delimiter //
Mysql> create trigger tr_t_bluerosehero_bi before insert on t_bluerosehero
-> For each row
-> Begin
-> Declare I int;
-> If new. col> 30 then
-> Insert into xxxx values (1 );
-> End if;
-> End;
-> //
Query OK, 0 rows affected (0.06 sec)
Mysql> delimiter;
Mysql> delete from t_bluerosehero;
Query OK, 3 rows affected (0.05 sec)
Mysql> insert into t_bluerosehero values (1, 20 );
Query OK, 1 row affected (0.06 sec)
Mysql> insert into t_bluerosehero values (2, 40 );
ERROR 1146 (42S02): Table 'csdn. xxxx' doesn' t exist
Mysql>