Manage Triggers in MySQL

MySQL Best Practices

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

For any types of queries, you can contact us on info@namasteui.com.

Leave a Reply

Your email address will not be published. Required fields are marked *