存储过程
mysql> select * from mysql.proc;
Empty set (0.00 sec)
事件
mysql> select * from mysql.event;
Empty set (0.00 sec)
触发器
mysql> SELECT * FROM information_schema.`TRIGGERS`;
Empty set (0.01 sec)
函数
mysql> select `name` from mysql.proc where db = 'msg_history' and `type` = 'FUNCTION';
Empty set (0.00 sec)
--routines, -R
Included stored routines (procedures and functions) for the dumped databases in the output.
--triggers
Include triggers for each dumped table in the output. This option is enabled by default; disable it with
--skip-triggers. This option was added in MySQL 5.0.11. Before that, triggers are not dumped.
mysql> select * from mysql.proc;
Empty set (0.00 sec)
事件
mysql> select * from mysql.event;
Empty set (0.00 sec)
触发器
mysql> SELECT * FROM information_schema.`TRIGGERS`;
Empty set (0.01 sec)
函数
mysql> select `name` from mysql.proc where db = 'msg_history' and `type` = 'FUNCTION';
Empty set (0.00 sec)
--routines, -R
Included stored routines (procedures and functions) for the dumped databases in the output.
--triggers
Include triggers for each dumped table in the output. This option is enabled by default; disable it with
--skip-triggers. This option was added in MySQL 5.0.11. Before that, triggers are not dumped.