'Not able to view triggers even the triggers are present in MySQL
I have 3 triggers present in three different tables. I want to list them all in MySQL
I have used multiple queries but all returning empty rows
show triggers;
select trigger_schema, trigger_name, action_statement from information_schema.triggers
select * from information_schema.triggers where information_schema.triggers.trigger_schema like '%my_db_name%'
SHOW TRIGGERS LIKE '<tablename>'
All the above queries returns nothing but the triggers are present
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
