How can we see only name and types of the stored routines in a particular MySQL database?

MySQLMySQLi Database

We can write the following query to see only the name and types of procedures in a particular MySQL database. To make it understand we are using the database named ‘query’ −

mysql> Select Name, Type from mysql.proc where db = 'query';
+------------+-----------+
| Name       | Type      |
+------------+-----------+
| allrecords | PROCEDURE |
| Hello      | FUNCTION  |
+------------+-----------+
2 rows in set (0.18 sec)
raja
Published on 21-Feb-2018 07:37:15
Advertisements