mysql查看存储过程执行情况 mysql 查看存储过程

mysql命令行查看存储过程表等常用命令，

查看table

mysql> show tables;
+--------------------+

select name from mysql.proc where db='your_db' and type='PROCEDURE';

mysql> select name from mysql.proc where db='XX' and type='PROCEDURE';
+-------------------+
| name              |
+-------------------+