Manage Triggers in MySQL

Here you will learn how to manage triggers like modifying, removing etc.

To display the trigger use following sql:

SELECT * FROM Information_Schema.Triggers WHERE Trigger_schema = 'database_name' AND Trigger_name = 'trigger_name';

To view trigger:

SHOW TRIGGERS;

To drop a trigger:

DROP TRIGGER tbl_name.trigger_name

Namaste UI

For any types of queries, you can contact us on info[at]namasteui.com.

You may like:  Loop in MySQL stored procedures