SELECT * FROM `TRIGGERS`
|
TRIGGER_CATALOG | TRIGGER_SCHEMA | TRIGGER_NAME | EVENT_MANIPULATION | EVENT_OBJECT_CATALOG | EVENT_OBJECT_SCHEMA | EVENT_OBJECT_TABLE | ACTION_ORDER | ACTION_CONDITION | ACTION_STATEMENT | ACTION_ORIENTATION | ACTION_TIMING | ACTION_REFERENCE_OLD_TABLE | ACTION_REFERENCE_NEW_TABLE | ACTION_REFERENCE_OLD_ROW | ACTION_REFERENCE_NEW_ROW | CREATED | SQL_MODE | DEFINER | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | DATABASE_COLLATION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | sys | sys_config_insert_set_user | INSERT | def | sys | sys_config | 1 | NULL |
|
ROW | BEFORE | NULL | NULL | OLD | NEW | 2019-10-30 15:09:30.40 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sys | sys_config_update_set_user | UPDATE | def | sys | sys_config | 1 | NULL |
|
ROW | BEFORE | NULL | NULL | OLD | NEW | 2019-10-30 15:09:30.40 | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_... | mysql.sys@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | ins_film | INSERT | def | sakila | film | 1 | NULL |
|
ROW | AFTER | NULL | NULL | OLD | NEW | 2019-10-30 15:22:08.08 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | upd_film | UPDATE | def | sakila | film | 1 | NULL |
|
ROW | AFTER | NULL | NULL | OLD | NEW | 2019-10-30 15:22:08.09 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | del_film | DELETE | def | sakila | film | 1 | NULL |
|
ROW | AFTER | NULL | NULL | OLD | NEW | 2019-10-30 15:22:08.11 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | customer_create_date | INSERT | def | sakila | customer | 1 | NULL |
|
ROW | BEFORE | NULL | NULL | OLD | NEW | 2019-10-30 15:22:09.07 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | payment_date | INSERT | def | sakila | payment | 1 | NULL |
|
ROW | BEFORE | NULL | NULL | OLD | NEW | 2019-10-30 15:22:11.19 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci | |
def | sakila | rental_date | INSERT | def | sakila | rental | 1 | NULL |
|
ROW | BEFORE | NULL | NULL | OLD | NEW | 2019-10-30 15:22:12.62 | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_D... | root@localhost | utf8mb4 | utf8mb4_0900_ai_ci | utf8mb4_0900_ai_ci |
|