MySQL 8.4 Release Notes
要获取触发器的元数据:To obtain metadata about triggers:
查询
INFORMATION_SCHEMA数据库的TRIGGERS表。参见 第 28.3.44 节,“INFORMATION_SCHEMA TRIGGERS 表”。Query theTRIGGERStable of theINFORMATION_SCHEMAdatabase. See Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”.使用
SHOW CREATE TRIGGER语句。参见 第 15.7.7.12 节,“SHOW CREATE TRIGGER 语句”。Use theSHOW CREATE TRIGGERstatement. See Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”.使用
SHOW TRIGGERS语句。参见 第 15.7.7.40 节,“SHOW TRIGGERS 语句”。Use theSHOW TRIGGERSstatement. See Section 15.7.7.40, “SHOW TRIGGERS Statement”.