myt/exporters/trigger.sql

14 lines
328 B
MySQL
Raw Permalink Normal View History

2020-11-14 01:38:56 +00:00
SELECT
2022-02-02 04:05:31 +00:00
`TRIGGER_SCHEMA` AS `schema`,
`TRIGGER_NAME` AS `name`,
`DEFINER` AS `definer`,
`ACTION_TIMING` AS `actionTiming`,
`EVENT_MANIPULATION` AS `actionType`,
`EVENT_OBJECT_TABLE` AS `table`,
`ACTION_STATEMENT` AS `body`,
`CREATED` AS `modified`
FROM `information_schema`.`TRIGGERS`
2022-02-02 04:05:31 +00:00
WHERE ?
ORDER BY `name`