Viewing trigger information refers to viewing the definitions, status, and syntax of existing triggers in a database.
You can view trigger information using the following methods:
Using the
SHOWstatementobclient>SHOW TRIGGERS [FROM database_name];Here,
database_namespecifies the name of the database. IfFROM database_nameis not used, it means viewing trigger information for the current database.Using a view
obclient>SELECT * FROM information_schema.triggers [where trigger_name = 'xx'];If no query conditions are specified, it means viewing information for all triggers.