how to identify the triggers applyed to (associted with) a table in mysql?

I need to know the triggers associated with the a particular table in mysql.

I need to delete it开发者_开发知识库 so.

Please help me. Thanks in advance.

List of associated triggers:

SELECT * FROM information_schema.triggers WHERE EVENT_OBJECT_SCHEMA = 'schema_name' AND EVENT_OBJECT_TABLE = 'table_name';

Use DROP TRIGGER command to delete one.