Show procedure/function code in MySql

mysql function schema show procedure
User129 picture User129 · Aug 24, 2012 · Viewed 23.2k times · Source

Is there any options to view stored procedure/function code in MySql same as like "sp_helptext procedurename" in sql?

Answer

codelization picture codelization · Aug 24, 2012

try "SHOW CREATE PROCEDURE procedurename"

Related questions

Deprecated: mysql_connect()

I am getting this warning, but the program still runs correctly. The MySQL code is showing me a message in PHP: Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO …

Read More
How do I get SUM function in MySQL to return '0' if no values are found?

Say I have a simple function in MySQL: SELECT SUM(Column_1) FROM Table WHERE Column_2 = 'Test' If no entries in Column_2 contain the text 'Test' then this function returns NULL, while I would like it to return 0. I'm aware that …

Read More
How to raise an error within a MySQL function

I've created a MySQL function and would like to raise an error if the values passed for the parameters are invalid. What are my options for raising an error within a MySQL function?

Read More