触发器 – 那啥快看

一、使用sql语句查看触发器

可以使用 SHOW TRIGGERS 语句查看触发器，\G 是为了查看方便

SHOW TRIGGERS \G

1	SHOW TRIGGERS \G

结果

*************************** 1. row ***************************
             Trigger: trigupdate
               Event: UPDATE
               Table: account
           Statement: INSERT INTO myevent VALUES(1,'after update')
              Timing: AFTER
             Created: 2020-02-24 14:07:15.08
            sql_mode: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
             Definer: root@localhost
character_set_client: gbk
collation_connection: gbk_chinese_ci
  Database Collation: latin1_swedish_ci
1 row in set (0.09 sec)

*************************** 1. row ***************************

Trigger: trigupdate

Event: UPDATE

Table: account

Statement: INSERT INTO myevent VALUES(1,'after update')

Timing: AFTER

Created: 2020-02-24 14:07:15.08

sql_mode: STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Definer: root@localhost

character_set_client: gbk

collation_connection: gbk_chinese_ci

Database Collation: latin1_swedish_ci

1 row in set (0.09 sec)

二、使用navicat工具查看触发器

2.1 选中database，再依次选“其它”、“触发器”即可

2.2 如何查看已写好的触发器语句

右键触发器名称—>对象信息—>DDL

三、总结

mysql触发器在哪里查看介绍完了，希望对您有帮助。