search

Home  >  Article  >  Database  >  MySQL查看所有存储过程

MySQL查看所有存储过程

WBOY
WBOYOriginal
2016-06-07 14:56:381896browse

查询数据库中的存储过程 及存储过程或函数的创建代码 MySQL select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE'show procedure status; show create procedure proc_name;show create function func_name;

查询数据库中的存储过程 及存储过程或函数的创建代码 MySQL 
select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE'

show procedure status;
show create procedure proc_name;
show create function func_name;
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：增加自增列并复制为新表Next article：SQL Server 计算表记录数、当前自增值和占用空间

Related articles

See more