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

MySQL查看所有存储过程

WBOY
Release: 2016-06-07 14:56:38
Original
1913 people have browsed it

查询数据库中的存储过程 及存储过程或函数的创建代码 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;
Copy after login
show create procedure proc_name;
show create function func_name;
Copy after login
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template