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触发器已经被成功删除。