17.3.2 删除触发器示例

17.3.2　删除触发器示例

例如，删除名称为after_delete的触发器。

---

mysql> DROP TRIGGER after_delete;
Query OK, 0 rows affected (0.11 sec)

---

SQL语句执行成功，查看alter_delete触发器的信息。

---

mysql> SHOW CREATE TRIGGER after_delete \G
ERROR 1360 (HY000): Trigger does not exist

---

结果显示，MySQL报错，不存在alter_delete触发器，说明alter_delete触发器已经被成功删除。