Digital Marketing

Listing Stored Procedures from Databases in the MySQL Server

To show all stored procedures of a particular database, you use the following query: 

SELECT routine_name FROM information_schema.routines WHERE routine_type = 'PROCEDURE' AND routine_schema = '<database_name>'; 


Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

Install Letsencrypt ssl certificate on Glassfish