MySQL 5.7 Release Notes
To obtain metadata about triggers:
Query the
TRIGGERS
table of theINFORMATION_SCHEMA
database. SeeSection 24.3.29, “The INFORMATION_SCHEMA TRIGGERS Table”.Use the
显示创建触发器
statement. SeeSection 13.7.5.11, “SHOW CREATE TRIGGER Statement”.Use the
SHOW TRIGGERS
statement. SeeSection 13.7.5.38, “SHOW TRIGGERS Statement”.