MySQL Advanced Five—Management of Stored Procedures

1. View the stored procedures of the database

For example:

show procedure status where db='caiwu';

2. View the list of stored procedures under the current database

For example:

SELECT specific_name from mysql.proc;

3. View the contents of the stored procedure

, such as:

select specific_name,body from mysql.proc;

4. View the contents of a stored procedure,

, such as:

select specific_name,body from mysql.proc where specific_name = 'p_updatenum';

5. Delete a stored procedure
such as:

drop procedure if exists p_update;

The above is the content of MySQL Advanced Five-Stored Procedure Management. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!