Managing MySQL triggers

MySQL Triggers can be viewed, manipulated and deleted once it is created. The trigger file can be viewed using SELECT/SHOW statements and in data/databaseFolder/tableName.trg of MYSQL. The below command shows all the triggers of the table:

Syntax:

SHOW TRIGGERS;

The SELECT statement to view trigger is shown below. It displays all the triggers from entire database. The 'WHERE' condition can be applied to get the triggers of a particular database.

SELECT * FROM Information_schema.TRIGGERS;

To remove an existing trigger, we can use DROP TRIGGER statement. The syntax is:

DROP TRIGGER tableName.triggerName;

DROP TRIGGER tblresults.tgrVerdict;