View Names and Types of Stored Routines in MySQL 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)