myt/exporters/procedure.sql

15 lines
264 B
MySQL
Raw Permalink Normal View History

2020-11-14 01:38:56 +00:00
SELECT
2022-02-02 04:05:31 +00:00
`db` AS `schema`,
2020-11-14 01:38:56 +00:00
`name`,
`definer`,
`param_list` AS `paramList`,
2020-11-14 01:38:56 +00:00
`body`,
2022-02-07 14:43:12 +00:00
`sql_data_access` AS `dataAccess`,
`security_type` AS `securityType`,
`comment`,
2020-11-14 01:38:56 +00:00
`modified`
FROM `mysql`.`proc`
2022-02-02 04:05:31 +00:00
WHERE ? AND `type` = 'PROCEDURE'
ORDER BY `name`