如何在 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.
routines
选项在 phpmyadmin
中可用.在您至少拥有一个存储过程之前,该链接在 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.
相关文章