mysql查询当前数据库已有的触发器信息

        今天做触发器相关的操作时遇到了一些问题，那就是我想查看我刚刚创建的触发器是不是创建成功了，是不是可以在TRIGGERS表中看到了，于是我就想查看一下关于TRIGGERS表的信息，在网上搜索了一番，没有找到我想要的答案，于是我便去了mysql官网查看官方文档，给出的解释是：

The TRIGGERS table provides information about triggers. To see information about a table's triggers, you must have the TRIGGER privilege for the table.

The TRIGGERS table has these columns:

• TRIGGER_CATALOG

  The name of the catalog to which the trigger belongs. This value is always def.

• TRIGGER_SCHEMA

  The name of the schema (database) to which the trigger belongs.

• TRIGGER_NAME

  The name of the trigger.

• EVENT_MANIPULATION

  The trigger event. This is the type of operation on the associated table for which the trigger activates. The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified).

• EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, and EVENT_OBJECT_TABLE

  As noted in Section 25.3, “Using Triggers”, every trigger is associated with exactly one table. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. The EVENT_OBJECT_CATALOG value is always def.

• ACTION_ORDER

  The ordinal position of the trigger's action within the list of triggers on the same table with the same EVENT_MANIPULATION and ACTION_TIMING values.

• ACTION_CONDITION

  This value is always NULL.

• ACTION_STATEMENT

  The trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding.

• ACTION_ORIENTATION

  This value is always ROW.

• ACTION_TIMING

  Whether the trigger activates before or after the triggering event. The value is BEFORE or AFTER.

• ACTION_REFERENCE_OLD_TABLE

  This value is always NULL.

• ACTION_REFERENCE_NEW_TABLE

  This value is always NULL.

• ACTION_REFERENCE_OLD_ROW and ACTION_REFERENCE_NEW_ROW

  The old and new column identifiers, respectively. The ACTION_REFERENCE_OLD_ROW value is always OLD and the ACTION_REFERENCE_NEW_ROW value is always NEW.

• CREATED

  The date and time when the trigger was created. This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers.

• SQL_MODE

  The SQL mode in effect when the trigger was created, and under which the trigger executes. For the permitted values, see Section 5.1.11, “Server SQL Modes”.

• DEFINER

  The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format.

• CHARACTER_SET_CLIENT

  The session value of the character_set_client system variable when the trigger was created.

• COLLATION_CONNECTION

  The session value of the collation_connection system variable when the trigger was created.

• DATABASE_COLLATION

  The collation of the database with which the trigger is associated.

        官方文档就是说，要查看TRIGGERS的相关信息，首先你得先有查看TRIGGERS TABLE的权限。然后介绍了TRIGGERS TABLE中有哪些列。

        有了权限以后（一般是有的，不用去授权），给出了一个查询示例如下：

亲测有效：

select * from INFORMATION_SCHEMA.TRIGGERSG

 由于没有针对查询，显示了很多的触发器相关信息，这里就不全截图了。

最后

以上就是醉熏白开水为你收集整理的mysql查询当前数据库已有的触发器信息的全部内容，希望文章能够帮你解决mysql查询当前数据库已有的触发器信息所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。