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>'; 

Comments

Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership