如何在phpMyAdmin中查看我的存储过程? [英] How do I view my stored procedures in phpMyAdmin?

问题描述

我在phpMyAdmin中创建了一个存储过程

I created a stored procedure in phpMyAdmin

CREATE PROCEDURE Sample()
SELECT * FROM feedback

在哪里可以查看此过程?如果在phpMyAdmin中是不可能的，那么什么是具有编写，存储和查看存储过程，表等功能的良好程序?

Where could I view this this procedure? If it's not possible in phpMyAdmin, what is/are some good program(s) that have the feature to write, store, and view stored procedures, tables, etc?

推荐答案

在phpmyadmin中查看存储过程:

查询:

SELECT routine_definition
FROM information_schema.routines
WHERE 
routine_name = 'procedure_name' AND routine_schema = 'databasename';

这是在phpmyadmin中到达那里的方法.

Here's how to get there in phpmyadmin.

phpmyadmin中提供了 routines 选项.直到您拥有至少一个存储过程，该链接在PHPmyadmin中才可见.请参见上图，然后单击structure选项卡下的 routines 链接.

The routines option is available in phpmyadmin. The link is not visible in PHPmyadmin until you have at least one stored procedure. See the above image and click the routines link under structure tab.

这篇关于如何在phpMyAdmin中查看我的存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！