- 论坛徽章:
- 1
|
创建触发器触发器条件是insert,就无法执行 insert,如果触发器条件是delete,就无法执行delete,只能执行相反的动作,请协助看看原因。
mysql> create trigger chufaqi before delete on shuzi for each row insert into shuzi values (11,'wew','erere','dfd');
Query OK, 0 rows affected (0.01 sec)
mysql> select * from shuzi;
+----+------+---------+------+
| id | name | dizhi | sex |
+----+------+---------+------+
| 1 | ?? | ?? | ? |
| 2 | ?? | ???? | ? |
| 3 | ?? | ???? | ? |
| 3 | ? | beijing | qq |
+----+------+---------+------+
4 rows in set (0.00 sec)
mysql> delete from shuzi where id='1';
ERROR 1442 (HY000): Can't update table 'shuzi' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.
mysql> insert into shuzi values (11,'ddd','wewr','fgf');
Query OK, 1 row affected (0.05 sec)
|
|